Please HELP...User adds Row to range in file and row populates another range in different file

[phlavs]

Hi Potential Helpers,

New to VBA. I have a few templates with macros that will allow users to add line items (rows of 6 cells) into a range ("structure") after selecting the 6 fields from dynamic ranges, which are the drop-down validation data lists (just indirects of range names).

My question- is there a macro that will add the line item to a table in my database file. The data set is not huge so the master data base file will also be an excel file. Because it will be using a vlookup, match function to consolidate all the templates if a user adds a row I would like the row to be auto populated in the different data base file so it captures new data.

I hope that I am explained well enough. Again my Range.("structure") will get a new row after a macro runs and I am hoping it will also be added another file with all the data from the templates. Would I need to make sure the user has both files open? I plan to use a Sharepoint drive.

Any comments/feedback would be much appreciated! Thanks in advance.

 

[sijpie]

Your macro could check if the file is open, if not, open it, extract the data, and close it. If it was already open, then leave it open after extracting the data.

There are thousands of examples on how to add data to the bottom of a table