Sophia
10-17-2019, 02:08 PM
Hi Guys,
I need help with transfering data from one Multi sheet Workbook with "not fixed" Sheet name (change each time) using Macro
Steps:
I need to add date from cell G6 (will stay fixed for all sheets) from Workbook A to Workbook B column A
Payment method from Column E from Workbook A will go to Column B Workbook B
Then to add doc_num from cell G5 (will stay fixed for all sheets) from Workbook A to Workbook B column C
Most complicated part is transferring amount first of all column A B C of Worksheet A need to be combined in this format A-B-C (example 1-4111-702) and then match against row 2 in Workbook B and add Amount from column H of Workbook A under relevant cell
If same code repeated few times it is better to add total value as in highlighted in cell F3
If Payment method is different new line needs to be created as in example row 5 and 6
This is continuous process file need to be updated (next info need to be added to new row under pervious data) each week for reconciliation so every week new Workbook will be received with new multiple sheet
Amount in column F workbook A need to be ignored
Sort new data upload by date Ascending order
Note files are attached.
Thanks in advance
Sophia
I need help with transfering data from one Multi sheet Workbook with "not fixed" Sheet name (change each time) using Macro
Steps:
I need to add date from cell G6 (will stay fixed for all sheets) from Workbook A to Workbook B column A
Payment method from Column E from Workbook A will go to Column B Workbook B
Then to add doc_num from cell G5 (will stay fixed for all sheets) from Workbook A to Workbook B column C
Most complicated part is transferring amount first of all column A B C of Worksheet A need to be combined in this format A-B-C (example 1-4111-702) and then match against row 2 in Workbook B and add Amount from column H of Workbook A under relevant cell
If same code repeated few times it is better to add total value as in highlighted in cell F3
If Payment method is different new line needs to be created as in example row 5 and 6
This is continuous process file need to be updated (next info need to be added to new row under pervious data) each week for reconciliation so every week new Workbook will be received with new multiple sheet
Amount in column F workbook A need to be ignored
Sort new data upload by date Ascending order
Note files are attached.
Thanks in advance
Sophia