Excel: If date changes

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

Here's what I want to do.

I have a Column where I change the date and I want certain cells in this column to extract different information within the page based on the date.

Column A works down. Columns B-M works across. Each row in Columns B-M is a new date.
Column A has a drop down date list.

If I change the Date in A4 (drop down list) , I want A11 (and other cells in Column A) to pull information from D4(or D5, D6, D7. etc) based on the date in c4(or c5, c6, c7. etc that equals A4)

I really hope that's not to confusing.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
could you post a sample workbook with some sample data at some file share site and post back the link the FILE back here ?
Sorry, it will not allow me to paste an image or add a file.
How about this..........

If a4(drop down dates) = b11 (dates) I want the info in c11, d11 and e11 to be entered into a11, a13 and a14.
But if a4 now =b42 the the info in c42, d42 and e42 to be entered into a11, a13 and a14.
Column A remains constant, it just pulls the information from the some columns, but different rows depending on what a4 = b*.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You will no be able to attach file here. You would need to use some public file sharing site to upload the file there and then post back the link to the file back here

Based on your requirement, it seems that
all you want to do is that what ever select in B11, you want to search for that value in b column starting from Row NOT BEFORE the row 14 and update certain cells based on what is found

Question is will there be always one match, If more than one match then what ?
Here how's this?

if a3(drop down date list)= c4 or c5 or c6 or c7 etc to c31(dates that have already been inputted in c)
Automatically make a9 = d4 or d5 or d6 or d7 etc to d31 (numbers that have already been inputted in d)
Then automatically make a11 = f4 or f5 or f6 or f7 etc to f31 (numbers that have already been inputted in f)
Then automatically make a13 = g4 or g5 or g6 or g7 etc to g31 (numbers that have already been inputted in g)
Then automatically make a15 = i4 or i5 or i6 or i7 etc to i31(numbers that have already been inputted in i)

I'll input the information into f4 or f5 or f6 or f7 etc to f31 before I use the drop down date (list in a3).

In other words, all of the data will be available, I just want that went I change the date the information auto populates.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
I am sorry, but I just simply cannot get a picture in my head of your layout. If you could post a sample book at some file share site (you can do a google to find out such site), I might be able to see what you have tried to explain