Alpha Magus
New Member
- Joined
- Sep 15, 2014
- Messages
- 1
Hello, I am completely new to Excel and was wondering if anybody could please help?
I have two tabs.
The first is for data entry and contains columns A:S.....Called Data
The second contains calculations based on the data tab and contains columns A:X......called calculations. So there will always be the same amount of rows in both tabs.
Currently if somebody has just entered data into for example row 25 of the data tab, then I would go into the calculations tab and drag down the formulas from row 24 down into the new entry.....But is there a quick way to do this with a macro?
Currently if I used the macro recorder, it only points to the 25 row data and will not go beyond that. I cannot seem to program the autofill range correctly.
Many Thanks in advance.
I have two tabs.
The first is for data entry and contains columns A:S.....Called Data
The second contains calculations based on the data tab and contains columns A:X......called calculations. So there will always be the same amount of rows in both tabs.
Currently if somebody has just entered data into for example row 25 of the data tab, then I would go into the calculations tab and drag down the formulas from row 24 down into the new entry.....But is there a quick way to do this with a macro?
Currently if I used the macro recorder, it only points to the 25 row data and will not go beyond that. I cannot seem to program the autofill range correctly.
Many Thanks in advance.
Last edited: