Link inserted rows throughout the worksheet.

G

Guest

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!
 
G

Guest

In February sheet
A2 =IF(January!A2="","",January!A2)

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top