Dropping entered data into matching records

[fooledbylogic]

In the attachment, there are two worksheets: 'Data Entry' and 'Database'.

In the 'Data Entry' tab, there are three columns - C through E - that need to be dropped into the 'Database' tab - columns F through H - to the rows respective to the corresponding Return Reference #.

I set up a Match formula in the leftmost column that shows what rows the information will be pasted to, but I need a macro that will do it for me with mass amounts of data.

Probably not too complex but I can't get anything to work like I need it to.

[tigeravatar]

fooledbylogic,

Based on your sample file, you only need a VLOOKUP formula, not a macro. Attached is a modified version of your sample workbook so you can see how it works.

Hope that helps,
~tigeravatar

[fooledbylogic]

Unfortunately, it's not that simple.

The 'Database' tab is a permanent log that will maintain the data as users add and update records over time. The 'Data Entry' tab will have different records every time, so VLookups will not work as the data will not always be there.

[tigeravatar]

fooledbylogic,

Attached is a modified version of your workbook that contains a button labeled Update Database on the Data Entry sheet. That button is assigned the following macro:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[fooledbylogic]

tigeravatar,

Thank you, this code works great. You've provided something I can build on - greatly appreciate the help!