Editing a Macro to include multiple rows and include text formatting for leading zeros

I have been using this for a coupe of years and I have a question about editing it a little. First I need the values that are copied from the template to copy over in text form from the "Data" Tab. Secondly, the master sheet has multiple lines for each vendor. For the area highlighted in red I'd like for it to copy all cells in column C for the vendor and search the vendor by name. Then, move to the next sheet. Thanks!

Please Login or Register  to view this content.

Could you please attached your workbook so we have something to work on?
thanks

1) The code that is transfering data from one workbook to the other is using the .Value method, meaning only the "Text" is being transferred, no formulas or formatting. So it is already doing what you've described.

2) To copy multiple rows of data you could possibly look into applying a FILTER to your data, copying all visible data and pasting into your template. There's not enough information here to suggest more specifically than that.

@p24leclerc this is the spreadsheet I'm referring to.

@JBeaucaire I have leading zeros in the information that I am trying to copy over and when it pastes into the next sheet it pastes it over as "values", which excludes the zeros, so should I add a fomatting component first? Also, the amount of rows changes by the lines allocated for each vendor, thery're variable so I need it to paste 1 or more cells according to vendor.

YEs, you will need to format the target columns or cells with a number format that includes a specific number of digits. This will insure the "value" displays with the leading zeros.

Here's a tweak that changes the 1line copy command into 2line copy commands so you can add more controls. IN this version it is pasting the value AND the numberformat:

Please Login or Register  to view this content.

Post your new workbook with all the changes you've made so far with these prior questions. I'll see about adding some code to only copy the template once per unque Vendor code and include all the rows for that vendor.

Can you make sure the columns you want included in the template from the raw data are absolutely clear? Thanks.

Ok. I made a tab of what I want the finished product to look like. When there is a change in name I want it to copy the columns that I noted in the "Amazon" tab in those columns. Thanks for everything!

Try this:

Please Login or Register  to view this content.