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

    Excel: Calculating a Win Streak

    Hi guys! I have been handed a piece of work that has me stumped. Essentially, there us a summary sheet for Sales that has various data on there like average weekly sales (per quarter, year) max sales and other items. Item ............... Mathew ... Dean ... David ... Ave QTR Ave YR Max WK...
  2. MooSki

    Excel: Convert Summary table to raw data

    Superb, Skip, spot on! And thanks to Higgins for assuming I was on Excel 2007, which I was, but like a doofus forgot to mention. :D
  3. MooSki

    Excel: Convert Summary table to raw data

    Hi guys, I have been given a spreadsheet which is a summary table of sales over a couple of years. On the left are three columns (Year, Quarter, Week) then the salesperson list starts, of which there are over 50, with the scope of having further people added and existing people not working here...
  4. MooSki

    Sorting and Grouping question

    Hi guys, I hope you can answer this one that has been bugging me all day. (I'm in the UK, hence the strange timestamp.) I have a main report that has a drill though on a "Request Number". This request is actually a questionnaire that has a series of 45 questions, split into 7 specific...
  5. MooSki

    How to implement an Outer Join into a Crosstab

    Hi guys, I have been asked to produce a kind of work schedule within ReportNet. Along the top of the report is to be the Week Numbers and down the left is to be the Employees. The report has an initial filter on the prompt page to decide which Building the report is looking at. As you can...
  6. MooSki

    Code required to save current summary sheet

    Hi firefytr, It's an in-cell dro pdown based on a column on the afore-mentioned data sheet. There would be a specific location to save the files to, but I'm not sure what it is at the moment, let's say "C:\Saved Files\" for now. We wouldn't be bothered about over-writing files, these...
  7. MooSki

    Code required to save current summary sheet

    Hi all, First of all, I hope this is in the correct forum and that you can assist with a semi-urgent query. I have been given an MS Excel 2003 spreadsheet from a customer which has two sheets to it, one is the raw data (taken from their database) the second is a summary sheet showing financial...
  8. MooSki

    Dynamic Scales on Graph

    Skip, Excellent stuff there, that's a great help.
  9. MooSki

    Dynamic Scales on Graph

    Skip, Thanks for the swift response, I shall do that. Mooski.
  10. MooSki

    Dynamic Scales on Graph

    Hi guys, Please bear with me, there is some background to this problem. :D I produce reports for approx 30 sales people. The main one is a waterfall graph to show how their sales portfolio is doing financially. For those that haven't come across them before, I have linked to them before in a...
  11. MooSki

    How do I prompt for begin and end date in ReportNet?

    You could also have a Date prompt that allows a Range, so then you don't need two value boxes. What you would have to remember though, is that when you are using a prompt page, this is automatically included in your filters for the main report and even for the ranges, defaults to a "=" in the...
  12. MooSki

    Excel - Waterfall graph

    Fred, Yeah I saw that thread myself, but it wasn't too useful. I've looked on the Microsft forums and found a really useful link to a different website that showed how to do it. Essentially you have to use a stacked bar chart and hide parts of the stacks that are used to calculate the starting...
  13. MooSki

    Excel - Waterfall graph

    Hi guys, I've been asked to try and do a waterfall graph using a range of data and it's proving to be a pain to figure out how to do it. A waterfall graph uses a series of data in a bar chart type format where the bottom of the second bar starts at the finishing point of the first. For example...
  14. MooSki

    Disabling Netscape

    Hi all, hopefully this is the right forum for this question. I work with a small team of telephone agents (approx 20) in a call centre and I am one of their local managers. Our IT section have given the agents limited access to the Internet via IE6 and have also given me two files to unlock...
  15. MooSki

    Can't read own Excel reports

    I think it must be that, Lex. Thanks for your reply. Incidentally, I ran the above report from Impromptu and saved as "Excel with Format" instead of just "Excel" and I can get into it. How do you impliment this instead of the code below? objimprep.exportexcel(strrepname)...
  16. MooSki

    Can't read own Excel reports

    Hi guys Cognos: v 7 O/S : Windows 2000 Excel: 2000 I'm missing something really obvious here and it's doing my head in! I used to use Cognos v6 and had a few scheduled daily reports that exported into Excel 97 and they worked a treat. Then after the company decided to get me a new PC with...
  17. MooSki

    No import file extention options

    Hi guys, I've just been given a new PC at work and have Access 97 installed on it. When trying to import or export files from the mdb, there aren't any options for any other file types other than MS Access. I had this problem before with my old PC and there was a command line that I used from...
  18. MooSki

    Scheduler and Recurring Tasks

    Dave, I have implemented this code into a macro using the "macro help" files as you suggested. I'd agree, they're quite helpful which makes a pleasant change! I've tested it too and it works perfectly. Thanks very much for your help and advice. I owe yo a pint! MooSki.
  19. MooSki

    Scheduler and Recurring Tasks

    Dave, Excellent stuff! Very much appreciated and I'll look at the sample macros and hopefully they will point me in the way I want to go. I'll probably be implementing this next week, so I'll give some feedback of what I'll be doing. Many thanks, Lawrence.
  20. MooSki

    Renaming files daily

    Thanks Bandit. I'll try this out and get back to you. Mooski

Part and Inventory Search

Back
Top