steelervince
Board Regular
- Joined
- May 29, 2007
- Messages
- 83
Good Morning All!
I have a good one that I am attempting to figure and then solve using VBA in Excel 2010.
11 WB's - 1 Master and 10 others which need to be updated. Master WB has 1 Sheet. Each of the other WB's contains multiple sheets. Each sheet in the WB's is laid out the same way, column names are the same and data is the same format in all sheets, all WB's. Each sheet tab in all of the WB's have unique names.
In the Master WB I have a numeric "key" value field which contains 6 digit numbers. Matching numbers appear in only 1 of the other 10 WB's (Column Name is the same in each spreadsheet, i.e. Customer #) however,
This is what I need to have happen:
1. Have VBA look at the values in the Master WB's "key" field and Find a corresponding value in one of the other WB's (I am assuming that this can be done 1 WB at a time and 1 Sheet at a time?)
2. Once the value is found, Copy data from column 4 (it will always be the date from column 4 which is to be copied) in the Master WB and then Paste that data into Column 4 of the correspnding WB and Sheet.
3. If a numeric match is not found then Color that value in the Master WB Red.
I hope that someone out there is able to assist rather quickly as I have a deadline to meet. In my past roles I have done extensive programming using VBA but I have been away from it for about 5 years now. I know that it will come back quickly so any guidance that you are able to offer would help me out greatly!
Thanks in advance and make it a great day!
Vince
I have a good one that I am attempting to figure and then solve using VBA in Excel 2010.
11 WB's - 1 Master and 10 others which need to be updated. Master WB has 1 Sheet. Each of the other WB's contains multiple sheets. Each sheet in the WB's is laid out the same way, column names are the same and data is the same format in all sheets, all WB's. Each sheet tab in all of the WB's have unique names.
In the Master WB I have a numeric "key" value field which contains 6 digit numbers. Matching numbers appear in only 1 of the other 10 WB's (Column Name is the same in each spreadsheet, i.e. Customer #) however,
This is what I need to have happen:
1. Have VBA look at the values in the Master WB's "key" field and Find a corresponding value in one of the other WB's (I am assuming that this can be done 1 WB at a time and 1 Sheet at a time?)
2. Once the value is found, Copy data from column 4 (it will always be the date from column 4 which is to be copied) in the Master WB and then Paste that data into Column 4 of the correspnding WB and Sheet.
3. If a numeric match is not found then Color that value in the Master WB Red.
I hope that someone out there is able to assist rather quickly as I have a deadline to meet. In my past roles I have done extensive programming using VBA but I have been away from it for about 5 years now. I know that it will come back quickly so any guidance that you are able to offer would help me out greatly!
Thanks in advance and make it a great day!
Vince
