I have two workbooks, Workbook A and Workbook B. Workbook A has data hat I need to input into a specific worksheet (let's call it "Data") in Workbook B. The data I need from Workbook A is in A18:AM18.I need it copies into Workbook B in the "Data" worksheet. However I need to do this each month, and the location where the data needs to go changes because it is updated each month. I would like to post the data in the first empty row starting at column D and going to column AP. In the same row, would like to input "APAC" into column C, and pull down the existing formulas from the cells above in columns A and B. I also need this to be created into a button so I can push it each month ad the report updates.
Thank you very much in advance!
Thank you very much in advance!