I have an excel spreadsheet #1 with 20+/- differnent columns, some columns have a vlookup to another spreadsheet that has names and address. I use this spreadsheet for the unique information that will be needed in my word mail merge. I also have another spreadsheet #2 that after printing my mail merge, I will cut copy and paste spreadsheet #1 to the record keeper spreadsheet #2. Is there a way I could put another column in my spreadsheet #1, that when entered a Y for printed it will automatically post over to spreadsheet #2? Also, I just want the value on spreadsheet #2 not any of the formulas.
Bookmarks