ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I copy data into Excel and maintain the formatting? (https://www.excelbanter.com/excel-discussion-misc-queries/147886-how-do-i-copy-data-into-excel-maintain-formatting.html)

tshirttom

How do I copy data into Excel and maintain the formatting?
 
I continuously copy data from the internet into an Excel 2007 spreadsheet.
How can I get the copied data to have the same formating as the spreedsheet
without continuosly having to click the smart tag and pick the "match
destination formatting"? I am seeking a way (via template or other means) of
doing this operation automatically without having to us the smart tag each
time. Thanks for your suggestions.


Peo Sjoblom

How do I copy data into Excel and maintain the formatting?
 
What kind of data, you can import tables/lists via web queries?

--
Regards,

Peo Sjoblom


"tshirttom" wrote in message
...
I continuously copy data from the internet into an Excel 2007 spreadsheet.
How can I get the copied data to have the same formating as the
spreedsheet
without continuosly having to click the smart tag and pick the "match
destination formatting"? I am seeking a way (via template or other means)
of
doing this operation automatically without having to us the smart tag each
time. Thanks for your suggestions.





All times are GMT +1. The time now is 08:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com