Hi all,
I am looking to gather data from Sheet (“NSF Log”) and copy it to Sheet (“Journal”) based on the date found in column “B” of Sheet (“NSF Log”). The intent is that using a command button, a message box will appear and the user can enter the date. The system will then look through column B of Sheet (“NSF Log”) to find the date and whenever there is a match, it will copy specific information on the corresponding rows as follows:
"NSF Log” copy columns “O” to “V” and paste it to “Journal” starting on “C17”.
“NSF Log” copy column “K” and paste it to “Journal” starting on “K17”.
“NSF Log” copy column “A” and paste it to “Journal” starting on “M17”.
Also, before copying the data to Sheet "Journal", I would like the system to erase any existing data from prior searches.
I have included a copy of the excel spreadsheet with sample data.
I don't know much about VBA, but any help is greatly appreciated!
Bookmarks