Linking multiple worksheets, removing blanks

  • Thread starter Thread starter denisecook
  • Start date Start date
D

denisecook

Hi, I would appreciate any help you might have.

I have a multi-sheet workbook that pulls data from several locations.
For instance, master worksheet is linked to multiple individua
worksheets to collect their records as they are entered/updated. Th
problem is, I have allotted space in the master for each worksheet t
dump its data, so I gave each about a 40 row section, but som
worksheets may only have 10 rows, or some may have 50 rows, etc. I'
ending up with blank spaces between the linked data. My goal is t
have one master file with contiguous records that I can then sort an
maintain. As the individual sheets change, the master shuold updat
itself, even if that means extra records are added.

Any ideas? I know I could easily accomplish this in Access but I a
required to use only Excel.

Thanks in advance! (I have another question also, which I will pos
next) :
 
It would be easier to enter the all data on the master sheet, and use
Data>AutoFilter to show specific records when required.

If you need the individual sheets, there's a sample file here that
creates sheets from the master:

http://www.contextures.com/excelfiles.html

Under 'Filter', look for 'Update Sheets from Master'
 
Back
Top