Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking/updating multiple wksht comments
I have a workbook with multiple spreadsheets and the only thing that varies
from sheet to sheet is the "comment" column we have. I need to know how to have the comments from let's call it wk 1 spreadsheet update/link to the new wk 2 spreadsheet keeping in mind that not all customer accounts may show up on the new wk 2. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking/updating multiple wksht comments
Hi Heidi,
If you have a column for your comments let's say column B and you customer list is in column A in the WK2 enter the formula as follow let's say your customer list start in cell A1 and your comments in B1 In B1 Wk2 enter =sumproduct(--(A1=Wk1!$A$1:$A$500),Wk1!$B$1:$B$500) if this was helpful please click yes, thanks "Heidi" wrote: I have a workbook with multiple spreadsheets and the only thing that varies from sheet to sheet is the "comment" column we have. I need to know how to have the comments from let's call it wk 1 spreadsheet update/link to the new wk 2 spreadsheet keeping in mind that not all customer accounts may show up on the new wk 2. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
1st 2 rows of wksht show up @ top of each page of the wksht | Excel Discussion (Misc queries) | |||
Printing multiple page wksht w/pictures | Excel Discussion (Misc queries) | |||
Updating / linking | Excel Discussion (Misc queries) | |||
Linking cells with comments | Excel Worksheet Functions | |||
linking comments between spreadsheets | New Users to Excel |