ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Autofill (https://www.excelbanter.com/new-users-excel/171981-autofill.html)

ann

Autofill
 
I am a little new to formulas in excel and I need some help.

I have a large spreadsheet with about a hundred tabs. The first 30 or so
tabs are individual info. then after that the tabs are grouped into accounts.
Meaning although they are still different tabs there are groups within the
tabs. Each account has 4 tabs. The first tab in each account is what my
question is referencing.

Once the information is filled in the very first tab in the spreadsheet
(individual info tab not an account tab) I need it to automatically be filled
in the first tab of each account. Only the first tab and only in the
accounts.

How do I do this?


Don Guillett

Autofill
 
Pls post in one group. Confine discussion to your post in .misc

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ann" wrote in message
...
I am a little new to formulas in excel and I need some help.

I have a large spreadsheet with about a hundred tabs. The first 30 or so
tabs are individual info. then after that the tabs are grouped into
accounts.
Meaning although they are still different tabs there are groups within the
tabs. Each account has 4 tabs. The first tab in each account is what my
question is referencing.

Once the information is filled in the very first tab in the spreadsheet
(individual info tab not an account tab) I need it to automatically be
filled
in the first tab of each account. Only the first tab and only in the
accounts.

How do I do this?




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

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