Hello,
I am a new to VBA and would appreciate any assistance.
I receive an Excel file each day with a variety of data. All of the data in this workbook is on Sheet1 Columns A through AE and the number of rows can vary. Column A contains the date for each entry in the following format 02/15/2018.
I have another workbook that I am using to track this data throughout the year and it has a sheet for each month (i.e. Jan 2018, Feb 2018, Mar 2018, etc).
I am trying to create a macro that would search through the rows of data in the file I receive each day and copy/paste the row(s) in the applicable sheet of the destination workbook. For example, a date of 01/10/2018 would paste to the first empty row in the Jan 2018 sheet, 02/15/2018 would paste in to the first empty row of the Feb 2018 sheet, etc.
Any thoughts on how to best accomplish this task?
Thank you in advance for any help you can provide!
Bookmarks