Manipulating data between worksheets

[JDU]

I don't know how to do this. I will try to explain via an example.

Let's say that in Excel, in sheet 1:
Column A has dates in them.
Column B, C, D etc has values in them that correspond to the respective date in Column A.

What I would like to do is on sheet 3:
Some sort of an input box that would allow for a date to be input and the values from sheet 1 for that date be input in cells on sheet 3.
Eg. For 9/1/03 Sheet 1 Cell B1=Sheet 3 Cell C2
Sheet 1 Cell C1=Sheet 3 Cell D6
Sheet 1 Cell D1=Sheet 3 Cell E8
Etc.
Thanks

 

[ETID]

on sheet2, in cell b1

=vlookup($A1,sheet1!$A:$E,column(),false)

Note:repalce $E with the letter of your last col of data on sheet1.

fill right on sheet2 for all cols on sheet1

now on sheet2,...type a date in cell A1

 

[JDU]

Thanks ETID

 

[SkipVought]

JDU,

1. Name the range of dates on Sheet1, for instance, "DATES"

2. On Sheet3, in column A put in Data Validation -- menu item Data/Validation and select Validation Criteria: Alow List - and enter DATES in the TextBox.

3. On Sheet3, use the formula...

=IF(ISERROR(=vlookup($A1,sheet1!$A:$E,column(),false)
),"",=vlookup($A1,sheet1!$A:$E,column(),false)
)

This is ETID's formula modified to "fill in the blanks" when there's a date in Col A.

hope this helps

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com