Solved Copy sequentially values of a row in sheet to another sheet

August 18, 2014 at 15:03:29
Specs: Windows 7
I have a row in Sheet 1 containing a bunch of input and calculated values. The purpose of this row is generating raw material required, cost, retail price, etc based on values added to other cells in the same row.

In another sheet 2, I would need that the results for this row would be automatically copied and that each time a new calculation is generated the values would be added sequentially to the next row. Using this, I'd be creating a cost and sales price analysis list for each product.

Maybe there is a macro for this.

message edited by collotcorp


See More: Copy sequentially values of a row in sheet to another sheet

Report •


#1
August 19, 2014 at 04:06:59
In order to provide a solution we would need a lot more detail related to the layout of your sheet, how the changes or made, when the row should be copied, etc.

For example, you said that you want the row copied each time a new calculation is generated. The sheet is going to calculate each time the workbook is opened, closed or changed. Are you sure you want the row copied every time? You may need to be more specific.

The more detail you can supply the easier it will be for us to offer a solution.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
August 19, 2014 at 07:40:01
Good day, Derby Dad

Please review file which you can download from http://pppm.info/recursos/calculos.zip .
In row 53, I have a calculation procedure where you can, by inputting data on the greenish cells, obtain parameters on raw materials usage and funds, including suggested retail price which will display in the white cells.

Since this must be done for each product, I think it would be more practical to display only one calculation bar in row 53 Columns A - V, and create a price list on Sheet 2 in a consecutive listing as one goes calculating parameters for each price. At present, the calculation row is repeated all the way through row 996.

Thanks,

Gus


Report •

#3
August 19, 2014 at 11:31:14
✔ Best Answer
I'm still not sure when you want the copy to take place. Since the sheet is going to calculate when any cell is changed (assuming Calculation is set to Automatic) do you want the row copied whenever any cell in Row 53 is changed?

What happens if a user makes a mistake? Suppose a user enters 43 in C53 and then realizes (s)he meant to enter 53. Do you want the row copied both times? Wouldn't that result in "erroneous" rows being copied to Sheet2?

By the way, what exactly do you mean by Sheet2? Is that the same as Hoja2? What is the purpose of Hoja3 - Hoja254?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions


Ask Question