VBA Copy Paste

[bhalbach]

I really need some assistance if someone could help...likely really easy for you guys.

I have been searching for examples I could use for 2 days...

I am trying to use VBA to copy data from multiple worksheets within a workbook to a worksheet called "Data" within the workbook.
- copy multiple data from sheets in the workbook, excluding some sheets that may or may not be hidded.
- the data comes from various cells in the sheets and needs to go to specific columns on the "Data" sheet
- the "data" sheet has the names of the sheets/tabs already in it starting at A3...the sheets/tabs were created from the "Data" sheet using VBA and I would like to validate the data coming from each sheet to the names in column A
- avoiding the screen flicker would be nice
- Can this be accomplished automatically without a command button? Like live data, as I work in the workbook.

Please help.

Brent

 

[bhalbach]

Click here for your file. Please use this version from now on because I have made several changes to the macros. Please refer back to Post #23 .

The click to “Add New Worksheets” on “Data” should add the EstSheet.

It is adding TskSheet.

 

[mumps]

In Post #28 you said:

Needs to add a TskSheet...not a EstSheet. I was struggling with it.

 

[bhalbach]

The click to “Add New Worksheets” on “Data” should add the EstSheet.

It is adding TskSheet.

The click “Add New Tasks” on “EstSheet” should add “TskShhet” which it is.

 

[bhalbach]

The click “Add New Tasks” on “EstSheet” should add “TskShhet” which it is.

CommandButton1 on "EstSheet" is copying Activesheet and inserting it...if this copied "TskSheet" it would be correct...I believe.

CommadnButton2 on "Data" needs to copy and insert "EstSheet"

 

[bhalbach]

CommandButton1 on "EstSheet" is copying Activesheet and inserting it...if this copied "TskSheet" it would be correct...I believe.

CommadnButton2 on "Data" needs to copy and insert "EstSheet"

https://www.dropbox.com/s/9njqh7a5xg2yhl3/bhalbach.xlsm?dl=0

 

[bhalbach]

https://www.dropbox.com/s/9njqh7a5xg2yhl3/bhalbach.xlsm?dl=0

I changed the code for Commandbutton2 on “data” (Add New Worksheets) so it added the EstSheets correctly.

But I do not understand your code for Commandbutton1 on “EstSheet” (Add New Tasks) so it adds the TskSheet.

 

[mumps]

Using both the "EstSheet" sheet and "TskSheet" sheet for each Bid Item makes naming the newly added sheets problematic for me. If we can go back to your original approach without using the "EstSheet" sheet and using only the "TskSheet" sheet for each Bid Item, the sequential naming of the sheets is automatically taken care of by Excel.

 

[bhalbach]

Using both the "EstSheet" sheet and "TskSheet" sheet for each Bid Item makes naming the newly added sheets problematic for me. If we can go back to your original approach without using the "EstSheet" sheet and using only the "TskSheet" sheet for each Bid Item, the sequential naming of the sheets is automatically taken care of by Excel.

Could you make the Add Worksheets” on Data Add both the EstSheet & TskSheet at same time? Would that resolve naming...I think it would.

Then click “Click to add Tasks” on the created TskSheet to add more?

 

[bhalbach]

Could you make the Add Worksheets” on Data Add both the EstSheet & TskSheet at same time? Would that resolve naming...I think it would.

Then click “Click to add Tasks” on the created TskSheet to add more?

This worksheet will add both the EstSheet & TskSheet when "Click to Build Worksheets"

I just have not got it to link to the EstSheet name so that excel will call it ie: 1 (2)

https://www.dropbox.com/s/65njdxxm76dvbgw/bhalbach2.xlsm?dl=0

 

[bhalbach]

This worksheet will add both the EstSheet & TskSheet when "Click to Build Worksheets"

I just have not got it to link to the EstSheet name so that excel will call it ie: 1 (2)

https://www.dropbox.com/s/65njdxxm76dvbgw/bhalbach2.xlsm?dl=0

If the TskSheet was coded to look at cell EstSheet B2 would that name it correctly? B2 populates with the value from column A in Data.