VBA Macro : How to copy specific cells on multiple sheets based on TODAY() date?

[FlipEternalX]

Hi everyone,

Asking for assistance. Can anyone help me?

I want to copy specific cells using VBA Macro based on TODAY() date.

I have 10 worksheet and each worksheet have 2 column, 1 for Date and 1 for DataToPull.

I want to pull the data based on what today date. Can anyone help me? Thanks!

 

[mumps]

After you copy the data, where do you want to paste it? It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).