Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I link any new information from another work book
I want any new information from a previous worksheet to appear on a new
sheet...is that possible. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I link any new information from another work book
The seems to be a contradiction there- new info on previous sheet?- if its
new info on new sheet then you could do a vlook to see what was on the previous sheet and what wasn't hence new -- hth "Jazming" wrote: I want any new information from a previous worksheet to appear on a new sheet...is that possible. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I link any new information from another work book
I have a bunch of companys in one spread sheet that are categorized. In the
next sheet they are alphabetized. When we get a new company in I'd like the alpha sheet to recognized the change in the categorized sheet whewww. "David" wrote: The seems to be a contradiction there- new info on previous sheet?- if its new info on new sheet then you could do a vlook to see what was on the previous sheet and what wasn't hence new -- hth "Jazming" wrote: I want any new information from a previous worksheet to appear on a new sheet...is that possible. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I link any new information from another work book
ye just using a vlookup should do it for you
in the catagorised sheet vlookup the alph sheet =VLOOKUP(E6,Alpha!C4:c2000,1,0) e6= company name in catagorised sheet Alpha c4 to c2000= list of comapnies already inc in aplha sheet Where you get an N/A the that company is in the cat sheet but not the alpha If it helps post post yes in button below -- "Jazming" wrote: I have a bunch of companys in one spread sheet that are categorized. In the next sheet they are alphabetized. When we get a new company in I'd like the alpha sheet to recognized the change in the categorized sheet whewww. "David" wrote: The seems to be a contradiction there- new info on previous sheet?- if its new info on new sheet then you could do a vlook to see what was on the previous sheet and what wasn't hence new -- hth "Jazming" wrote: I want any new information from a previous worksheet to appear on a new sheet...is that possible. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
work book sheets | Setting up and Configuration of Excel | |||
work book to work book | Excel Discussion (Misc queries) | |||
work book | Excel Worksheet Functions | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
simultaneously work in a work book with other users | Excel Discussion (Misc queries) |