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

 

[mumps]

Re: PLease Help - VBA Copy Paste

I'm sorry but I think I'm even more confused now. May be if we take it one step at a time it might help. Let's start with what you want to happen when you click the "Click to Build Worksheets (EstSheet)" button. Be specific in your description. This formula needs to be clarified: '=Sheet1(1)K7 +Sheet1(2)K7 + etc (TskSheet)
Do you mean: '=Sheet("1(1)")K7 +Sheet("1(2)")K7 + etc (TskSheet) Also, column K in Sheet("1(1)") has no values. What do you mean by "etc (TskSheet)"?

 

[bhalbach]

Re: PLease Help - VBA Copy Paste

I have managed to get your code to use the TskSheet as the copy instead of the active sheet in CommandButton1...but to tell you the truth I do not understand how your code is working with CommandButton1.

 

[mumps]

Re: PLease Help - VBA Copy Paste

I think that the only way we will be able to make progress is if we take it a little bit at a time. One way of doing this is to work with a mock-up of each step. For example, click the "Click to Build Worksheets (EstSheet)" button to create the necessary sheets and then manually complete the new sheets with the data you expect to see in them. If you could do this and upload a copy, we'll go from there.

 

[bhalbach]

Re: PLease Help - VBA Copy Paste

Sorry...

When I "Click to Build Worksheets(EstSheet)" it should work exactly as it does...it adds the EstSheet named to match column A of "Data" and also copies values from "Data" columns A,B,C,D and pastes into the new sheet named to match "Data" Column A. This button is working correctly.

Then once the above has completed...
I can go to the newly created sheets (that are named to match "Data" column A.) on these sheets when "Click to Add New Tasks (TskSheet) it adds a "TskSheet"​

 

[mumps]

Re: PLease Help - VBA Copy Paste

In the last file you uploaded, when you click the "Click to Add New Tasks (TskSheet)", it doesn't add a TskSheet, it adds an EstSheet.

 

[bhalbach]

Re: PLease Help - VBA Copy Paste

Sorry...

When I "Click to Build Worksheets(EstSheet)" it should work exactly as it does...it adds the EstSheet named to match column A of "Data" and also copies values from "Data" columns A,B,C,D and pastes into the new sheet named to match "Data" Column A. This button is working correctly.

Then once the above has completed...
I can go to the newly created sheets (that are named to match "Data" column A.) on these sheets when "Click to Add New Tasks (TskSheet) it adds a "TskSheet"​

These should be named to match with (2), (3), (4)...ie: 1(2), 1(3), 1(4)

 

[bhalbach]

Re: PLease Help - VBA Copy Paste

In the last file you uploaded, when you click the "Click to Add New Tasks (TskSheet)", it doesn't add a TskSheet, it adds an EstSheet.

It should Add a TskSheet

 

[bhalbach]

Re: PLease Help - VBA Copy Paste

It should Add a TskSheet

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

 

[bhalbach]

Re: PLease Help - VBA Copy Paste

Make any sense thus far?

 

[mumps]

Re: PLease Help - VBA Copy Paste

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 .