I have a sheet populated from an oracle
database.That table has two columns(of many) ,which have parent child relationship.If I want to insert a new record I add a new row, run some macros to protect data integrity as it kind of screws up the whole relationship.Fill other columns and insert into database.
Now since my column is always off by one hence it creates a little bit of confusion for other users to find what the parent number is, which is actually XLRow number-1.
First row is used for table columns.
thnx for your time.