Copy and paste values automatically to empty cells below
Closed
m22capital
TrowaD
- Posts
- 1
- Registration date
- Saturday April 15, 2017
- Status
- Member
- Last seen
- April 15, 2017
TrowaD
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Related:
- Copy and paste values automatically to empty cells below
- Formula to copy and paste values in excel automatically - Guide
- Excel, filling in cell values automatically ✓ - Forum - Excel
- Pasting values in filtered cells ✓ - Forum - Excel
- It restricts what values are possible for cells that contain numbers, dates, and text ✓ - Forum - Excel
- How to make a macro run automatically when a cell value changes - Guide
1 reply
TrowaD
Apr 24, 2017 at 11:57 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Apr 24, 2017 at 11:57 AM
Hi m22capital,
How do you start a 'roll'?
When you use a command button, then you can add to that code. Copy the 3 cells and paste them to the first available row on a new sheet (Sheets("Sheet2").Range("A"&rows.count).end(xlup).offset(1,0).pastespecial)
As for the sum calculation use the 1st or 2nd row for that and total the entire column. No need to continually adjust the formula.
Can you make this work?
Best regards,
Trowa
How do you start a 'roll'?
When you use a command button, then you can add to that code. Copy the 3 cells and paste them to the first available row on a new sheet (Sheets("Sheet2").Range("A"&rows.count).end(xlup).offset(1,0).pastespecial)
As for the sum calculation use the 1st or 2nd row for that and total the entire column. No need to continually adjust the formula.
Can you make this work?
Best regards,
Trowa