I have a sheet with a date range to put the current progress under it everyday. What I am trying to do is run a macro to take my current percent complete in A2 and look for date in range K2:BS2 that matches the date in cell A4 and place the percent complete as a value in the cell.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Find Date In Row and Paste Value Under The Date
Excel Facts
Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Yes. If I tried to use a formula to count the columns it did not work. But if I entered the numbers from K to BS it worked. I used A1 as an Hlookup to put the number that was in the same column as the date I was looking for.
Upvote
0
Similar threads
- Solved
- Solved
