Hi,
I need to create a macro and I have no idea what I'm doing using VBA and recording doesn't really work. Can anyone help??
I think I will need several macros but I want to be able to look at a cell in the macro template file (eg cells B8, B47 and B87) which has my "File ID" and then open the second file (with that File ID within a specific folder) which has the data I need. The data needs to be sorted in alphabetical order (currently A01, C01, E01 etc etc, needs to be A01, A02, A03 etc). and then paste column B into the D column of the original document. It then does the same for a second data file with the same name but found in a different folder and pastes into the column E.
I have no experience of VBA, so I really don't know how to open the area I need to edit the VBA or enter any VBA or anything. Recording a macro at the moment does everything I want but is limited to only opening the file I use while recording the macro, where I want it to open the file specific to B8, B47, B87 etc.
cheers
I need to create a macro and I have no idea what I'm doing using VBA and recording doesn't really work. Can anyone help??
I think I will need several macros but I want to be able to look at a cell in the macro template file (eg cells B8, B47 and B87) which has my "File ID" and then open the second file (with that File ID within a specific folder) which has the data I need. The data needs to be sorted in alphabetical order (currently A01, C01, E01 etc etc, needs to be A01, A02, A03 etc). and then paste column B into the D column of the original document. It then does the same for a second data file with the same name but found in a different folder and pastes into the column E.
I have no experience of VBA, so I really don't know how to open the area I need to edit the VBA or enter any VBA or anything. Recording a macro at the moment does everything I want but is limited to only opening the file I use while recording the macro, where I want it to open the file specific to B8, B47, B87 etc.
cheers
