Alter existing formula to copy specific cells in row instead of copy entire column

I received some wonderful help here recently and was hoping for a bit more. I believe what I'm trying to do is similar to the help I received the other day, but I'm having an awful time trying to alter that macro to suit this new need.

I need the macro to look at cells B9:B84 on the Sheet1 tab of the Cost Template. If it finds an x I need it to copy the 3 cells to the right of the x and paste them in a template. For example if it sees an x in cell B9 it would copy cells C9, D9 and E9, open the Purchase Order to the Detail tab, then paste it to cells B3, C3 and D3. It would continue looking for an x down to B84. So if it found 5 cells with x, it would give me 5 instances of the Purchase Order with 3 cells pasted into each.

I've attached my Cost Template and the Purchase Order it needs to copy to. In the Cost Template is a macro called Create_PO. This is what I was trying to alter to make this happen. I can't seem to get it right! FYI in case it matters, I had to change the Cost Template from .xltm to .xlsm in order to upload it on this site.

I am happy to answer any clarification questions & even happy to pay for any assistance with this! It is driving me batty, but I love learning more about macros from you wonderful people!

Hi AB33. I very much appreciate your reply & your efforts! I just took a quick peek & this might be just what I need. I won't be at my computer with the forms again until morning, but I will test it first thing. I soooo much appreciate your help. I clicked the 'add reputation' button to give you good feedback and will mark this as solved as soon as I get to test it properly. You are the best! This is a great forum.

Hi AB33. This is almost what I had in mind. Your macro puts them all into a single instance of my template. I actually need it to put each 3 column entry into an individual instance of the template. So if I had 3 Xs I would get 3 templates, each with the 3 columns to the right of the x in it. I need it to create a separate PO for painting, a separate PO for ceramic tile, etc. That is what I'm having a hard time figuring out how to write. Any help would be greatly appreciated!

Please show me the out put in a sample. What are 3 templates? Do you want you want to create 3 sheets?
When the code finds, x, it copies 3 columns to the right and put them in to next empty row in column B of the same sheet.

I think I didn't explain it very well. There are no additional forms that I haven't uploaded. The 3 templates I mentioned are 3 instances of the same template, the Purchase Order. The code would find an x at B24 on the Cost Template, copy C24:E24, and paste it to the PO. Then it would find the next x in B25 of the Cost template, copy C25:E25, and paste it into a new blank instance of the same PO. Repeat. In the end if there were 3 Xs on the Cost Template, I would have 3 Purchase Orders. One would contain C24:E24, one would contain C25:E25, and one would contain C26:E26. Thank you again!

Still not sure I am getting it!
All I see is there are 2 sheets in the PO sheet, sheet Quote and sheet Detail. The codes copies Column C-E in to sheet Detail.
Did you check my post 3? What is wrong and what should be changed?

I'm really not good at explaining it. Attached is what the output would be. There are 3 Xs in the attached Cost Template, which would result in the attached 3 POs.

I forgot to say if there were 5 Xs, it would make 5 POs, etc.

Okay!
Where are these 3 PO? Are not they are 3 different books? Or are they 3 sheets on the same book?

I have a folder that contains both the Cost Template and a single blank Purchase Order. I want it to open a new copy of that Purchase Order for each X. There are not 3 different Purchase Orders for it to work with, just 1 Purchase Order workbook that will need to be opened 3 times with different data in each.

The code that does something very similar is functioning well, if you want to see what I mean in action. In my original post I uploaded a Cost Template & a Purchase Order. (Make sure to save both of these in the same folder or it won't work.) Open the Cost Template & put an x in cells AA1 and AB1. Then run the macro called Create_PO. It will copy column AA and paste it to the Purchase order, then it will copy column AB and paste it into a new instance of the Purchase Order. It saves both POs in the same folder and names then something like Column37 and Column38.

I'm looking to do the same thing on Sheet1, except instead of copying a whole column, it will just copy those 3 cells to the right of the x. I just can't figure it out.

I hope this makes sense. I wish I could explain it better, but I'm pretty new at this & still working on the right terminology. Thanks for your patience & trying to work through this with me.