The macro will be running from the white sheet.
HOW TO GET VBA IN EXCEL 2016 MAC HOW TO
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.
HOW TO GET VBA IN EXCEL 2016 MAC CODE
To create the macro, click View Code in the Controls group under the Developer tab to launch the VBA editor. Position your cursor on the worksheet location where you want your button to appear. Click the first button below the ActiveX controls (Command button).
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. Click Insert and scroll to the ActiveX controls. I have 2 tables: one that needs to be filled with the data from the mastersheet and the mastersheet.
0 kommentar(er)
