Macro to copy selected cells to another sheet.

[And180y]

I have attached a workbook which I have changed from an original and need some help to edit/create a new macro
in order to move specific data from one sheet to the other.
So in the Kit totals sheet if A2,4,6,8 etc has data that should be copied to the next empty cell in Pricing colum E
So in the Kit totals sheet if N2,4,6,8 etc has data that should be copied to the next empty cell in Pricing colum P
(all the info in these rows and more is pulled from another sheet with another macro) All the cells could have info in them
but I only need what is in E & P in the pricing sheet. I have added kit 1,2,3 in the cells I am trying to get the information to populate.

Thanks in advance for any help.

[bsalv]

Please Login or Register  to view this content.

[And180y]

Thankyou so much, works perfect. If kit sheet had more rows filled in will I need to change anything?

[bsalv]

Please Login or Register  to view this content.

red part = always exact 14 columns wide.
green part : number of rows is determined by currentregion = block of cells that is bounded by an empty row or column, thus autosize itself.
brown part : start at the 2nd row

Answer : you don't have to change anything when you add more rows.

[And180y]

bsalv, thanks so much for your help and direction. :-)

[And180y]

I wonder if anyone can help, bsalv gave me a solution to the original sheet which I am sure worked fine but
some how, (not sure if by moving sheets) now it doesnt work. Hoping someone could take a quick look and
explain whats gone wrong. T.I.A.
I have manually inserted the data into the pricing sheet which should fill from the Kit sheet to show the desired result.

[AB33]

I run the code in both attached and appears to work. The sheet names and layouts on comments 1 and 6 are the same, so I could not see any difference or issue.

[And180y]

Thanks AB33, When I run the macro this is the result not, sure whats gone wrong if you are getting the result in the 2nd pic?

Attachment 764750


I should/used to get Attachment 764751

[AB33]

I can't open the pictures. Please attach the sample you are not getting the desired result.

[And180y]

AB33, sincere apologies for wasting your time. I had locked my sheet and had scroll locks
on it as well thus not allowing the macro to run as intended. Thanks for your help.