lookup

i want a macro to search all of column A in multiple sheets for a date that has been put into an input box.

the matching dates have data corresponding to them in that row. i want the date and data from the row to then be copied into a new sheet.

Please Login or Register  to view this content.

this is what i have so far.

1:7 returns columns 1:7?
where do i specify where i want the data to be shown and do i need to write multiple lookup statements to search through the A columns in all the different sheets or can i get it to look in all of them at once?

Hello ~Lews Therin~,

Is the date located in the range of A3:G3000 or just in A3:A3000? If it is in A3:A3000, you don't to use VLOOKUP.

Hello ~Lews Therin~ ,

Thank you, that is perfectly clear. I'll write up a test macro.

Hello

This macro should be a start in the right direction. Whenever a valid date is entered, a new sheet will be added to the workbook. It would probably be a good idea to choose a name for this sheet.The macro could then verify the sheet's presence. The data could then either be appended or overwritten.

Please Login or Register  to view this content.