date column to look up todays date and copy/paste in same row as date lookup
HI there, searched but did no find anything similar to what I am trying to do. I havea workbook where Column A is a listing of dates in ascending older. I have data in cells V1:AH1 and is a vlookup based on todays date that's pulling from another tab with just data.
i'd like to run a macro that looks up the date in column A and if it matches todays date then it would copy the data range in cells V1:AH1 and paste into the same row as the date in Column A.
Welcome to the forum
Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
thanks. file attached.
Try this, but I would change ActiveSheet to your actual Sheet name
Please Login or Register to view this content.
Click the * to say thanks.
alright, let me test it out and will report back. thanks in advance!
had a compile error but I then added the line to set dim the cell as range to make it work. thanks again for your help PaulM100!
PHP Code:Sub FindDate()
Dim cell As Range
ActiveSheet.Range("V1:AH1").Copy
For Each cell In Sheets("WIP").Range("A2:A1000")
If cell.Value = [Today()] Then
cell.Offset(0, 1).PasteSpecial xlPasteValues
End If
Next
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks