Copy cells from one sheet to another

**BG6778** · 12-13-2011, 11:27 AM

Any help would be greatly appreciated... I have office 2010

I was interested in finding a simple copy/paste VBA function that would allow me to copy a group of cells from one Excel sheet to another, or just copy an entire sheet to another.

The first sheet would be a "Master" blank file. The next sheet (Data1) would have the "Master" blank sheet copied and data would be filled out. After all data fields are completed, I would like to use a macro or function to copy the "Master" sheet to the next sheet (sheet3, called: "Data2").

My first thought was a function {Copy_Cells() } that would just copy any group of cells:

To be used in sheet3 (Data2) in cell A1: =IF(Data1!A3="", "", (Copy_Cells(Master!A1:Master!P40)))

This function would just copy the complete sheet1 (Master) to sheet3 (Data2).

I just seem to be having a bit of a problem coming up with something - any help or direction would be fantastic & thank you in advance.

Bill

**kwg2200** · 12-13-2011, 04:11 PM

If I understand you correctly, you just want to copy everything on sheet 1 and put in on sheet 3? I have a feeling that you may be asking for something more, but if not then this simple macro should work. Just make sure that you put the code in the workbook code window, not on a specific sheet.

Please Login or Register  to view this content.

**BG6778** · 12-13-2011, 04:55 PM

Thank you for the help.

How would I make the worksheet(3) into a variable - so that I could paste the blank form (Master) onto any blank sheet?

The final goal is to have a Master blank form on sheet1, first paste it to sheet2, then - paste the Master blank form to the next (sheet3) after the first (sheet2) is complete. And so on.

Again, thank you!

**kwg2200** · 12-13-2011, 06:35 PM

This code will copy and paste worksheet 1 (your master sheet) to the next empty worksheet (assuming that if cell A1 is empty the rest of the sheet is empty too). You will get an error if there are no more blank worksheets. I think that this should get you closer to your goal. I'll taker a closer look later or tomorrow to try to help you out more.

Please Login or Register  to view this content.

**BG6778** · 12-14-2011, 02:13 PM

Thank you for the quick response!
I will give it a try - again, thank you!

Ultimately, I would like to have the copy/paste of the blank form from sheet1 to start on sheet3 (after all data is filled in on sheet2). At the same time, locking out sheet2 (password protected) and to change the name of sheet2 to a cell value (in sheet2, cell A4, "Data1"). And so on with sheet3.

Although I have not had the time necessary, this greatly helps.

Bill