Posted by Martin Brennan on September 05, 2000 5:11 AM
Most of my experience is using the macro recorder and then trying to improve it and speed up the process. I am new to a lot of this.
I have a spreadsheet which comprises three columns by, up to, 20,000 rows. The first column is date, second and third columns are prices. All data is entered in date order, several entries per day and I do not want to amend that order at all. Entries for any one date could range from 8 for the day up to 4000 for that day.
I want to be able to specify a range by entering a date in an input box and then using a VBA macro, find all entries for that date and transfer all info (i.e., A1:C10 or A1:C3705, say) to another spreadsheet for analysis.
I could use a loop, but I think it could take an age to complete, I think I can use "Find, xlDown", (to find first), followed by A65536, "Find, xlUp" (or something similar), but I wonder if there is a better way. Any bright ideas anyone?