Easily, if it is not a complex workbook or worksheet you could copy the cells on spreadsheet 2 and paste special, then paste link on spreadsheet 1 in the cells for update, then when you make an entry on spreadsheet 2, it will automatically update spreadsheet 1.
Hope that helps.
mcreary
Last Activity: Dec 11 '07, 03:33 PM
Joined: Sep 12 '06
Location:
-
Excel: Vlookup Or Iif Function?
I HAVE A WORKBOOK WITH TWO SHEETS. I WANT TO SELECT A RANGE ON WORKSHEET "A" AND COMPARE (not necessarily the same item count) TO RANGE IN WORKSHEET "B", THEN RETURN RESULTS FROM WORKSHEET "B" TO COLUMN IN WORKSHEET "A".
For example, worksheet B is used as a reference table. So if a name in worksheet A = the same name in worksheet B, then return the value in B that matches the name in B to worksheet... -
Thanks, works like a charmLeave a comment:
-
Iif Or Else Statements
I have a table Tbl_Computron. I would like to auto update the field "Business Units" in the table based on a condition being met in the "Account Hierarchy" field, with the following syntax: IIf([Account Hierarchy] Like "CEAA*","Invest ment Grade Capital Markets") The thing is, I have over five hundred codes that includes other series such as CEAA, CERB, CEFV etc. and that will have a different business unit...
No activity results to display
Leave a comment: