Copying an entire worksheet to another worksheet automatically
Closed
Andy
-
Apr 7, 2016 at 10:52 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Apr 9, 2016 at 06:24 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Apr 9, 2016 at 06:24 AM
Related:
- Copying an entire worksheet to another worksheet automatically
- Transfer data from one excel worksheet to another automatically - Guide
- How do you add a username or author to a worksheet - Guide
- Automatically run a macro when opening a worksheet - Guide
- Pc restarts automatically - Guide
- Download automatically while roaming - Guide
2 responses
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Apr 8, 2016 at 02:52 AM
Apr 8, 2016 at 02:52 AM
Hello Andy,
To copy a work sheet entirely, the simplest way is to right click on the sheet tab that you wish to copy, select "Move or Copy" from the menu that appears. In the dialogue box that then appears, tick the "Create a Copy" box and then click OK.
All done!
Cheerio,
vcoolio.
To copy a work sheet entirely, the simplest way is to right click on the sheet tab that you wish to copy, select "Move or Copy" from the menu that appears. In the dialogue box that then appears, tick the "Create a Copy" box and then click OK.
All done!
Cheerio,
vcoolio.
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Apr 9, 2016 at 06:24 AM
Apr 9, 2016 at 06:24 AM
Hello Andy,
Yes, your second post is considerably different from your first.
Excel is a very powerful object and has many inbuilt functions which will do all that you ask.
In regards the external query, read the following link which will guide you in the right direction:-
https://support.microsoft.com/en-us/office/refresh-an-external-data-connection-in-excel-1524175f-777a-48fc-8fc7-c8514b984440?redirectsourcepath=%252fen-us%252farticle%252frefresh-an-external-data-connection-036367ac-d139-49e1-b64e-4a84cff3a519&ui=en-us&rs=en-us&ad=us
and click on
"Refresh a SQL Server data connection" in that link.
You now know how to make a copy of the sheet. To hide it, right click on the sheet tab and then select "Hide" from the menu that appears.
Cheerio,
vcoolio.
Yes, your second post is considerably different from your first.
Excel is a very powerful object and has many inbuilt functions which will do all that you ask.
In regards the external query, read the following link which will guide you in the right direction:-
https://support.microsoft.com/en-us/office/refresh-an-external-data-connection-in-excel-1524175f-777a-48fc-8fc7-c8514b984440?redirectsourcepath=%252fen-us%252farticle%252frefresh-an-external-data-connection-036367ac-d139-49e1-b64e-4a84cff3a519&ui=en-us&rs=en-us&ad=us
and click on
"Refresh a SQL Server data connection" in that link.
You now know how to make a copy of the sheet. To hide it, right click on the sheet tab and then select "Hide" from the menu that appears.
Cheerio,
vcoolio.
Apr 8, 2016 at 07:29 AM
thanks again!