Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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)...

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

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

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.

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.

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