Pulling Certain Information From a Worksheet Using VBA

[EdwardSnowden]

Hi everyone. I have attached an Excel workbook. The first column is what the data currently looks like and the "Goals" column is what I'd like it to look like. I do have some VBA experience, however, this is proving very difficult for me. Any guidance would be beyond appreciated. I always love learning techniques from this forum.

[alansidman]

Would a presentation as shown below work for you. If so, then advise and I will share the solution with you.

Data Range

	A	B	C	D
1	Custom	Custom.1	Custom.2	Custom.3
2	Department 1	1014 Kate M.	Month to Date	Year to Date
3	Department 1	1015 Spencer W.	Month to Date	Year to Date
4	Department 1	1022 Carloine K.	Month to Date	Year to Date
5	Department 1	1022 Carloine K.	Month to Date	Year to Date
6	Department 2	1014 Kate M.	Month to Date	Year to Date
7	Department 2	1015 Spencer W.	Month to Date	Year to Date
8	Department 2	1022 Carloine K.	Month to Date	Year to Date
9	Department 2	1022 Carloine K.	Month to Date	Year to Date

[Marc L]

Hi !

Where do you find departement #3 to 7 in source data according to your expected result ?

[EdwardSnowden]

Yes! This would work for me

[EdwardSnowden]

alansidman: the above comment was for you. Sorry about that.

[alansidman]

Ok. I used Power Query. Attached is the file and below is the Mcode.

Please Login or Register  to view this content.

[EdwardSnowden]

alansidman: Thank you for this, however, this actually doesn't end up working for me as I go through the data manipulation. I do need to have it in the exact format that it shows in the Excel file I attached after more deep-thought. Can you help me with this? My apologies.

[alansidman]

Sorry, but I cannot replicate what you need. Used up all the arrows in my quiver on this one.

[jindon]

For the data provided.

Please Login or Register  to view this content.

[EdwardSnowden]

Thank you to everyone who helped :D I got it figured out with my own code in VBA and it worked really well! It was a much longer code than Jindon provided sadly lol