Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert rows in linked table that are added to secondary table
I hope that someone can help me make my life easier. I currently have a
excel file that I need to update on a weekly basis. Because I have multiple charts that I run, one for each person and then a total, and because of the way the powers that be want the individual chart, I needed to do things differently than I am used to. I needed to make a worksheet with all the data that would drive my charts. Then I have a worksheet for each person and then a worksheet that has the totals. Each of the worksheet breaks things up in a couple of sections (ie pending and complete). The chart is at the top for that individual. The problem is I would like to only enter the information in once on one sheet and have it automatically update the others. I don't care if it is the individual's page that I update and have the auto update happen to the overall sheet or the other way around. The formulas that I have tried either won't add an inserted field or they require you to have extra rows. I can not do this in this workbook. I would be happy to email a sample of what I am doing if that helps. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep a column of comments "with" pivot table as pivot tables datachanges, causing rows to be added and deleted. | Excel Discussion (Misc queries) | |||
how can i get insert table and draw table icon in my tool bar? | Excel Discussion (Misc queries) | |||
Insert rows in linked table that are added to secondary table | Excel Discussion (Misc queries) | |||
How to insert rows in transposed data table? | Excel Worksheet Functions | |||
Macro to insert extra rows in a table | Excel Programming |