Excel: If date changes
Closed
Scott B
-
Dec 1, 2011 at 11:25 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 5, 2011 at 11:28 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 5, 2011 at 11:28 AM
Related:
- Excel: If date changes
- Excel marksheet - Guide
- Number to words in excel - Guide
- Excel apk for pc - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
- Gif in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Dec 1, 2011 at 11:43 AM
Dec 1, 2011 at 11:43 AM
could you post a sample workbook with some sample data at some file share site and post back the link the FILE back here ?
Dec 1, 2011 at 02:47 PM
Dec 1, 2011 at 02:55 PM
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*.
Dec 2, 2011 at 06:26 AM
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 ?
Dec 2, 2011 at 10:56 AM
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.
Dec 5, 2011 at 11:28 AM