Excel help

Remove this Banner Ad

RU_

.-.-.-.-.-.-.-.
Aug 6, 2010
22,255
14,633
Australia
AFL Club
Brisbane Lions
Hi all, hoping you might be able to help me with something that will streamline some of my employment excel work.

I’ve got two excel spreadsheets.
Spreadsheet A is from last week and outdated.
Spreadsheet B is from this week and the current one with my updated project list.

Spreadsheet A has my notes in column M of excel but doesn’t have my latest projects list.

Can I merge the job numbers in Column A and the notes of Column M in Spreadsheet A (outdated spreadsheet with notes) into spreadsheet B so that the vacant notes rows will be my new projects?
 

Log in to remove this ad.

kaiserchief13

Brownlow Medallist
Jul 12, 2011
29,591
20,660
Melbourne
AFL Club
West Coast
Other Teams
Eagles, Lakers, Bayern, Trojans
Xlookup? index/match? vba macro using row.count to get row number variable?

Maybe provide screenshots as it's not 100% clear what the problem is
 

Remove this Banner Ad

Remove this Banner Ad