Moving data from one worksheet to another [Closed]

Report
Posts
1
Registration date
Wednesday March 31, 2010
Status
Member
Last seen
March 31, 2010
-
 Blocked Profile -
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


Hi,

To solve this just follow these steps here:

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

Thanks

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!