how do i get a cell in a spreadsheet to enter in a different cell

E

emma

I have an order form that will have alot of lines of variable data in it, the
variable data fields make up a printed label, in order to help the customer
order the labels it would be good for the label to be filled in with the data
as a preview. We have looked at if statements but we can't get the data in
another field.

The variable data will be held on several lines but we wish to display the
outcome in one cell when selected.

Please help.
 
G

Gary''s Student

Consider using:

Insert > Comment

rather than pre-filling the cells. That way, after the user enters
information, they have not over-written your instructions/samples and can
always refer to them.
 

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 Changing chart label colors based on a value in a cell 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
how do i make a cell a search cell for a spreadsheet 5
Lock Unlock Cell Protection 2
Reference constant cells in different files from a master workbook 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Grabbing data from a specific cell 2
looking up cell address 1

Top