Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically (w/o macro or vb) dynamically mirror one excel tableonto another
I have two excel tables in an excel workbook, on two separate tabs: TableA and TableB.
TableA is a legacy table, which has 8 columns. Upon the workbook being uploaded, the data from TableA is moved into a data base by an excel handler. TableB is a more user-friendly presentation of TableA, including data validation and conditional formatting to reduce errors and increase efficiency. I'd like the user to never have to interact with TableA. So I'd like the data entered by the user in TableB to be automatically mirrored in TableA. The trick is that the user may enter a variable number of rows of data, and Macro's aren't allowed by the excel handler. I've set TableA as an excel table, with references to the corresponding columns in TableB. So the first row populates nicely. But i don't know how to get any of the rows in TableA after the first row, as they are created, to automatically show up in TableB. I'd thought there might be a formula in Excel that would enable me to mess with Table attributes directly, but i can't seem to find such a thing. Any ideas out there? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking for an excel function which can mirror opposite the data | New Users to Excel | |||
Excel File Mirror/Clone | Excel Discussion (Misc queries) | |||
How do you mirror data and formatting in Excel '03 | Excel Worksheet Functions | |||
Help with Dynamically changing Range in Excel Macro | Excel Discussion (Misc queries) | |||
how to select cells dynamically in excel macro? | Excel Programming |