ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   source sheet to auto fill 2 other sheets (https://www.excelbanter.com/new-users-excel/198100-source-sheet-auto-fill-2-other-sheets.html)

GetSFX

source sheet to auto fill 2 other sheets
 
sheet1 witch is what i fill out (source data)i want the data to be auto filld
into the next too sheets..an to also sort the the data (by date- verry
important) from the 1st sheet. all 3 sheets r totaly difernt..same names
though..

thx for any help





Barb Reinhardt

source sheet to auto fill 2 other sheets
 
You'll probably need to do this with VBA. First you'll need to decide what
you want to do.

* Do you want to "autofill" the next two sheets COMPLETELY with information
you enter into the first sheet?
* Do you want to "autofill" the next two sheets with a particular row or
column of data when it's updated.
* If you change the value, do you want to copy that over as well?
--
HTH,
Barb Reinhardt



"GetSFX" wrote:

sheet1 witch is what i fill out (source data)i want the data to be auto filld
into the next too sheets..an to also sort the the data (by date- verry
important) from the 1st sheet. all 3 sheets r totaly difernt..same names
though..

thx for any help






All times are GMT +1. The time now is 10:18 PM.

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