PDA

View Full Version : Copying specific records from specific date period



ertan
06-19-2006, 03:12 AM
Need Help for copying specific records from specific date period.

I would like to extract records from specific date period (start and end date set manually) for the specific Product only.
Attached workbook (which adapted from another solution to different question at excel user group) partially will do the job.

Need your help to modify the code so I can manually set which column of data to extract. (only specific product which column number set by me)
Extraction should be with the column headers and before copying , previously extracted data should be cleared from destination.
(currently doesn?t copy the headers)


Thank you

lucas
06-19-2006, 06:57 AM
Hi ertan,
maybe this will get you started in the right direction:

ColNum = Sheets("Sheet1").[O4].Value

lucas
06-19-2006, 07:27 AM
This thread addresses your problem also:
http://vbaexpress.com/forum/showthread.php?t=8337

ertan
06-19-2006, 08:24 AM
thanks lucas,

link provided looks similar problem but mine is little different .
I dont want to copy entire row
just want to copy dates column and the cells under related column.(in example is column 3)

For example if set the copy the values under Product3 , it also copies
all the values under Product1 and Product2 ...which I dont need..

If Product Column No is set to 3 , I should be able to copy the values under
Product3 only.

thanks for your help