Hi All.. excel vba request.jpg
I am trying to find a way to create individual files with monthly activity for each brand and save it.
There is a specific inventory report format we use that has our address and date see attached inventory report.jpg
I just need a figure out a way to take the massive sheet with all of the data and break it down to individual sheets.
currently its all copy paste manually . Could use your help to figure out how best to expedite the process by using a macro .
tried doing it with recording the macro but it does not seem to do all of the name changes and or set the page break to fit within one page of landscape mode.
thanks for your help.
Bookmarks