Any Excel/VBA experts

[Lance]

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.

[jamesbrown]

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.

[WTFH]

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.

[WTFH]

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

Thanks, you're better than google.

[jamesbrown]

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.

[eek]

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?

[WTFH]

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?