Import sheet & calculate values

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.

James,

Open your Intraday file, and create a Macro (View- Macro - Record Macro- Call it impCalc) and do what you describe above.

You can then amend the Code as necessary (e.g. rather than "hard coded" ranges, get the Code to find the last row and copy everything from Row 'whatever' to that last row to wherever you want).

If there are any problems, we can then focus on resolving the specifics, rather than having to create everything from scratch,

Ochimus

Ok I know how to import the sheets however I am fairly new to VBA & unsure of how to find the last row. Can you help me from there.