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.

 

[jah1385]

You are very welcome.

Hi Mumps i wonder if you can also assist me please? i have a simple excel sheet with Name and Date of Graduation.

A1 Name... B1 Date
A2 John B2 20/02/2024
A3 Michelle B3 20/02/2024
A4 Jay B4 10/04/2024

the list goes on.. i would like the file linked to the powerpoint and each name and date of training generates a pdf certificate. is this possible? if so i can share a basic file and graduation certificate files

 

[mumps]

Hi and welcome to the forum. Please start your own new thread and explain in detail what you want to do.

 

[jah1385]

just posted a new thread thanks mumps