Spiceytaley
A few questions
1) Is the reason you don't want to add a column because you don't want to change how your worksheet looks? If so you could have a data entry column where you enter the values that you have in column A, then you could hide it easily hide it using the group command under the data menu. You could then enter formulas in Column A that reference you data entry column.
2) Another option would be to enter all of your data that you show in workbook 1. Then have formulas in worksheet 2 that will change the what is in column A.
3) Another option would be a code solution.
Would any of this 3 solutions work for you?
Bookmarks