hi,
i've got a workbook with 4 worksheets in it. on has the products list of the combined packages with a cell for prices, the other sheet has a breakdown of the componets with seperate prices.
the breakdown sheet also has the package price on it too.
what i need is a macro to copy whatever is in a cell on the breakdown sheet to the price box on the products list sheet.
so column "J" on sheet 3 has all the prices i need to be copied over to sheet 2 column "E"
the price's however are not on every row. they staggered out eg every 2nd row, 3rd, row as are the price cell's on sheet 2
there are over 1000 lines on each sheet
so i need something like
whatever is in sheet3.j8 copy to sheet2.e3 and so on
any help would be great
i've got a workbook with 4 worksheets in it. on has the products list of the combined packages with a cell for prices, the other sheet has a breakdown of the componets with seperate prices.
the breakdown sheet also has the package price on it too.
what i need is a macro to copy whatever is in a cell on the breakdown sheet to the price box on the products list sheet.
so column "J" on sheet 3 has all the prices i need to be copied over to sheet 2 column "E"
the price's however are not on every row. they staggered out eg every 2nd row, 3rd, row as are the price cell's on sheet 2
there are over 1000 lines on each sheet
so i need something like
whatever is in sheet3.j8 copy to sheet2.e3 and so on
any help would be great
