Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: taylo40
  • Content: Threads
  • Order by date
  1. taylo40

    Remove columns using powerquery

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

    Trying to print from Windows 8 "This app can't send to other devices at the moment"

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

    Excel - If / Or statement

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

    Word printing Portrait

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

    Excel stacked bar showing a date of 1900

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

    Access 2003 and Foxpro

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

    Stacked Bar Chart with a line chart

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

    Displaying the Custom Tab in File Properties in Excel

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

    #NA Error with Sumproduct

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

    Sumif for values in a certain year

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

    Video card or driver doesn't support dynamic textures.

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

    query with sumproduct

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

    Record a user name in and acces form

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

    Increase the number of tab strips that appear on a VBA form

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

    Create a Boston Matrix in Excel.

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

    Send data from Excel to Microsoft Outlook.

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

    Sumproduct.

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

    Format of a Cell in Excel with Text.

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

    Display the users name when the document is printed.

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

    Counting a string with carrage returns

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

Part and Inventory Search

Back
Top