ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Sync Worksheets in Different Workbooks (https://www.excelbanter.com/excel-worksheet-functions/142139-sync-worksheets-different-workbooks.html)

FP Novice

Sync Worksheets in Different Workbooks
 
Hello,

I created a copy of a worksheet in workbook A into workbook B. I would like
the worksheet that I copied into B to update whenever changes are made to the
original worksheet in A; i.e. sync the two worksheets that reside in
different workbooks.

Is this possible?

Thanks Todd

Dave Peterson

Sync Worksheets in Different Workbooks
 
Excel doesn't do this kind of stuff very well.

If you only had certain fields that you want brought back for known key values,
it can do that nicely--either =vlookup() or =index(match()).



FP Novice wrote:

Hello,

I created a copy of a worksheet in workbook A into workbook B. I would like
the worksheet that I copied into B to update whenever changes are made to the
original worksheet in A; i.e. sync the two worksheets that reside in
different workbooks.

Is this possible?

Thanks Todd


--

Dave Peterson


All times are GMT +1. The time now is 04:51 AM.

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