I compile two reports -- workbook#1 is granular and for my own reference. workbook#2 is less granular for company owners. Owner does not look at workbook#1
I compile workbook #1 manually with numbers in and numbers out of multiple products across several divisions for each lagging business day (anywhere between 1 -3 business days lagging depending on availability of data). When that is completed, I take the sum total of the in's and out's per division and post it to workbook#2 based on that day's business. The dates on workbook#2 are filled in for the year (per the owner's request). A separate sheet takes the workbook#2 data and prints it in a format the owners specifically wants. Workbook#1 contains a cell with the business date (H2) I am logging.
Goal: Take the sum total of each set in workobok#1 and post it to the proper spot in workbook#2 based on the date cell value (H3) in workbook#1. I can piecemeal pieces of the code together but I can't figure out how to take a cell value (H3) in workbook#1 and find the corresponding value in a named range in another workbook file path, then offset as required.
side note: i have 7 divisions to run this code against (14 sums total and placed respectively), instead of copy and pasting the code 14 times, is there a way you can define 14 range variables and 14 offsets, then loop through those instead?
I compile workbook #1 manually with numbers in and numbers out of multiple products across several divisions for each lagging business day (anywhere between 1 -3 business days lagging depending on availability of data). When that is completed, I take the sum total of the in's and out's per division and post it to workbook#2 based on that day's business. The dates on workbook#2 are filled in for the year (per the owner's request). A separate sheet takes the workbook#2 data and prints it in a format the owners specifically wants. Workbook#1 contains a cell with the business date (H2) I am logging.
Goal: Take the sum total of each set in workobok#1 and post it to the proper spot in workbook#2 based on the date cell value (H3) in workbook#1. I can piecemeal pieces of the code together but I can't figure out how to take a cell value (H3) in workbook#1 and find the corresponding value in a named range in another workbook file path, then offset as required.
side note: i have 7 divisions to run this code against (14 sums total and placed respectively), instead of copy and pasting the code 14 times, is there a way you can define 14 range variables and 14 offsets, then loop through those instead?
