Copy data from Multiple to SINGLE worksheet.

[zebradoby]

I want to copy data from multiple worksheets into MASTER worksheets. Can anyone help please?
User clicks a button and it copies data into MASTER from all worksheets. I have attached the test template.
Thanks

[zebradoby]

File attached.

[lucas]

Try this Tex. You have to delete the master sheet because it is created by the script.

I deleted your Master but it looked like it had some code where you were trying to get this to work........let me know how close we are....

[david000]

let me know how close we are....

I would delete all but rows 1:2 above the try me button first. i.e get rid of the extra headers.

[zebradoby]

i want to give a button on master worksheet on right hand side. the data will flow to master worksheet and pull corresponding data from all worksheets on clicking this button. how do i do that? I am confused. and i am new to vba.

[lucas]

Maybe like this......?

[zebradoby]

Hi Lucas

I get an error message. See the attached file. Its on

CommandBars("My Toolbar").Delete

This code of line.

Also, how do I populate the date and time on the last column in Master worksheet. That will be the date and time when the macro is run each time.

Can you please help!

[zebradoby]

Hi

i have attached the file. and the button on MAIN Worksheet.

thanks

[zebradoby]

I fixed the error. Thats all i need for now:

How do I populate the date and time on the last column in Master worksheet. That will be the date and time when the macro is run each time.

To Run: Click button MAIN Worksheet.


Can you please help! Latest File is attached.

[zebradoby]

Latest file is attached.


How do I populate the date and time on the last column in Master worksheet. That will be the date and time when the macro is run each time.

To Run: Click button on MAIN Worksheet.


Can you please help! Latest File is attached

[lucas]

You keep asking for the last column for the date but I believe you mean the last row......see attached.

[zebradoby]

Can we display the date and time below the button on Main worksheet used to run the macro?

[lucas]

yes, you just reference the sheet main and the cell that you want to put the date in and make it's value = to Now

[VBA] Sheets("Main").Range("C6").Value = Now[/VBA]

[zebradoby]

i did this..it RESOLVED it.

Sheets("Main").Select
ActiveCell.FormulaR1C1 = ""
ActiveCell.FormulaR1C1 = "=NOW()"
Range("C10").Select

[lucas]

Looks like you found your macro recorder......good. You should take a look at the code I posted as all of the extra selects are unnecessary. Another thing in your code when you select the sheet.....which cell is selected? If if is not the one you want the date in then the wrong cell will get the date.....

compare my code to yours and see if you can understand what is going on. Good to see you are learning something from the exercise.

[zebradoby]

it updates date into where the cursor was last along with c10. how do i get it ONLY on c10 on main worksheet.

[zebradoby]

i am good disregard my last posting.

[zebradoby]

Hi LUCAS

The last row saved on running the macro is same as HEADER row in MASTER. Can we fix that? See attached file. We do not want to repeat the HEADER row at the bottom again.


THANKS

[david000]

The last row saved on running the macro is same as HEADER row in MASTER. Can we fix that? See attached file. We do not want to repeat the HEADER row at the bottom again.

You have a sheet named "Unknown" on that sheet you have no data in column "A" - as a result, it's causing the first row to be copied over do to the nature of the code. Put some data in that column and it will work.

In your situation column A is mandatory!

[lucas]

Yep, sheet unknown is the culprit. Delete it and run the code to see what David is talking about.