Comparing and updating

RBartonSWW

New Member
Joined
Nov 18, 2005
Messages
38
Is there a simple code to get VBA/Macro to check a column of data with data on another sheet/workbook and get it to fill in missing data?

Basicaly I want to quickly enter an x into a column, but not all rows need the data entering, some need to stay blank. The data is also many rows apart in some places so the simple Copy/Paste isn't going to work.

I know how to get it to check a specific entry and do an update at the click of a button, but only on the same sheet and I want it to do it on a different sheet and multiples.

Thanks.

Rob
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Watch MrExcel Video

Forum statistics

Threads
1,118,812
Messages
5,574,463
Members
412,595
Latest member
slim313
Top