Dynamically generating tables from another table

  • Thread starter Thread starter Scott Danzig
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning Data into a Table 1
Pivot Table Help! 1
Adding Report Filters to Excel Pivot Tables via VB. 1
adding rows into the table 1
Generate list 4
remove Absolute references when copying from pivot table 4
Pivot table > date filters. Any way to set to most recent days? 1
vlooup will not work correctly if lookup table is on another sheet 6

Back
Top