Postmaster383
New member
- Joined
- Jul 7, 2021
- Messages
- 9
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2013
[FONT="]I'm on a ship and I have a spreadsheet which I update daily at Noon, mainly for fuel and gas consumption. I have a hidden row which mirrors various data around the spreadsheet which is generated from various formula around the spreadsheet, this data is cell range Q56:Y56.[/FONT]
[FONT="]I want to click the "Noon" button and for the data to copy into the next available row in the table range Q:Y rows 4 to 53. I don't want it overwriting previous data but copying into the next blank row. So the data being copied and pasted is within the same worksheet.
[/FONT][FONT="]The various data I want to copy is in cells Q56:Y56 (not in the image below) and I want to press the NOON button and for it to paste into the next available row in my table (rather than manually entering it each day). So for Jul 6, it would paste into Row 20 columns Q:Y. If I was to press multiple times it would keep filling up the next available row to a maximum of Row 53 columns Q to Y. I don't think it's possible to record a macro to simulate this so will need some extra code.
Thanks in advance for any help given. [/FONT]
[FONT="]I want to click the "Noon" button and for the data to copy into the next available row in the table range Q:Y rows 4 to 53. I don't want it overwriting previous data but copying into the next blank row. So the data being copied and pasted is within the same worksheet.
[/FONT][FONT="]The various data I want to copy is in cells Q56:Y56 (not in the image below) and I want to press the NOON button and for it to paste into the next available row in my table (rather than manually entering it each day). So for Jul 6, it would paste into Row 20 columns Q:Y. If I was to press multiple times it would keep filling up the next available row to a maximum of Row 53 columns Q to Y. I don't think it's possible to record a macro to simulate this so will need some extra code.
Thanks in advance for any help given. [/FONT]