09-18-2020 11:49 AM
09-18-2020 11:49 AM
Hi, I have a complex table that contains something like 750 rows and 200 columns
A lot of the columns containing logic and calculations are hidden.
What I want to be able to do is copy a row so that only the visible data is copied and pasted into another sheet using a link. Everything I have tried results in everything being copied including the hidden stuff.
Either that or I would like to be able copy three sets of the visible data, paste a link then at the link auto fill the remaining columns base on the progression demonstrated in the first three columns. So in the following I want to auto fill rows based on the three completed columns
Column A. Column B. Column C
Sheet1A2 Sheet1A12 Sheet1A18
Sheet1D2. Sheet1B12. Sheet1B18
Sheet1G2. Sheet1G12 Sheet1G18
I know it will do it because its a computer, I just don’t know how.....
09-18-2020 12:14 PM
You wrote: I know it will do it because its a computer, I just don’t know how.....
I love that attitude. My own variation on it, for years, has been "If you think 'They should have made it possible for Excel/Word/whatever to do ______________,' then you can take it as a given that, in fact, "they" did. Your challenge is to find HOW they did it."
It might mean finding a menu item that isn't worded the way you would have worded it. In the case of Excel, it more often means finding a function with some weird name like VLOOKUP or INDEX or.... The other thing about Excel that both enchants and infuriates is that there probably are at least five different ways to accomplish any given task.
In your case, for example, I can think of
A question: are you mainly wanting that second sheet--where the copy of only visible data is to reside--to be simply for the viewing? I.e., is it solely for output, or are you going to be expecting yourself or others to make entries of data in some cells? That would make a big difference, a very big difference, in how you should proceed. My hope is that all "maintenance" of information is to be done on the "source" sheet.
Is it possible for you to post a sample of what your sheets contain, just making absolutely sure first that no proprietary or private information is contained it it. To the extent there are names and addresses, either delete them or substitute names of movie characters and false addresses.