Morning,
Attached is the sample filtered data, what i need my macro to do is;
- Prompt user to select network file
- Once selected, filter data on 'A214' Hiport Fund
- Use data on sheet 1 to populate sheet 2 but for each line on sheet 1 create 3 lines of data on sheet 2
- Replace 'A214' on sheet 2 with 'A200', 'A210' & 'A220' on the 3 lines of data.
- Keep original data on sheet 1.
I hope anyone can help, i have been able to write code to promt the user for the file but now i'm struggling....
Much appreciated
Bookmarks