Novice - Lookup Relative Data

  • Thread starter Thread starter Steve_Smith
  • Start date Start date
S

Steve_Smith

Hi,

I'm sure this must be simple - but...

I have a sheet of various PO items I need to send to the vendor so h
can enter new forecast ETAs and comment. However, I do not want hi
to overwrite the exiting data - just add to it in new columns withou
messing with the original stuff. The problem is, I know he will wan
to sort and/or filter the data while entering information.

What I thought might be best is to create another sheet calle
'Working' where he can do all this and when he enters the new ETA dat
and comments, these will magically appear in new columns, by look-up i
my 'Original' protected sheet.

I have tried, thinking I could create named references on the origina
sheet, doing a paste special copy called 'Working' and then protectin
the 'Original' Trouble is, I am out of my depth and cannot seem t
make it happen!

Can any of you smart guys out there help this novice out?

Many thanks,

Stev
 
Just copy the source to a new sheet, and on the source use a lookup.

Say you have columns A-E, with A as the key field, and the user will input
to F-G. On the source in F1 add

=VLOOKUP(A1,'USer Sheet'!$A$1:$G$100,6,False)

and copy down. In G1

=VLOOKUP(A1,'USer Sheet'!$A$1:$G$100,7,False)

and also copy down.

Hide your sheet (Format>Sheets>Hide), and you should be okay.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Bob,

Thank you very much. Your solution has worked a treat!

I hope you had a great day looking out over Purbeck...

Your help and generosity has been much appreciated.

Regards,

Steve
(who has had been sitting in his Cotswold garden, relaxed and thinkin
nice thoughts about how great it is to have people like Bob about.
The world is OK today - and the beer helped too!:)
 
Back
Top