manipulating text

[Me]

I have a work opportunities spreadsheet that I am designing. I have many
fields such as date of opportunity, sales type, customer name, month
sale will close, sale value etc.

At the moment, I enter all data into the current month tab(october) then
work my way through each category adding my data until I finally
select the month the sale will close. If I select the sale to close in
november, i want the data from that opportunity to automatically move to
the november tab and delete from the october tab.

Example:

Date of Opp, cust name, sale type, sale close date

If I select from a drop down validation list a sale close date of
November for example.


I want to have the spreadsheet Automatically select that entire row for
that opportunity and move it into the november opportunities tab
automatically, instead of having to move this manually each day. I also
want the row from the original October tab where this data was initially
entered to be deleted from the october tab and to only remain in the new
november tab.

Any help will be greatly appreciated.

 

[carlo]

I have a work opportunities spreadsheet that I am designing. I have many
fields such as date of opportunity, sales type, customer name, month
sale will close, sale value etc.

At the moment, I enter all data into the current month tab(october) then
work my way through each category adding my data until I finally
select the month the sale will close. If I select the sale to close in
november, i want the data from that opportunity to automatically move to
the november tab and delete from the october tab.

Example:

Why don't you create a userform, where you can enter
this data and when finished (including the selection of
the month) press a button, which runs a macro to
put your data into the according sheet.

hth

Carlo

PS: if you need help, just ask