S
Scott Danzig
I have had success preparing a large table with mostly text and boolean
values (some blank) in columns that are auto-generated using funky macros
(text, lookup, and logic functions) based on values in other columns. All
good, but I'm looking for the easiest way to generate two other tables with
only certain columns, and in one table, only rows that match a certain
criteria. I was looking into pivot tables, but it seems mostly for
flexibility with number-based tables. Also looked into Access, but by
exporting the data to a database, I lose the nifty excel macros. Is there
something simple I'm missing? Thanks.
- Scott
values (some blank) in columns that are auto-generated using funky macros
(text, lookup, and logic functions) based on values in other columns. All
good, but I'm looking for the easiest way to generate two other tables with
only certain columns, and in one table, only rows that match a certain
criteria. I was looking into pivot tables, but it seems mostly for
flexibility with number-based tables. Also looked into Access, but by
exporting the data to a database, I lose the nifty excel macros. Is there
something simple I'm missing? Thanks.
- Scott