Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Re-entering data into a Database
I have constructed a database and enter data three different times. For
instance columns A-F are entered initially and conlumns G-Q are entered at later dates but must correspond with an existing inventory number. From using and index and nested matching funciton I have found the cells for which I need to enter the data such as "G7". However in writing my Macro I don't know how to place my cursor in this cell, since it changes with each entry, for instance the next entry may go in "G22", "P9", and so on. I am thinking it might require a loop starting with the cursor in row one and looping until the desire row is reached. If this is the case I need help on writing the macro, but if there is a better way please let me know. THANK YOU. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When entering data into excel spreadsheet cell, the page just jum. | Excel Discussion (Misc queries) | |||
When entering data into excel spreadsheet cell, the page just jump | Excel Discussion (Misc queries) | |||
Macros to tranfer data to database | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Entering data on template and then data going to a spreadsheet. | Excel Discussion (Misc queries) |