Search results for query: *

Hi I have copy/ pasted some columns from a colleagues spreadsheet into one of my own. He has used some elaborate colour-coding on his sheet by adding fill in different shades. I want to get rid of that in mine and have no fill but I can't change any of the fills. My colleague can't remember...

Hello I have the following piece of code in a macro Range("C2").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],TLIST,2,FALSE)" Selection.AutoFill Destination:=Range("C2:C10") This is fine for the 10 rows of data I used for testing but how do I repeat this function where I don't know...

Thanks a lot guys - really helpful. The whole VLOOKUP concept gelled with me after reading this and I converted everything into 1 lookup list. I have now recorded a macro as below based on the test data I'm using that does everything I want and the only issue I have now is determining how many...

Hi I have created 3 named lists of values: 'RESI' 'COMM' and 'OTHER' I want to know the syntax for looking a value returned on a master sheet up in each of these 3 lists and returning the name of the list it is found in. I am familiar with VLOOKUP and LOOKUP but not sure how to nest IFs nor...

That's helped thanks

Hello I am trying to find the number of holidays between any two given days using the following code, but it is calculating the holidays incorrectly (always less than the days available in the table "Holidays"). When I am using the start date as 1/1/2006 and end date as 31/1/2006,the result...

Yes absolutely

Field is date/ time SQL SELECT Communication.[Communication Date], Communication.[No of Requests], Abbriviation.Description FROM Communication INNER JOIN Abbriviation ON Communication.[Communication Category]=Abbriviation.[Abbr ID] WHERE (((Communication.[Communication Date]) Between [Start]...

I have a simple query which returns data between 2 dates based on parameters entered at runtime: Between [Start] And [Finish] But when I try to write a report based on this query and graph the results I get error messages 'The Microsoft Jet database engine does not recognise [Start] as a...

Hi I have a simple 40 page procedural document which contains about 60 screenshots from an Access database. As I have been compiling this its performance each time I open it has slowly deteriorated from taking about a minute to open (including trying to fire up my DVD drive!) to crashing Word...

Thanks for all your help so far.

Good point - the user wants to be able to e-mail each resultant sheet to someone in that dept and doesn't want any department to view anothers data. I'm sure there's a bigger solution but at the moment all they've asked me to investigate is breaking the master sheet up.....I have pointed out...

Hello I have a variable length spreadsheet sorted by department (col B) and containing 8 columns of data. From this master sheet 'Access Classes' I want to create a worksheet based on each change in col B and copy the relevant rows from the master to that sheet. The dept names in col B are...

Hello Can Crystal reports automatically output a series of .pdf files based on report grouping? Currently I have a report which people run about 100 times inputting a different runtime parameter for 'Subject Area' each time and then outputting each of these reports to .pdf I'm proposing the...

I have a 10 column spreadsheet used to record quality improvement issues, who they're assigned to and what actions are being taken. I have one row of data for every update that is made. There are currently 18 issues with a total of 72 updates. I am interested in presenting a 1 line snapshot...

Hi I have designed a spreadsheet to track employees various leave allowances (ie annual, sick, bereavement etc). I have a sheet for each employee with a starting balance (ie the number of days leave due as at today) a work area where any days leave taken are recorded and finally a running...

Excuse me if this is a stupid question but do you really need a sub-report? Is the data you are trying to sub-report on not in the same table as the invoice date/ invoice number? Or at least in another table you can link to (say by primary key 'Invoice Number'). In which case you could keep...

Hi Is this chart being distributed electronically? How much data is there per person on the chart? If you right click on any shape you should be able to choose 'Custom Properties' for that person. If you used the import wizard to get the data from Excel into the chart there should already be...

Sorry Version = Info 7 Connecting to SQL based datawarehouse Sample data/ Result: Item 2004 2003 Pens $100 $5000 Pencils $50 $1000 etc So at the end of January 2005 the column...

Hello I am cross-tabbing and charting sales by product group for current year to date and last full year. The datetime field I am calculating from is called Sales_Order.so_processing_date. What should the formula be? Presumably once I return the data set I can crosstab and chart by year......