Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking for an excel function which can mirror opposite the data wilchong via OfficeKB.com New Users to Excel 3 May 11th 12 07:13 PM
Excel File Mirror/Clone Goaliemenace Excel Discussion (Misc queries) 2 May 10th 10 08:42 PM
How do you mirror data and formatting in Excel '03 Jorg Excel Worksheet Functions 1 August 1st 07 03:36 PM
Help with Dynamically changing Range in Excel Macro runsrealfast Excel Discussion (Misc queries) 4 July 16th 07 10:44 PM
how to select cells dynamically in excel macro? Excel user Excel Programming 1 November 1st 04 06:28 PM


All times are GMT +1. The time now is 02:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"