Copy format to another sheet

[KirovHC]

Hi everyone,
I'm having issues creating this task:
* copy format cells from sheet 1 (range of cells A1: F6, some cells are merged)
* paste format on sheet 2 but paste on the first available line.
How would you write the code for this task?
I'm pretty new on VBA and i'm going crazy

 

[Joe4]

Welcome to the Board!

I find the easiest thing to do is just select/copy the whole first sheet to the second, then delete all the data.
If you use the Macro Recorder and record yourself doing this, you will get the VBA code that you need.

 

[KirovHC]

Welcome to the Board!

I find the easiest thing to do is just select/copy the whole first sheet to the second, then delete all the data.
If you use the Macro Recorder and record yourself doing this, you will get the VBA code that you need.

Hello!
I've done something similiar but problem is add all the copy/pasted on the last blank row!
I try to explain myself better: the second sheet will have a predetermined format to insert data, what I have to do is copy this format from the first sheet (essentially some cells formatted with borders and colors) and copy it in the second sheet in such a way that the operator always has a "table" available to enter data without doing it manually

 

[Joe4]

I am sorry, it really isn't clear to me what you are trying to do. In these cases, seeing an example is often very helpful.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[KirovHC]

I am sorry, it really isn't clear to me what you are trying to do. In these cases, seeing an example is often very helpful.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Here is an example:
I need to enter the cell layout A16:H20 in the first available blank row.

 

[Joe4]

I need to enter the cell layout A16:H20 in the first available blank row.

Will you ALWAYS be copying from the range A16:H20?
If not, how will you determine what range needs to be copied?

And we will always be posting it to the first available cell in column A on the other sheet, right?
What are the names of the two sheets?

 

[KirovHC]

Will you ALWAYS be copying from the range A16:H20?
If not, how will you determine what range needs to be copied?

I'm copying this from an hidden sheet so basically cells range will be always the same (A1:H5 or whatever).
I wanted to do something more complex like manually insert in a form the range cells to be copied in a form but I am not yet at this level

And we will always be posting it to the first available cell in column A on the other sheet, right?
What are the names of the two sheets?

Yes, Sheet1 and Sheet2

 

[KirovHC]

Mainwhile I tried with this simple code that seems working now

Private Sub CommandButton1_Click()
Sheets("Sheet1").Range("A1:Y5").Copy Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
End Sub

 

[Joe4]

Sorry, I had stepped away for lunch for a little bit.
Yep, that should work.