Have a difficult one but hopefully you guys can help. We have a large spreadsheet. One tab called database has 600 rows and 82 columns. As you can imagine this is a little unwieldly. We have various pivot table on tabs to pull the data but when entering data we have to scroll and scroll to update a cell.
What I was hoping for what a way to have a 2 way transfer. So for example, tab 2 pulls (in a pivot style) only some selected information, if I wanted to update the information instead of going to the database tab, scrolling and entering the data, instead I could go into tab 2 and change a cell there.
In other words, changed a cell in database changes what is shown in the tab and changing in the tab changes the database. Can something like this be done? I just worry our database tab is getting to big for the “older” members of staff to deal with. If I add a new row with data on the database tab all the other tabs will add that row, this functionality is essential.
I have looked into custom views, but frustratingly that required NO tables and our database is one big table with conditional formatting, data validation etc. I ideally don't want to use VBA or formulas but if needs be I can.
Bookmarks