andrewbush
New Member
- Joined
- Oct 8, 2010
- Messages
- 4
I hope this makes sense because I have been having a difficult time trying to figure out a solution to this problem.
I have two spreadsheets and what I want is if there is a match between the two spreadsheets, I want a macro or formula to copy the sales column data from the spreadsheet that just has agent number and sales to the spreadsheet that has the agent number and blank cell for sales.
Example
Spreadsheet that has just the agent number and sales:
Spreadsheet that has agent number and sales but no data in the sales column:
Result desired for first row of the second spreadheet:
agent_number
25003
sales
311745.5
I would like this result to happen automatically for the rest of the rows of the second spreadsheet.
Any help with this would be greatly appreciated. Thank you.
I have two spreadsheets and what I want is if there is a match between the two spreadsheets, I want a macro or formula to copy the sales column data from the spreadsheet that just has agent number and sales to the spreadsheet that has the agent number and blank cell for sales.
Example
Spreadsheet that has just the agent number and sales:
Spreadsheet that has agent number and sales but no data in the sales column:
Result desired for first row of the second spreadheet:
agent_number
25003
sales
311745.5
I would like this result to happen automatically for the rest of the rows of the second spreadsheet.
Any help with this would be greatly appreciated. Thank you.