Automatic fill-in from one worsheet to another

[mdj0615]

I don't even think this is possible, but I have been keeping data on a
spreadsheet that I need to place onto another spreadsheet. Is there a way to
format the columns so that a value placed in A3, A4, etc would automatically
populate a preset cell on another worksheet? The other worksheet is sent out
to clients, and needed to be formatted differently than the spreadsheet.

 

[Pete_UK]

You can have a formula like this in A3 of the second sheet:

=IF(sheet1!A3="","",sheet1!A3)

and this can be copied across and down as required. If the sheet is in
a separate workbook then you will have to include the full path (if
not open at the same time) and the filename before the sheet name,
i.e. something like this:

=IF('full_path[filename.xls]sheet1'!
A3="","",'full_path[filename.xls]sheet1'!A3)

However, you must remember before you send it to a client that you
will need to fix the values in this second sheet and then save it with
a different name in order to preserve the original.

Hope this helps.

Pete