Hello to all,
I have little issue.
My goal is to make simple VBA code which could copy last month's info and paste to column table below with new date, but old data next to it.
Please Login or Register to view this content.
I know that this looks silly, but i am new to creating macros and etc.
Problem is that today i could not find solution how to make this section better:
"Selection.Find(What:="41070", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=True).Activate
i need that code could use relative value of cell F2, not the exact value. Could you help me?
For understanding, i attached file. Thanks in advance!
Bookmarks