ExcelBanter - Formula required

A lot depends on how you're getting $$ values into columns 3 and 4 on the
first sheet. If those are being typed in manually, you're going to have a
tough time doing it because a cell can either contain a value (such as a $$
amount typed in) or it can contain a formula, not both at the same time.

You could set up columns 3 and 4 to get their values via VLOOKUP() [or
HLOOKUP() as appropriate] from sheet 2, and either always enter those values
on Sheet 2 where you have them probably being picked up via VLOOKUP() from
sheet 1 now, or add a couple of columns to enter them into those
not-pretty-formatted columns and get picked up by sheet 1 to be picked up by
sheet 2 again.

It sounds a bit as if you want to have 2 'sources' for the data, and really
the definition of 'source' implies a single location. Being able to enter
'source' data here or there or elsewhere can get you into an out of control
situation pretty quickly.

"Ron (Bismark)" wrote:

I have a spreadsheet that has 5 columns
Sheet 1
Col 1 = Identifier (1,2,3,4..etc)
Col 2 = Date
Col 3 = $$
Col 4 = $$
Col 5 = sum cols 3 & 4.
Each row is a new record, approx 2000 records

Sheet 2
Is a lookup sheet where the identifier is keyed in and presents the data in
sheet 1 for the particular identifier in a "pretty" format.

Sheet 2 is also used to update Col 3 & 4 in sheet 1.

My question is how can I enter values into cells on sheet 2 that will update
the respective record on sheet 1.

any help much appreciated.