Recent content by Kevinski

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