Forum Discussion
Records sheet to sheet
Is it at all possible for you to upload a sample of the spreadsheets you're describing? It sounds like they may well include personal/confidential information, so a sample only, with false names will do, but try to include at least ten "dummy" records.
In the absence of that sample to look at and then be able to make more fully informed recommendations, I will ask (I'm quite sure) whether or not it would be possible to simply record those notes you're talking of in Sheet A rather than putting them into yet another sheet. In other words, simply extend that central database of records.
Another possibility occurs to me, but it would involve Power Query, and my home Excel does not have that ability...
hello, here is that sheet
Is it here somebody who can help me?
Thx
I"m sure what you're asking for is possible. But I'd want to radically change your whole approach.
Your Tab B (in my opinion) needs to be radically altered if you're going to use it for INPUT. It's just not practical to do all kinds of referring to individual cells. This is what I'd see as a nice OUTPUT screen....
Anyway, to preserve my own sanity, I'm going to pass. There may be others here who are more experienced with procedures such as you have created.