Copying cells from one workbook to another and saving an individual file for each cell

[Andyg666]

Hi,
I am new to macros but hope you can help me.
I have a list of items and related information (model, serial number etc) and I need a macro so that I can press a button and export the item name and serial number of each item into another workbook for each item on the original list including a pop up option of where these new workbooks would be saved.

I hope this makes sense, please help

 

[mumps]

It should only include C3 & C4 & C5 & H3 and the extension "xlsx".

 

[Andyg666]

It should only include C3 & C4 & C5 & H3 and the extension "xlsx".

Yes for the actual file name but I think windows or excel count the characters of the file path as part of the max number of characters. Its working fine now if I don't include C5 in the file name and I have the smallest possible file path.

It works until a cell that would be too long as a file name pops up then I get the error. Problem is I don't know its too long until the error pops up and then I have to start again which is a pain as it takes a long time to work through. There is 612 rows in the actual data file.

 

[mumps]

Maybe you can consider a different way of naming the file.

 

[Andyg666]

Maybe you can consider a different way of naming the file.

Thank you for your help, with a few tweaks (some on the data files eg get rid of the ???) It worked

 

[mumps]

You are very welcome.