VBA to Format & Transpose

[kenadams378]

I need to create a console that loads in some data from a external template and then formats the data based on my example attached. The attached is a manually completed version.

I've tried to call out each step below.

-Ask the user which file to use and open the network directory.
-Copy the range of the select file into the BBG sheet
-Copy column H of BBG into Conversion Sheet A based on the number of categories on mappings sheet
- Copy column AD of BBG into conversion sheet E
- Copy column K of BBG into conversion sheet F
- Populate the conversion sheet C with "RECORD" for the entire range of the sheet.

Copy entire contents of conversion sheet to Output sheet

Hope anyoner can help with this.

Regards

[pjwhitfield]

The bits you need are:
- Application.FileDialog which will open a Browse window to select a file.
- the rest of the items of copy and paste etc can be recorded as a macro and then amended to use within your VBA.

[MarvinP]

Hi Ken,

You have 18 worksheets in your example and it looks complicated. I'd suggest you post this to our Commercial Services forum located at the top of this screen. It looks like you are looking for more than a single formula and this might be the best bet for getting a good answer.