Recent content by wayneryeven

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

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

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.

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

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

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

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

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!

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

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

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

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

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

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

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