|Home > Forum Home > Analyzing Corporate Financial Data > Automatically add rows to a table with macros||Share|
|Forum Topic||Post Reply Login|
Automatically Add Rows To A Table With Macros
Rate this:(3/5 from 1 vote)
I really need some help either writing a macro or finding another way to have my database automatically fill data in a row when new values are added.
I am working with excel 2007, I have a database where I add information pulled offline. I copy/paste the values into a new row under the "Results" table. I have a primary key ("Results ID") that just consists of typed numbers (1,2,3,...) used as a unique number for each result. In my database I have several analysis tables which include fomulas for calculations and to relate to and pull the original data from the "results" sheet. These analysis tables also reference the primary key, and contain the same amount of rows as the "results" sheet.
My problem comes in when i add new results to the table. When I copy/paste the new result under the last record the table automatically "attaches" that new result to be included with the rest. It also automatically fills the formulas from other columns down as well. It does not however fill the primary key values down.
I would like some help on writing a macro to make it do this as new rows are added. I would also like the macro to cause the primary key columns in the 3 analysis tables to automatically expand as rows are added to the "results" table.
Please help me.
|Posted by Snapshot84 on|
|There are currently no replies to the "Automatically add rows to a table with macros" topic of the Excel Help Forum for Analyzing Corporate Financial Data.|
|Find relevant Excel templates and add-ins for Automatically add rows to a table with macros in the Excel Business Solutions Directory|