I have spent hours trying to figure out a Macro for updating a database located on another sheet. Example
I have a workbook that has 5 different sheets in it. (Master, DataEntry1, DataEntry2, DataEntry3, and UpdateSheet) 3 of the sheets are data entry sheets, with 1 sheet as a Master sheet, and another used analytically. I have right now a macro button that basically adds a line in both the data entry sheet and master sheet and reflects anything entered into that line on the master sheet using (=DataEntry1!A3) formula.
Now I need to create a macro and update button in the UpdateSheet that copies the master sheet and any *New entries* that have been added.
Is it possible? Any suggestions on how to do this? Thanks for your help!! I greatly appreciate it!