![]() Range("A50").PasteSpecial Paste:=xlPasteValues MatchCase:=False, SearchFormat:=False).Activate LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ Selection.Find(What:=rngY, After:=ActiveCell, LookIn:=xlFormulas, _ Set ff = fso.getfolder("C:\Users\34664\summary\test") Set fso = CreateObject("scripting.filesystemobject") Any help is much appreciated! Sub Macro1() I know the code looks horrible but I think it makes sense to me. ![]() I am trying to get the value of A1, find that in column A of Test, go the column B same row, copy the value, come back to the workbook and paste as value. cell A1 in each workbook match the names in column A of the summary file Test. Just started learning vba this week so forgive me if my question is dumb.I have a summary file called Test and multiple workbooks.
0 Comments
Leave a Reply. |