ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Autofill in Various Tabs (https://www.excelbanter.com/excel-worksheet-functions/171990-autofill-various-tabs.html)

ann

Autofill in Various Tabs
 
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 in Various Tabs
 
Again. ONE group. PLEASE. Otherwise you waste a lot of time for all

--
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 11:13 AM.

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