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 Rhinorhino 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: gnanas
  • Content: Threads
  • Order by date
  1. gnanas

    Excel Graph

    Iam trying to add atrendline to project future maintenance cost. On one of the graphs the exponential trend field is not highlighted Is there any particular reason for it
  2. gnanas

    MSQUERY CODE

    Where can I get a list of codes such as TRUNC, DISTN to be used in MsQuery for both formatting and calculations
  3. gnanas

    Thread List

    Could someone please explains how I could brouse the thread list and refresh my knowledge. At times experts advise others to look at a particular thread. How could I access that particular thread Regards Siva
  4. gnanas

    Changing Graph Colours

    Hi,I get random colours whenever I generate graphs in Excel. Is there any way I can predetermine the colour of the graph. At times the colour is so bad for any printout Gnanas
  5. gnanas

    Range define

    Hi, I tried to use Insert>Name>Define to name a moving data range incoporating "OFFSET" function. I had no difficulties in creating the range name. However subsequently when I tried to edit the "refers" field in the range name I could not do it. The movement of arrow keys...
  6. gnanas

    date conversion to text

    I regularly import information from a maintenance database into Xcel for analysis. of teh database one column consists of date in dd/mm/yyyy hh:mm format. I then need to convert this column to yyyymm format. But I want this column to appear as text or number (e.g 200306). Even though cells...
  7. gnanas

    Pivot table sorting data

    I have a x-cel table like this work order mmyyyy expenditure 101 200201 150.00 102 200201 165.00 103 200202 185.00 for every mmyyyy we have many work orders with different expenditures. I need to find out the number of workorders in each...
  8. gnanas

    Vlookup formula help required

    I have two X-cel tables, using Vlookup formula I try to extract information from first table into the second one for comparison and totalling up . In certain cells I get #N/A because values are not available which is perfectly correct. However I am unable to sum up the column becaues of #N/A...
  9. gnanas

    Acsess error message

    I received an access file via e-mail and when I tried to open The following error message came up "Object variable or with block variable not set" The same file was found to be functioning normally at the sender's computer. I then received a zipped copy and got the same error...
  10. gnanas

    VBA Codes

    I have started usuing VBA for excel applications. I am confused about some of the terminology used in VBA. Where can I find the full list of Codes used in VBA
  11. gnanas

    WORD DOCUMENT

    I have been developing word 200 document detailing insructions for the preparation of monthly report by clerical staff. I need to embed toolbar Icons in that document. I have been getting a screen copy & paste then croping to get the required Icon which is very time consuming. Is there a easy...
  12. gnanas

    Find & Replace with formatted word

    Advanced formatting In one of the forums I came across a solution where a suggestion was made to find and replace words with formatted words by following procedure under edit toolbar. The suggestion was to bring up the find screen under edit toobar and then press "MORE" button to...

Part and Inventory Search

Back
Top