Moving data without a formula

J

Joey

Hi all

Is it possible to to have a formula that selects data from one cell an
enters it into another without using macro or vba. (I don't know muc
about creating or rectifying them should anything go wrong)

Eg.
A1 = formula
B1 = the data
C1 = where the data should be returned

Or if the formula should be in B1 even, would be great.


Many thanks for any assistance
Joe
 
T

tghcogo

A lot of functions will do this it depends on what you are trying to do
What are you trying to achieve?

TGHCOG
 
J

Joey

I have 13 huge spreadsheets where we manually input holiday hours fo
staff according to the dates they want.
I'm trying to create a sheet where we enter the reference number an
dates, and when the formula relates to the staff's reference number i
automatically puts the hours according to the date in column A.

The staff's ref #'s are in row1.

The problem at the moment is that there is a lot of mistakes and
think it's due to manual inputting in different sheets.


I hope this is clear enough
Joe
 
D

Dave Peterson

Formulas return values to the cell that holds it. They can't change the value
in another cell.
 
Top