Hi
Looking to copy info from cells P8 to p13 to cells b3 to g3 for jan 1 and b4 to g4 jan 2, date change in cell o6 using drop down menu, change date in drop down menu and Change data in p8-p13 according Date
We enter data Into cells o8-o13 and uses formula in p8-p13
Date from jan 1 to Dec 31 in cells a3-a367
Is this possible to do
Similar to
=(p8) when date in cell o6=a3
Currently using formula in file attached when i change date to jan 2 in drop down and enter new data in column O8-O13 data in Row 3 for jan 1st changes too, is there a way so previous days stay the same
Last edited by Jarrett151; 01-20-2022 at 07:31 PM.
Hello Jarrett151 and Welcome to Excel Forum.
Please utilize the information in the banner at the top of the page to upload the Excel file from which the pictures in post #2 were taken.
Knowing the Excel version (MS-Off Ver) that you are using will help us in deciding which functions/features can be used to respond to your request.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks