New Student 2020
New Member
- Joined
- Sep 1, 2020
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
Hi
I work with various worksheets for stock control in out store and as the column in each sheet is updated regularly downwards so I would like to be able to get the latest value from the column ( same in each sheet = G) copy and paste it in the main worksheet (Products List) against each product name (B2)... I have started the code to find the last cell with value in one sheet as follows:
Sub Last_Col ()
Range (“G100000”).End(xlUp). Select
But I do not know how to copy the value and paste it in B2!??
Also if I want to run the same macro for all my sheets how can I do it and copy each value to a different cell in sheet ProductsList ?
Thank you very much for your help
Franco
I work with various worksheets for stock control in out store and as the column in each sheet is updated regularly downwards so I would like to be able to get the latest value from the column ( same in each sheet = G) copy and paste it in the main worksheet (Products List) against each product name (B2)... I have started the code to find the last cell with value in one sheet as follows:
Sub Last_Col ()
Range (“G100000”).End(xlUp). Select
But I do not know how to copy the value and paste it in B2!??
Also if I want to run the same macro for all my sheets how can I do it and copy each value to a different cell in sheet ProductsList ?
Thank you very much for your help
Franco