Any Excel/VBA experts

**eek** · 1 March 2022, 15:04

Originally posted by WTFH View Post

Help, I'm looking to get a macro that will convert a single line on a spreadsheet into multiple lines based on a value on the line:

Input:

Item	Code	Quantity
A1509	WTFH1	5
A1645	HFTW3	3

.
Output:

Item	Code	Quantity	Code2
A1509	WTFH1	1	WTFH1001
A1509	WTFH1	1	WTFH1002
A1509	WTFH1	1	WTFH1003
A1509	WTFH1	1	WTFH1004
A1509	WTFH1	1	WTFH1005
A1645	HFTW3	1	HFTW3001
A1645	HFTW3	1	HFTW3002
A1645	HFTW3	1	HFTW3003

Any thoughts on how I can do that with a macro?

Splitting one row into multiple rows using cell value | MrExcel Message Board give you a starting point?

**jamesbrown** · 1 March 2022, 15:20

Appreciate this isn't answering the question you posed, but export it to csv and then use your preferred scripting language, piece of cake. Excel, yuck. Macros, yuck. If someone wants an Excel spreadsheet that contains a macro, yuck.

**WTFH** · 1 March 2022, 15:27

Originally posted by eek View Post

Splitting one row into multiple rows using cell value | MrExcel Message Board give you a starting point?

Thanks, you're better than google.

**WTFH** · 1 March 2022, 15:30

Originally posted by jamesbrown View Post

Appreciate this isn't answering the question you posed, but export it to csv and then use your preferred scripting language, piece of cake. Excel, yuck. Macros, yuck. If someone wants an Excel spreadsheet that contains a macro, yuck.

Issue is that I'm dealing with a guy who is less technically literate than me. He has data in a spreadsheet, he can copy the data in and out, but even asking him to do a fill down causes problems. I thought that if I could give him a spreadsheet with the macro and just tell him to past his data into one sheet, then hit a button, he'd not mess that up.

**jamesbrown** · 1 March 2022, 15:46

Originally posted by WTFH View Post

Issue is that I'm dealing with a guy who is less technically literate than me. He has data in a spreadsheet, he can copy the data in and out, but even asking him to do a fill down causes problems. I thought that if I could give him a spreadsheet with the macro and just tell him to past his data into one sheet, then hit a button, he'd not mess that up.

Ah, fair enough. Needs must, I guess. Make sure he enables the macro (edit mode or something) after you share it because it is probably disabled by default for security.

**Lance** · 6 March 2022, 10:47

Originally posted by jamesbrown View Post

Ah, fair enough. Needs must, I guess. Make sure he enables the macro (edit mode or something) after you share it because it is probably disabled by default for security.

if not disabled already, it will likely be so in the next office update. Macros are serious security risk.
I would suggest that if macros are required then get them signed and ask IT admins to allow signed/trusted macros only. And only ones that are signed using the company's CA.

Any Excel/VBA experts