5 Tricks to Quickly Copy Excel Data to Other Workbooks

Подписаться 255 тыс.

Просмотров 100 тыс.

50% 1

VBA/Macros Course (60% Discount): www.teachexcel...
5 different methods to copy data between workbooks as well as all the easy-to-miss things that you need to be on the lookout for when you copy data between Excel files.
This tutorial fills the gap between basic copy/paste and full-blown Data Import or Power Query. Here, we won't be doing anything on the Data tab at all and no Queries or Connections to other workbooks will be made aside from simple formula links in a few of the examples.
Microsoft Docs for Moving/Copying Data: support.micros...
Excel File: www.teachexcel...
Excel Forum: www.teachexcel...
TeachExcel.com

Опубликовано:

5 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 20

@ilonvitti 5 месяцев назад

Thank you! Your voice commands attention!! Excellent speaking/teaching voice!

@coopthescoop100 5 лет назад

You are excellent, not just in explaining but such a clear concise voice

@sagiratha9652 2 года назад

How do you bring notes from a cell on a one work book to another based on a dependency such as an account number or customer name. Example: John smith on one workbook has comments “ordered 2 apples” . On a new work book for the row with John smith, the ordered 2 apples needs to be placed in comments field. Please help!

@foodmoods09 2 года назад

How to copy one workbook to another "with formula" ?

@jayeshsavaliya4443 Год назад

Thank u sir i got what i wanted

@mineesimpson2296 4 года назад

great presentation

@rajagopal9896 4 года назад

How to data copy or transfer automatically different cell in different excel sheet between different excel files

@miteshrathod4286 2 года назад

Did you get the answer? Or solutions?

@toddandjenny0203 11 месяцев назад

does the the other workbook need to be open to allow the link to update?

@mathematicsdepartmentmusta7565 4 года назад

thnx man u r good

@Riffeeee 3 года назад

What about copying a whole sheet from one excel-file to another and this makes the "another" excel-file slow? What can one do then? :S

@TeachExcel 3 года назад

There are many reasons why this will happen but it depends on the data that you are copying. I imagine that the new copy is still linking to the previous workbook. To know for sure, you'd need to upload a sample file and explain the steps you are going through. You can do both of these things on our forum: www.teachexcel.com/talk/microsoft-office?src=yt_comment

@alializadeh8195 2 года назад

مرسی

@aurimasvalciukas6505 5 лет назад

Hello, is is possible that at a specific date it will stop updating from other workbook? For example IF today() is the day 2019-09-09 linked number stop updating and it will be constant number.