@9191rogerm
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
- VLOOKUP: once you've put column A in place on your secondary sheet, perhaps by copying it over (but there are other methods, to be mentioned below), then use VLOOKUP to populate the rest of the columns.
- INDEX and MATCH to do much the same.
- UNIQUE and FILTER, perhaps combined with SORT, much newer functions available only the most most recent versions of Excel, that could be really good to meet your need if you have that recent version
- There's even Pivot Table, although based on your description I somehow think it would not be applicable.
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.
