Copy a specific cells value depends on what date today on different worksheet and paste it to another sheet.

[FlipEternalX]

Hi, I have tasks to do in my school and I need to copy a specific value on different sheets based on what date today is. So for example I have 16 sheets and I just need to get the specific cells value based on what today date is ( March 3, 2023) and so on.. and paste it to another sheets. Replies will be more much appreciated. Sorry for bad English.

 

[bebo021999]

How to know which sheet/16 sheets and which cell in that sheet have something relatives to today date?
Try to attach an XL2BB

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

 

[FlipEternalX]

Hi. Thanks for the replies. Here is the screen shot.

As you can see the row A is the date for the current date which is today. and the column J is the thing I need to copy on every sheet I have and paste it to new sheet.