How do I link any new information from another work book

  • Thread starter Thread starter Jazming
  • Start date Start date
J

Jazming

I want any new information from a previous worksheet to appear on a new
sheet...is that possible.
 
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
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
VBA - retrieve data on last create named range from previous inserted named range 0
Formula help in Excel 2007 6
Sorting Linked Data Between Sheets 3
Excel Monthly Spread sheet. 12
Duplicate cell information from one worksheet to another: 1
Hyperlink from one.xlsx cell to another two.xlxs cell & click back 1
how do I sort by picked-up date in Excel 1

Back
Top