Recent content by taylo40

Hi, Thanks for the comment. This .xls is from a 3rd party supplier that shows all of the projects they are doing. The .xls is used for multiple different reasons so do not want to change the format. The reason I am not interested in the actuals is because my Finance department will also use...

Hello, I am new to PowerQuery in Excel and have the following question I receive a spreadsheet every month and it contains around 40 columns of data Within these columns, there are 12 which represent the months of the year within the header, it will specify whether the value is a forecast or an...

Hello, Wonder whether you can help me. Have had the same printer for a number of years "HP Photosmart C4780" - this worked fine with my old operating system. Few months ago, upgraded to windows 8 The windows app will print one photo at a time ok, however, when I select more than 1 photo and...

Hello, I wonder whether you can help me. Column A has the date the entry was made on the spreadheet. Column C of the spreadsheet is titled "Status" and there are 3 possible entries L - Low M - Medium H - High I would like column D to be a calculated field that looks at both column A and C...

Hello, I wonder whether you can help me with a Microsoft Word query. Hopefully I will be able to explain clearly:- 1 - Have a microsoft word document that is 7 pages long 2 - Pages 1 to 5 are portrait 3 - selected a section break to ensure pages 6 and 7 are landscape 4 - Pages 6 and 7 are...

Hello, I wonder whether you can help me. I want to use excel to produce a stacked bar chart to show the various dates in a project life cycle. Cell A1 has the project name Cell B1 has text item of 'Project Start' Cell C1 has text item of 'Project Build' Cell D1 has text item of 'Project...

Apologies if I should have posted elsewhere. When I try to import, I select File types and Foxpro does not appear

Hello, Just have a question about access 2003 and Foxpro. I have been asked to import some tables into Access 2003 to bring up to date. However, the original tables are in DOS Foxpro. Is it possible to import these tables ? Regards, Jamie

Thanks Skip, Jamie

Hello, Have an Excel charting question. I have a Spreadsheet that looks like:- Column A = This shows the month Column B = This has the budget for Dept A' for that month Column C = This has the budget for Dept B' for that month Column D = This has the total expenditure for the month Required...

Hello, Within the custom tab, I have selected the following variables:- Owner Document Number Status For the above, I have selected the "Type" as Text and then entered a value. My question is, can I enter those values into a cell in Excel ? For example, the users of the spreadsheet will be...

Hello, In Microsoft Word, when you add items to the "Custom" tab within File Properties. The user can then get these variables to be printed in the Word Document. Does the same functionality exist in Excel ? Regards, Jamie

I have now sorted - apologies for any inconvenience

Hello, Appreciate some help with the sumproduct function. I have created a sumproduct formula and it works fine =SUMPRODUCT(((CM_Year=YEAR(CM_CurrentMonth))*('Data Sheet'!$B$5:$B$388<=CM_CurrentMonth)*('Data Sheet'!$F$5:$F$388="Actual")*('Data Sheet'!$H$5:$H$388))/1000) I am trying to reduce...

Hello again, One more question. In the formula, the year "2007" is hard coded. What would the formula look like if I wanted to refer to a cell which would hold the year. The cell could say "June 2007" Regards