Hi guys. First post on here, thanks to anyone who provides input.
I'm trying to maintain a massive spreadsheet that was created by my predecessor. It's amazing what he was able to do (extracts tons of data from another piece of software daily and inputs it into a spreadsheet of usable information). Unfortunately I'm still figuring out the ins-and-outs of the whole thing.
One of the tabs references multiple items on the balance sheet (which is brought in from another program). I haven't figured out why yet, but every so often the balance sheet information has been moved down a few rows. This makes all of the information on the tab referencing the balance sheet incorrect. For example, today I had to subtract 4 rows from all of the cell references BS!D66 became BS!D62, etc.
Originally I was going to use an Index function to find the right Balance Sheet category so it wouldn't matter what row it was in, but the spreadsheet already seems very overloaded and changing several to the Index function really dragged it down.
I'm wondering if it's possible to just change the first cell in each column, and have the formulas in the cells below adjust somehow? For example, changing BS!D66 to BS!D62 would also change the cell below from BS!D67 to BS!D63 and so on? I realize it may not be possible but really hoping it is so I can quit adjusting this spreadsheet that's supposed to be simply run and printed daily. Thanks in advance to anyone who replies!
I'm trying to maintain a massive spreadsheet that was created by my predecessor. It's amazing what he was able to do (extracts tons of data from another piece of software daily and inputs it into a spreadsheet of usable information). Unfortunately I'm still figuring out the ins-and-outs of the whole thing.
One of the tabs references multiple items on the balance sheet (which is brought in from another program). I haven't figured out why yet, but every so often the balance sheet information has been moved down a few rows. This makes all of the information on the tab referencing the balance sheet incorrect. For example, today I had to subtract 4 rows from all of the cell references BS!D66 became BS!D62, etc.
Originally I was going to use an Index function to find the right Balance Sheet category so it wouldn't matter what row it was in, but the spreadsheet already seems very overloaded and changing several to the Index function really dragged it down.
I'm wondering if it's possible to just change the first cell in each column, and have the formulas in the cells below adjust somehow? For example, changing BS!D66 to BS!D62 would also change the cell below from BS!D67 to BS!D63 and so on? I realize it may not be possible but really hoping it is so I can quit adjusting this spreadsheet that's supposed to be simply run and printed daily. Thanks in advance to anyone who replies!