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!

  • Congratulations biv343 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: *

  • Users: MPEET
  • Order by date
  1. MPEET

    auto transfer data from one worksheet to another in the same w'book

    Awesome pivot table help, works a treat, still interested in VBA code for learning purposes so I have attached sample data: COCODE INDICATOR YEAR week 1 amount week 1 count 118 ALL 2006 -17953846.47 191 263 ALL 2006 -207425.23 55 267 ALL 2006 -21518.8 17 LE263 week 1 amount...
  2. MPEET

    auto transfer data from one worksheet to another in the same w'book

    Yeah MS Query looks a possibility. Does anyone know how to automate fully with VBA? Keen to learn how to do it.
  3. MPEET

    auto transfer data from one worksheet to another in the same w'book

    Hi I get a data extract from a financial database for a couple of years at a time. The data extract is exported into one excel worksheet. Each extract has many codes. Each code is broken down by 3 sub categories and financial years. I want to copy the data in the extract and create worksheet...

Part and Inventory Search

Back
Top