ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Link inserted rows throughout the worksheet. (https://www.excelbanter.com/excel-worksheet-functions/125834-link-inserted-rows-throughout-worksheet.html)

JackieRoss

Link inserted rows throughout the worksheet.
 
I would consider myself an intermediate user...

I created a workbook with each worksheet representing a month. My partner
and I (wedding coordinators) share the workbook. The totals flow throughout
helping us keep track of each brides balance each month. What I would like to
do is link any additions made... For example...

If January has 15 brides listed then the February sheet is linked to all 15
brides. If we take on a new bride in January we add them to the worksheet.
Right now we are having to go through EACH month and add the bride. Please
tell me there is an easier way!
--
Thanks!
Jackie

Teethless mama

Link inserted rows throughout the worksheet.
 
In February sheet
A2 =IF(January!A2="","",January!A2)

Copy all the way down as far as needed
adjust to suit your needed

"JackieRoss" wrote:

I would consider myself an intermediate user...

I created a workbook with each worksheet representing a month. My partner
and I (wedding coordinators) share the workbook. The totals flow throughout
helping us keep track of each brides balance each month. What I would like to
do is link any additions made... For example...

If January has 15 brides listed then the February sheet is linked to all 15
brides. If we take on a new bride in January we add them to the worksheet.
Right now we are having to go through EACH month and add the bride. Please
tell me there is an easier way!
--
Thanks!
Jackie



All times are GMT +1. The time now is 12:35 PM.

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