# Rows in Excel VBA Macros

I need help in being able to do the following:

• In Worksheet A I have raw data.
• In Worksheet B I have a template with formulas.
• The data on Worksheet A change on a weekly basis.

I need to find a way to select the raw data from Worksheet A and insert it in Workbook B. The formulas of Workbook B are at the right of where raw data should be entered and also down at the end of the raw data. Clearly my problem is that I have totals and the number of rows of raw data change.

-
Can you post in what you've tried thus far? –  variant Apr 25 '12 at 21:39

lngLastRow = Cells.Find("*", searchorder:=xlByRows, searchdirection:=xlPrevious).Row