Price Tagging/Labeling VBA

[ShumsFaruk]

Dear All,

Excel VBA for Copy data from one sheet to another sheet are many on internet, but non of them helps me.

I would like to extract Product Code (which starts from B2) & its Price (which starts from C2) from the sheet "Pricing Data" to sheet "Price Tags" which has default format.

I need vba to count quantity (which starts from D2 until last row) of every product code in "Pricing Data" & paste that many times its Product Code under the cell below "Code" (which is merged cell) & its price under the cell below "Our Price (which is merged cell) in" "Price Tags" sheet.

Currently I am pasting it manually, I need above process to continue until last product code in "Price Data", and create such Price Labelling format automatically (I am not sure if its possible), if not then I will paste required format manually as per total price tags required.

PS: I don't see any option of attaching sample file. Kindly help.

Shums.

 

[hiker95]

ShumsFaruk,

1. What version of Excel and Windows are you using?

2. Are you using a PC or a Mac?

PS: I don't see any option of attaching sample file. Kindly help.

You can upload your workbook to Box Net,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.

 

[ShumsFaruk]

Hi Hiker,

Thanks for your reply.

1. I am Office 2010.

2. I am using Windows.

Uploading to BoxNet, do I need to sign up first?

 

[ShumsFaruk]

I have uploaded my file to below link:

FileSwap.com : Price tag.xlsx download free

 

[ShumsFaruk]

Sorry for bothering everyone...

I found Mail Merge option in Word to solve this issue.

PS: I don't know how to reply with Solved.