Search results for query: *

Okay thanks. Good solution here, using formulas. [url]http://www.excelforum.com/excel-general/1050451-combine-data-ranges.html[/url} Also posted here: [url]http://www.mrexcel.com/forum/excel-q...ta-ranges.html[/url} [url]http://www.ozgrid.com/forum/showthread.php?t=191947[/url}

Can you explain a little more, when you say "drag the ranges into the same column group.

The blanks actually have formulas in them which I need to keep as the data is updated over time. So if I delete the "blanks" I will lose the formulas. Any other thoughts.

I have 22 identical data ranges, 5 columns wide, that I want to combine into one range. The ranges are all on the same sheet. I could place the ranges on separate sheets if that make things easier. The data in the ranges is generated by array formulas, so at the end of the range are blank rows...

I recently downloaded a sample Excel file. It had pivot table filters on a separate worksheet from the actual pivot sheet. They said to create a pvt.select. How do you separate the filter from the pivot table, the pivot table filters above the charts?

Instead of a table name, I've change the source to a named range, with extra rolls added. I can now update the pivot table but the formulas in table don't update in the new records. I use calculations in some "helper cells" to automatically extract unique data to other worksheets. For example...

I am adding multiple records at one time to a table from a another worksheet with code. Even though the records are added to the bottom of the table they do not seem to be part of the table structure. Any formulas that are part of the table are not implemented in the new records. If I have a...