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: *

  1. wayneryeven

    Excel: Transpose row data into list

    Hi all, Hoping someone can assist.. I have a list of data: City | Person New York | David New York | Pamela LA | Colin What i want to do is group all the persons from the same city into a list against that city name: New York | David, Pamela LA | Colin In the second column i just...
  2. wayneryeven

    Which software to use?

    Hi All Bit of a straight, to the point question... I am commecning build of a new website, that needs a backend DB to hold user/transaction info etc. Users i hope to be >1000. I have lost track of current trends in development world, what is my best/preferred software to pick up knowledge on...
  3. wayneryeven

    Excel- Copy and paste data to new workbook

    Hi guys Hoping someone can help. Basically i have a workbook containing 1 worksheet called 'Sheet1'. Data is contained in columsn A: BD. In Cell A there is a Region listed, and what i need to do is split out into a new workbook the rows pertaining to each region. The region is sorted in Region...
  4. wayneryeven

    Lookup Problem

    Hi All Wondering can anyone help. I have a worksheet (Sheet1) that holds this data: Item Date Stock A 10/08 50 A 12/08 30 Sheet 2 holds Supply information: Item Date Supply A 11/08 50 What i need to do is lookup in Sheet1 to see if there is due...
  5. wayneryeven

    Complex formula

    Hey all, Been stuck on this formula for past hour! Item DemDate DemQty SupDate SupQty Supply 1 10/08/2011 62 20/08/2011 500 0 1 11/08/2011 106 20/08/2011 500 500 1 26/08/2011 106 20/08/2011 500 0 2 26/08/2011 100 20/08/2011 100 100 The SupDate indicates when a supply of...
  6. wayneryeven

    View Report OR Datasheet

    Hey guys I have a reports form that allows users to select the type of report they want (based on cascading combo's) and they can then turn other filters on/off. When complete they click CREATE- this looks up the report they have selected and presents as print preview. Now what i want is to...
  7. wayneryeven

    Excel: Complex lookup

    Hey all Lookup time... Ok. Sheet 1 has 2 columns, Machine and Qty. Machine-Qty 1-25 2-10 3-20 What we are saying here is Machine 1 can make 25 units. On sheet2 i have another table that basically has Machine in column A, Output column B, People column C. Machine-Output-People 1-50-3 1-100-4...
  8. wayneryeven

    Filker Pivot table between 2 dates

    Hey all trying to write a macro that will remove any date filters from a pivot table and then filter the Date field again between 2 variables- dStart and dEnd Pivot table is called PivotTable1. Field is called Date. Cell B2 contains the Date filter. I am not sure how to do this- i tried...
  9. wayneryeven

    Excel: Formula

    Hi All Need some help with a formula: I have 2 rows of data In row 1/2 i have each day of the week and a number below: Mon Tues Wed Thus Fri Sat Sun Mon Tues Wed Thurs Fri 3 3 3 3 3 In the next row what i want to do is simply look at the above row and...
  10. wayneryeven

    Copy entire contents of a column

    Hey all relatively simple one though i am unsure as to the best design principle to implement it. I have set my cursor on a cell in row 1. I want to copy from this cell (e.g Current Cell= G1) to the end (i.e. where the last record of data is in column G. I jsut need to know how to best select...
  11. wayneryeven

    Find value in a range

    Hey all Having some trouble with searching for a value in a range. On Worksheet 'Sheet1' cell A1 i type a value e.g. 4 On Sheet2 row 1 there are 10 columns of info. Columns C-L contain the values 1 to 10. i want a macro to pick up the value in Sheet1!A1 and find this in the range A1-L1 on...
  12. wayneryeven

    Excel worksheet Design Help

    Hey all got a conundrum in excel that im not too sure how to sort! I have a list of Jobs 1-10. I have a number of operators in a team who do these jobs. The jobs they do depends on the size of their team e.g. 3 in the team: Person 1 does jobs 1-3, Person 2 jobs 4-7, Person 3 jobs 8-10. 4 in...
  13. wayneryeven

    Excel- Lookup

    Hi All I have the followi9ng formula that essentially checks a cell to ensure it has a value that isnt empty or says "holiday" and then proceeds to do a lookup into a pivot table to retrieve a value. I am getting N/A errors now when the lookup fails so i want to wrap the formula in a ISNA or...
  14. wayneryeven

    Pivot table- prevent auto sorting

    Hey all Quick Q....i have a pivot table that already has the data sorted the way i want it. when i create a pivot table it auto sorts against the first field. How can i prevent this? Unfortuantely there is no straighforward sort ie. Ascending/Descending. The sorting is done in the query against...
  15. wayneryeven

    Access query to find a value between two fields

    Hey all i have a table that records the following data: Product A Start ID: 1 End ID: 50 What this table is recording is that we shipped 50 of Product A and their IDs were between 1 and 50. What i would like to do is to query this table and ask where was ID 40 used? It would therefore return...
  16. wayneryeven

    Excel: Formula to check if cells contain a value

    Hey guys I have this formula in a cell O14: =IF(ISBLANK(A14),"",MAX(IF(A14=A13,S13,$C$3))) Basically checks if A14 is blank then have no value else if A14=A13 use the value in S13 else use the value in C3. What i would like to do is add another check in that says if there is a value in C14...
  17. wayneryeven

    Excel- Getting Data from table into list

    Hey all Bit hard to describe but will give it my best. I have a sheet that works out how many of a product can be delivered on a certain day, and is laid out as follows: Date: 15/05/09 | 16/05/09 | 17/05/09 Prod A: 50 60 70 Prod B: 0 10 50...
  18. wayneryeven

    Excel: Cell calculation but only show if greater than 1

    Hey guys I have the following calc going on: =IF(ISBLANK(G19),"",G19-O19) You follow the logic, BUT i want to only show it if the result is a positive number ie. >0 How best to achive? Cheers guys for your effort.
  19. wayneryeven

    Excel- Insert todays date and 8am time

    Hey all On a spreadsheet i want to have a cell that has the current date + the time set to 8am. If i do current date/time it will give me: 28/04/09 17:25 What i would like is for it to show: 28/04/09 08:00 ie. the current date AND 8am as the time. i'm not sure of this can be done, then i...
  20. wayneryeven

    Shared excel workbook growing unexpectadey in size

    Hey all i have a workbook that i share ro allow other users to make changes. The other users leave the file open to view and edit as required. What i noticed was this file grows in size considerably e.g. it starts off at 192Kb but after an hour it grows in size to 5Mb and continues this...

Part and Inventory Search

Back
Top