| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Too Many Rows For Worksheet | New Users to Excel | |||
| Formula to Link to Specific List on Another Worksheet | Excel Worksheet Functions | |||
| copy rows meeting criteria to another worksheet | Excel Worksheet Functions | |||
| How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
| Display selected rows from one worksheet to another | Excel Worksheet Functions | |||
Linear Mode
