I have 3 workbooks. One workbook called "Intraday.xls" Report, one called "Sales.xls" & the last one called "Customer Service.xls". I would like a macro that would copy the sheet from "Sales.xls" & put that info on the sheet in "Intraday.xls" called "Intraday (Sales)" & then copy the sheet from "Customer Service.xls" & put that info on the sheet in "Intraday.xls" called "Intraday (CS)". Once those are imported then in workbook called "Intraday Report.xls" on sheet(Over-Unders) I would like it to pull the values based on the date (example: C10=Date, find that date on sheet ("Over-Unders") and preform the calculation to take "AD33" - "V33" and put that value on sheet(Over-Under). Worksheet("Intraday (sales) would go under the Sales column on worksheet(Over-unders) CS would go under the customer service column. I have attached all the worksheets & workbooks to help you understand what I am looking for. The reports that are generated (Sales.xls & Customer Service.xls) are auto generated so it looks like there are spaces in between each half hour intervals. Any help would be greatly appreciated and thank you so much in advance.
Bookmarks