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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by ccat
-
Retrieving External Data from Access in Excel
Dear Tek-Tips friends, I have an excel worksheet that is linked to an Access query. When I hit the 'Refresh Data' button in Excel, it calls on the destinated query in Access db to display the latest data. This all works fine on a machine installed with Access 2000. However, when I try the...- ccat
- Thread
- Replies: 2
- Forum: Microsoft: Office
-
Using macros to split an Excel worksheet into useful chunks??
Dear all, Dear all, This is my first time working with macros in Excel. Please help! I’m trying to build a macro that will split a worksheet with approx. 9500 rows into 28 separate worksheets based on relevant sections. My pseudo-code would be something like this: ‘Assuming that each...- ccat
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
Using EXCEL Graph to show two series in different timeframes??!!
Dear all, This is my first message posted with Tek-Tips, any help will be deeply appreciated. I'm trying to get an Excel graph to show 2 series; one referencing 24 months of data [series A](e.g. 2001 and 2002 figures) and the other referencing only 12 months of data [series B](e.g. only 2002...- ccat
- Thread
- Replies: 3
- Forum: Microsoft: Office
