copy range in another sheet and create border

Originally Posted by royUK

It would be nice to see you attempting some code yourself! I gave you sample code earlier to copy a range. This could easily be adapted to do what you want, then all you would need is code to add the borders!

Before posting I always attempt on my own but without succes this time ..

Please Login or Register  to view this content.

I tried this code, it works to copy the desired data but also it delete range A1 and B1, and I don't understand why

Please Login or Register  to view this content.

I added the green code for the border, but it will make border only for column A and B. I don't know how to select column C also because it has no values.

Originally Posted by royUK

Will Sheet1 have data in & the formatting?

I don't understand your question, sorry.
Sheet 1 has data in range A1,B1,C1 and I have to copy data from sheet2.

Originally Posted by shg

Maybe ...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I don't think this is exactly what I need because if I have data in Column E in "sheet2" , the code will copy this data too.I would like to copy only from column C and D.

Originally Posted by royUK

Hi shg, I don't think you are adding the borders with your code. I've created a Style called Borders and then amended the code to this

Please Login or Register  to view this content.

iscar_marius, to create the style

Select a cell that is already formatted as you want
From the Format menu choose Styles
In the Style name Box type Borders
Click Add
The style is now available in that workbook

Almost what I need, but thie code will delete data from range A1,B1 and C1 (sheet1) and I don't need that.

Also this code:

Please Login or Register  to view this content.

Will copy data also from column E if is not empty and I don't want that.

Thanks for the code and for "style", I didn't know that.

Originally Posted by shg

Iscar, that's why it's helpful to post an example that reflects your actual data layout.

I'm trying to keep my examples as simple as possible. But you are right.
Sorry!

Originally Posted by royUK

Your posted code deleted the data! So you want to keep that data & post below it?

Yes!
I want to keep the data from Sheet1, range A1, B1 and C1, and copy in range A2, from sheet2 range C3-End(xlUp) and range D3-End(xlUp).
Which part of the code deleted "Sheet1, range A1, B1 and C1" ?

Originally Posted by royUK

This code clears the data

Please Login or Register  to view this content.

Try this

Please Login or Register  to view this content.

Please open attached file!
Not exactly what I need because this code will copy data also from column E (sheet2) if is not empty and I don't need that.


I was expecting that this code:

Please Login or Register  to view this content.

Will delete all data from column A and B, except A1 and B1, but it seems that is not true.

Can you give some code that will delete all data from column A and B, except A1 and B1 ?

Thank you for your time!

Originally Posted by royUK

By not stating what you want initially & finally adding a workbook that represents your code you are making our task of providing a solution much more difficult. If you don't ask your question in a concise way with the correct requirements you will find that you won't get answers!

Please Login or Register  to view this content.

The same problem, this code will delete range A1 and B1 from sheet1. Range A1= "Item" and range "B1"="quantity", I need this data! I need row 1 from sheet1 to be the same all the time. I need the copied values in sheet1 starting with row2.


Belive me that I had tried to be as concise as possible, but my english is not helping me all the time.
Please read my first post from this thread, I had tried to say that I need to copy :
-from sheet2- column C and D, from row 3 to the end
-to sheet1 - column A and B, starting with row 2
after that I need to create a border to the copied values and I need to create a border to the empty cell from column C (in sheet1)
Then and now I need the same thing.

But, I need to copy data from sheet2, only column C and D, starting with row 3 (C3:D3,C4:D4,C5:D5 .. to the end). Also I need data from sheet1, Range A1 and B1 unaltered.

Sorry one more time for my english, and thank you for your patience!

Originally Posted by royUK

It doesn't delete A1 & B1 for me. It's still not clear what you want, are you wanting to delete the existing data on sheet1 before adding data from sheet2?

Please open attached file and run the code!
Before runing the code in sheet1:

Please Login or Register  to view this content.

After runing the code in sheet1:

Please Login or Register  to view this content.

Range A1 and B1 from sheet1 has been deleted! I don't want that! I need this range the same all the time.

I want to delete only data from A2:B2,A3:B3,A4:B4 ..etc. from sheet1 before adding data from sheet2, beacause the data from sheet 2 will not be the same all the time.

I am using office 2003!

Originally Posted by royUK

It will delete the headers if you have no other data in column B of sheet1.

Please Login or Register  to view this content.

This it's what I was looking for!
But, I would like a little improvement if is possible.
If I modify the number of rows to copy (sheet2), let's say, from 24 to 11 and I run one more time the code I will have in sheet 1 some blank cell with border. I don't want that!.
Please open attached file!

Originally Posted by royUK

Hopefully this is right

Please Login or Register  to view this content.

Thank you for all your help!
Thread solved