Ananthanand
New Member
- Joined
- Sep 27, 2021
- Messages
- 2
- Office Version
- 365
- 2019
- Platform
- Windows
Scenario:
We get an excel sheet everyday with details and need to fill a column called id from handwritten notes.
Is there a way , I can enter an initial value and then click on any cell and successive number is filled there ?
As in, first I would enter initial value 123 and
click on cell A1 it would be 123
click on cell A6 it would fill value 124 and then
click on cell A4 it would fill value 125.
I am open to any suggestions, I am new to VBA and macro and if some one could point me towards commands that could be used there, that would be great too. I have 1500 rows to be filled everyday and would be really thankful if someone could help me out.
Id (needs to entered from handwritten notes) | First Name | Last Name | DOB | Ind |
C123 | ||||
C130 | ||||
C125 | ||||
C126 | ||||
C124 | ||||
C127 | ||||
C128 | ||||
C131 | ||||
C129 |
We get an excel sheet everyday with details and need to fill a column called id from handwritten notes.
Is there a way , I can enter an initial value and then click on any cell and successive number is filled there ?
As in, first I would enter initial value 123 and
click on cell A1 it would be 123
click on cell A6 it would fill value 124 and then
click on cell A4 it would fill value 125.
I am open to any suggestions, I am new to VBA and macro and if some one could point me towards commands that could be used there, that would be great too. I have 1500 rows to be filled everyday and would be really thankful if someone could help me out.