VBA Issue - Multiplying an entire row by number and returning it to another worksheet

Hi,

I have a workbook that contains 3 sheets, 'Model Overview Sheet' , 'copier' and 'Return Row'

In the worksheet 'copier' it has 3 columns. SSR Reference which is a reference to the value in column A in the 'Model Overview Sheet'

In column B of 'copier' it has the row reference that the ssr reference number corresponds to in 'model overview sheet'

In column C of 'copier' there is the number that I would like each row in the 'model overview sheet' multiplied by.

I have macro code that returns rows from the 'model overview sheet' based on the ssr references entered into 'copier'.

My only issue is that I would like each row to be multiplied by the number given in column C of 'copier', can someone help me with that?

The spreadsheet is attached

Here is my code for the macro -

Please Login or Register  to view this content.

Any help would be appreciated.

Please change the QUOTE tags to CODE tags.

Thanks.

Thank you -- looking at your workbook now.

When you say 'mutiplied by', do you multiply each value in the row, or copy multiple times?

OK, try this (I confess I don't understand your code; suggest you step through it).

Please Login or Register  to view this content.