Help!! Upate list with Macro! - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Help!! Upate list with Macro!

MattLeeMattLee Posts: 1Member
Hello,

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!
Sign In or Register to comment.