![]() |
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 |
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