Hi,
I want to merge multiple worksheets (twenty monthly) into a single master worksheet,
the worksheets tab are called by the date they are sent for approval, i.e. June 15, June 16. and so on.
Once all the data is in one sheet, I do totals by Employee Name (about 21 employees)
I've been doing this by using copy and paste command, but this method is time-consuming and easy to duplicate information.
The goal is to prepare a report showing the total by employee name.
Note: I am not familiar with VBA
all worksheets have the same columns in this order:
vendor Name / Invoice# / Amount / EE Name
Thank you in advance for your help.
Bookmarks