Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. laguna92651

    Combine Data Ranges

    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}
  2. laguna92651

    Combine Data Ranges

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

    Combine Data Ranges

    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.
  4. laguna92651

    Combine Data Ranges

    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...
  5. laguna92651

    Separate Pivot Table Filter

    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?
  6. laguna92651

    Adding records to a table with code

    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...
  7. laguna92651

    Adding records to a table with code

    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...

Part and Inventory Search

Back
Top