Appending Col automaticaly

  • Thread starter Thread starter jknight
  • Start date Start date
J

jknight

I have a workbook with three sheets, Input, Data, and Report. What I'm
trying to do is input info in the input sheet and store it on the Data
sheet, then recall the data to the Report sheet. Info is date sensitive and
I can't seem to figure out how to get the date moved over.

Trying to get date to move as soon as it is typed in on Input sheet. Is it
possible to do something like. . .

If(Input!d1=(lookup(Data!,a1:a31)),",Data!a32=Input!d1)

As you can tell I'm a novice so please be gentle.

Thx

J.E. Knight
 
Formulas can't copy information into new locations. You
will need to use a macro. You enter the new data in the
Input sheet, then run the macro to copy the new
information into the Data sheet. You'll need to post more
details about your Input and Data in order to get this
figured out completely though. And you should post to the
Programming or General Questions group for this. Include
specifics such as the layout of your input sheet, the
layout of your data, and include all fields not just the
date field for more useful help.
 
I don't understand your formula but this should give you the idea
=IF(Data!A11=B10,1,"")
also you need to look in HELP index for LOOKUP
 
Back
Top