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

    How Can I Make a Monthly Pivot Table, with data blocks of Varying Size

    I need to create a pivot table of the average mileage that an employee has travelled, the problem is the size of the data block varies, from month to month eg.january is 25 cells with data in from column 'A' to 'L', and february is 100 cells down with data in from column 'A' to 'L'. How can i...
  2. pyromaniac

    Creating a Pivot Table

    Sorry ajcarr the macro ain't working, i need more help, but thanks for trying.
  3. pyromaniac

    Creating a Pivot Table

    Thanks very much it seems to be working O.K. What does the master version look like?
  4. pyromaniac

    Creating a Pivot Table

    I need to create a pivot table of the amount of sales, the problem is the size of the data block varies, from month to month eg.january is 25 cells down, and february is 100 cells down. How can i write a macro that selects only the required data, so as it can be put into a pivot table?
  5. pyromaniac

    Cell Referencing

    This Code might help ActiveCell.Select cc = ActiveCell.Address Range("g1", cc).Select
  6. pyromaniac

    How caa i write a macro to select a block of cells?

    I need to be able to write a macro that will select a block of cells. The problem is that the size of the block varies e.g. January has cells down to 'A21', but february has cells down to 'A50'. So i need the macro to select only the cells with data in. I tried a macro witha loop, but was unable...

Part and Inventory Search

Back
Top