lost_in_the_sauce
Board Regular
- Joined
- Jan 18, 2021
- Messages
- 128
- Office Version
- 365
- Platform
- Windows
Not sure where to even begin with this one.
Each month we get an invoice for all out corporate credit cards. I take this and copy/paste into an excel file where each tab is a different person/card with drop downs for the individual to select funtion and account for each transaction. The file has a VBA code that sends each tab separately to the person whose email in in a cell at the top.
When returned, I have another VBA code to take all the individual files and compile them into one workbook again.
The time intensive part here is going through sheet by sheet to copy paste back and put into the format block required for upload into out Great Plains accounting software.
Is there a way to have a tab with the header information for each card in place, and scrape the individual tabs to the GL information, considering the amount of rows of transaction data will vary from cardholder to cardholder?
Each month we get an invoice for all out corporate credit cards. I take this and copy/paste into an excel file where each tab is a different person/card with drop downs for the individual to select funtion and account for each transaction. The file has a VBA code that sends each tab separately to the person whose email in in a cell at the top.
When returned, I have another VBA code to take all the individual files and compile them into one workbook again.
The time intensive part here is going through sheet by sheet to copy paste back and put into the format block required for upload into out Great Plains accounting software.
Is there a way to have a tab with the header information for each card in place, and scrape the individual tabs to the GL information, considering the amount of rows of transaction data will vary from cardholder to cardholder?
