Search results for query: *

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

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

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

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, Would appreciate some help with the sumif function. In column A, I have a list of months:- Jan-07 Feb-07 etc In column B, I have the expenditure associated with that month What I would like to do is in another cell enter a year "2007" and the formula would then add up all of the...

Hello, I wonder whether you can help me. I have a DEll Dimension 2350 desktop and have purchased one game called "Call of Duty 2" After installing I tried to run the game and got the following error :- File Handles: ---------------------- 81662 files in iwd files execing default.cfg couldn't...

Hello, I wonder whether anybody can help me with a sumproduct query ? I have created a formula in Excel which returns the answer that I require:- =SUMPRODUCT(('Meridian Costs'!$L$2:$L$219=Summary!$B12)*('Meridian Costs'!$O$2:$O$219=Summary!C$10)*('Meridian Costs'!$Q$2:$Q$219)) The Sheet...

Hello, I wonder whether anybody can help me ? I have created a form in access that will be used by several users as an input sheet to record data from potential customers. I have created a field called "Input By" and would like the user to enter their name. I have made the field mandatory...

hello, I am in the process of trying to learn VBA and would appreciate some held regarding the user forms in Excel. I have created a user form and then added a 'tab strip'. Excel then shows two tabs on the user form. Is it possible to show more tabs on the form ? Cheers Jamie

Hello, Can anybody help me please ? I am in the process of evaluating the projects that the business would like to fo in the next financial year. Each project has been given two scores, one for impact on the business and the other for feasibility. Idealy, the business would do the high...

Hello, I wonder whether anybody can help. I have a excel spreadsheet that contains:- Column A = Persons email address Column B = Bonus this month Column C = Bonus YTD I also have a pro forma excel spreadsheet that states about the bonus scheme. I would like to create a macro that Excel...

Hello, I have a query and I think that sumproduct is the answer but I can't quite resolve the query. I have an Excel Spreadsheet that is used for time recording. Column A = Week Number - eg 17, 18 etc Column B = Employee Name. Column C - Number of Hours for the day. I have created a summary...

Hello, Can anybody help please ? I have entered the following formula in to Excel:- ="This will be a saving of " & 12875 * (E25/150) and excel is displaying the following:- This will be a saving of 9309.34027777778 Is it possible to format the formula so that it only displays to 2 decimal...

Can anyone help ? The company I am working for is interested in printing the users name when the Excel spreadsheet is printed. The users name will appear in the footer of the spreadsheet. The name should be mandatory. The reason for the question is that if there is a solution for the...

Hi, Could anybody help me please ? I have a very large text file which contains the audit log. I have imported this into word and would like to count the number of occurrances of a string. The problem I have is that the string contains 2 carrage returns. ActionCode="C" Company="20"...