3 Simple Tips to Safely Copy Data to a New Workbook in Excel - incl. Charts and Pivot Tables!

preview_player
Показать описание
.

I cover a simple method that you can use to more easily manage the data copying process that is much easier than the traditional copy-only-what-you-need method of moving data to a new worksheet or workbook.

These tips do not require VBA/Macros and they ensure that all data connections are maintained, including for Charts, Pivot Tables and more.

Resources:

#msexcel #tutorial #exceltips #freetutorial #exceltips #excel
Рекомендации по теме
Комментарии
Автор

Method 3 is legit. It's easier to delete data from a new workbook.

bradleybeauclair
Автор

Sir. Agar last row ko aik sa zayada bar type kr na ho to to kasa ho ga. Same sheet Mai. B's ka sariel number change ho. Baki data same hi rha. Plz explain me in userform mahi. Jasa aik itam ki quanutty ki 5 quity like ha to maa chahta ka wo ka us ko 5 rows Mai likha aor in ka sariel number change ho bs

zeshankhan
Автор

I need to copy a table from one workbook to another that is already in use, not a brand new workbook.

jordanfein