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!
-
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...- MPEET
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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.- MPEET
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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...- MPEET
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
