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.