Transfer and combine data from 2 separate Sheet to 1 sheet

I have a workbook that I started building to help me manage my online store a little faster and I was hoping someone could help me. I am working on a MAC version of Excel.Tire assistant.xlsm

What I have is sheets named "Raw Transfer" and "Common Attributes", I need to get data from these 2 sheets to a sheet named "CSV Transfer". I have explained where everything is and needs to go on the "Common Attributes" sheet. I would prefer this to be done through a button on the "Common Attributes" sheet using VBA.

I also have a few sloppy formulas that I came up with throughout the workbook and it would be awesome if someone could clean them up and maybe put them in VBA.

Any help is much appreciated and if you don't feel like setting up everything for me, I can also do it if I have some examples...

Sorry I guess I could have explained this a little better.

On the Common attributes page you should see things highlighted in blue, red and brown. The Blue represents the cell on the CSV Transfer sheet where the data needs to go. The Red represents which product type to transfer this data i.e.

-if it says Master then it belongs to the master Product only, however the master product is not on the Raw transfer page so its data is all on the common attributes page. The Master product should be added to the top of the CSV transfer page and it will not have a price, qty, tire specs, etc. The way my website is (Which Im not to happy with) is that the master product is like a place holder and any part that is a variation of it is added below it so when you pull up this specific tire model, all variations show up under it.

-if it says Independent that means the data comes from each product individually and this data is located on the Raw Transfer sheet and its location is highlighted in brown.

-if it says Subs then it is applied to sub-versions of the master

-if it says all then its attribute needs to be copied to all the products - master and sub-versions


I hope I have explained this good enough, and I really appreciate your Help!

I really hate the website builder from my website host. As soon as my contract is finished I'm going to hire a local company to build a custom website exactly how I want it.

I understand,

Basically what needs to happen is first the Master product needs to be "created" in the CSV Transfer sheet in row 2 because it does not exist (This will always be the same procedure).

The data for the master product comes from the Common attributes sheet cells s3:s13 (which are marked as the master product), s44:s80,a3,a19,a35,a51,a67,i3,i19,i35,i51,i67 because these attributes are used in all products (Master and Subs).




Once the Master product has been created the Sub-Versions need to be added to the CSV Transfer sheet. The data for the Sub-Versions comes from the Raw Transfer sheet and the Common Attributes sheet cells s37:s42,s44:s80,a3,a19,a35,a51,a67,i3,i19,i35,i51,i67. If data is labeled Independent then there are cells labeled with the the datas location which are highlighted in brown.


The cells that are highlighted in blue represent to location on the CSV Transfer sheet where the data needs to go.


I've tried as good as I can to describe everything on the common attributes sheet as possible so you don't have to flip through 3 different sheet to write the code, in theory you have all the information you need to write the code by looking at just the common attributes sheet. Maybe I'm wrong though as I'm not an excel pro...


Please don't hesitate to ask if you have more questions. Just so you know though I will be on the road tomorrow driving to Slovakia for work so if I don't respond in a timely manner thats why...

CSV example.xlsx

Here is an example of how this should look when finished.

Thank You but There were a few problems, I hope its not because im on a MAC,

the cells "S37 to S42" from the common attributes sheet need to be added to the CSV Transfer page but only for the Sub Versions, Right now they are copied to the Master Product only, You you could use column "CC" to distinguish between the Master and Sub-versions since the Master does not get this value

The cells "S44 to S80,a3,a19,a35,a51,a67,i3,i19,i35,i51,i67" from the common attributes sheet need to be added to the CSV Transfer page for all the products, not just the master.

Thank you for the help, and yes I made it to Slovakia... I'm beat!

Awesome Rudi! It works perfectly!

Also Thank you for the comments on the VBA File, That makes it a little easier for a newbie like me to edit it later if needed!

Once again Thanks!

Awesome Rudi! It works perfectly!

Also Thank you for the comments on the VBA File, That makes it a little easier for a newbie like me to edit it later if needed!

Once again Thanks!

Voila_Capture68.jpgVoila_Capture69.jpg