Copy specific data from a sheet to temp sheet and copy temp sheet to new workbook

If you press the diagonal arrow that is on the top left of your sheet before the "1" row and the "A" column it will highlight all data on the sheet. Press CTRL+C to copy, go to new sheet and click on the very first cell, press CTRL+V to paste.
Hope that helps.

Kind Regards,

Thomas Bailey

Thanks Thomas! But I want to achieve this through vba code or macro..

Try this - it copies the contents of cell a1 in worksheet "name" to a1 of worksheet "name2"
then deletes "name"
you will need to mess with the names and ranges eg correct names and range a1:bz255 or whatever
hope it works because I am a total newb lol


Sub Rectangle3_Click()
Worksheets("name").Range("a1").Copy _
Destination:=Worksheets("name2").Range("a1")
Application.DisplayAlerts = False
Sheets("name").Delete
Application.DisplayAlerts = True
End Sub

i made a rectangle to click but you could just run it however you like - also the code lives in the workboook section

lol i just realised this thread is almost a year old .... i expect that the OP either sorted it or maybe became a traffic warden instead!
lol