The macro will be running from the white sheet. Path = InputBox("Enter a file path", "Title Here")Īnother problem is that i thought i knew how to make the conditions for the copy-paste actions and i need a little help with that. ![]() ![]() The same error i get when i use Sub GetPath() ![]() Open path For Output As #n ' runtime error 52 With Application.FileDialog(msoFileDialogOpen) 'declaring variables and explaining each one roleĭim newfo As Workbook 'newfo is the newly opened workbookĭim newfows As Sheets 'newfows is a speciffied sheet to copy data from Tried to write a macro in vba and here is one of the problems: it returns runtime error 52. Until now i tried multiple formulas such as vlookup after the date in the white, but it grabs just the numbers from method 1, and if i use something like =if(and(A2=":\green.xlsx"A2 b2="mastersheet" C1="method1"), ":\green.xlsx"C2 " "), and vlookups that grabs only the data for the method1 (but it does it correctly) the delta line just calculates the differences between the mastersheet and evidence cells. ![]() I need to copy the data from the green sheet and, based on the date and specific text on line and column, to paste it into the white sheet in the correct columns and skip the incorrect ones. I have 2 tables: one that needs to be filled with the data from the mastersheet and the mastersheet.
0 Comments
Leave a Reply. |