Moving data from one worksheet to another

Closed
hotchy3571 Posts 1 Registration date Wednesday March 31, 2010 Status Member Last seen March 31, 2010 - Mar 31, 2010 at 10:05 AM
 Blocked Profile - Apr 2, 2010 at 04:45 AM
I am using a userform in excel 2003 to enter budget data onto a spreadsheet (sheet1). That data includes a cost code, date, value, order no. I want to be a able to copy the rows of data from sheet1 into other worksheets labelled April, May, June, July etc dependant on the dates listed in column C i.e all rows with April in column C to be copied to worksheet April, all rows with May to be copied to worksheet May etc.

Any help would be very gratefully received.

1 reply

Blocked Profile
Apr 2, 2010 at 04:45 AM
Hi,

To solve this just follow these steps here:

https://ccm.net/faq/6662-excel-selectively-transfer-data-to-pre-defined-range

Thanks
0