Basically I am referencing cells in relevant columns from one table in a worksheet to another table in a different worksheet to be easier to import into access. Do I need to do this with VBA, or can I somehow have the table that is deriving the fields from the other to dynamically 'grow' as new rows are added to the first table? Is there an easy way to do this?
thanks
I suggest you should explore this info related to connecting one spreadsheet to another:
http://office.microsoft.com/en-us/ex...103791160.aspx
Once you connect to another spreadsheet, the data will be imported already formatted as a table. This table will expand or contract dynamically, as data on the other spreadsheet is changing. You can even setup a timer for data refresh or have the table refresh when you open your workbook or you can refresh manually by clicking Refresh icon located in the 'Data' section in Excel 2010 ribbon.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks