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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by wayneryeven

  1. wayneryeven

    Excel: Transpose row data into list

    Hey lavaghman THanks for the reply- code looks good and i will test later. To get away yesterday i did a somewhat unconventional approach of concatenating entries if the previous city was the same, i then added a flag to each row which indicated if it was the last record, filtered this and...
  2. 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...
  3. wayneryeven

    Which software to use?

    Ok thanks- thats sort of what i had picked up thus far. mySQL i have downloaded and will familiarise myself with it. Thanks for your input, helps alot.
  4. wayneryeven

    Which software to use?

    what i used before was circa 15 years ago and the landscape then was much different to what it is today. I will attempt as much of the design and coding as possible. The hosting as not been selected, i wish to understand what is the de facto standard out there before making any financial...
  5. 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...
  6. wayneryeven

    Excel- Copy and paste data to new workbook

    For anyone coming back to this at a later date, heres my final code I used to complete the task. Few variables to change. Sub CopyToWorkbook() Dim c As Range Dim rng As Range Dim r As Long r = Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row Application.DisplayAlerts = False For Each c In...
  7. 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...
  8. wayneryeven

    Lookup Problem

    Hey Skip SOunds just the ticket! Now to find out how to do this in Excel 2007.. Data, External Source, Excel> Select the .xlsx im working in and i get "This data sournce contains no visible tables". Ill peservere. Many thanks for your anser, ill report back findings and close accordingly!
  9. 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...
  10. wayneryeven

    Complex formula

    This worked (some columsn added). I had too many arguments in my IF statement: =IF(A2=A1,IF(AND(F2>=B2,F2<B3,H1=0),G2,0),IF(F2<=B2,G2,G2)) Thanks for the input and feedback. Like many things, sometimes its easy to have the vision and gesticulate looking at the problem, but conveying this in...
  11. wayneryeven

    Complex formula

    < less than? I have got it working i think... =IF(A4=A3,IF(AND(F4>=B4,F4<B5),G4,0),IF(F4<=B4,G4,0)) I now need to get it so that if A4=A3 DOES NOT equal then Supply=SupQty. Any ideas how i could cover that in the formula?
  12. 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...
  13. 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...
  14. wayneryeven

    Excel: Complex lookup

    Your spot on. Sheet1 is what we PLAN to produce. Sheet2 is what the CAPABILITIES are (or constraints).
  15. wayneryeven

    Excel: Complex lookup

    Oops sorry should have been: What i am saying here is that Machine 1 is capable of making 50 units which requires 3 people.
See more

Part and Inventory Search

Back
Top