Search results for query: *

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.

mm bizarre. Shouldnt be doing this- i have multiple accounts all linked in Outlook with PST running. Ok couple of things off the top of my head- On Exchnange against their profile is there any delivery forwarding set up etc? In Outlook , Tools Account Settings, check the mailboxes- where is...

I sometimes see this myself with related errors such as "Unable to copy to clipboard". Though it often does copy still. Unfortuantely i think the only solution could be a reinstall of Word if thats the only program affected. Failing that as its clipboard could be Win issue. Is your system up to...

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

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

hey higgins Apologies for the delay- weekend took priority on this one! OK i had another look at this- my fault, i did try and copy but i substituted wrong cell Reference in the formula (the actual Cell Refs arent A1, B2 etc but i broke down for simplification). That did the job perfectly...