Search results for query: *

Hi Andrzejek, Many thanks for the post, will try this out.

Hi Andrzejek, Apologies, I did not make myself clear in my original post. Initially I though about finding the first row a part number appears in and then using the COUNT column value to insert that number of rows below the first instance of the part number, [copying the part number into the...

Hi Andrzejek, Yep that's what I did..... I presume that to get it to work I comment out the Debug.Print Range("A" & r).Value & " " & Range("B" & r).Value & " " & Cells(r, c) line and substitute something else? Many thanks,

Hi SkipVought, Tried your solution again and it worked like a dream. Just a little tidying up to do. Many thanks again.

Hi Andy, Inserted your code into VBA as a module; Option Explicit Sub GetData() Dim r As Integer Dim c As Integer r = 2 'Data starts in row 2 Do While Range("A" & r).Value <> "" For c = 3 To 18 'Loop thru cells C (3) to R (18) If Cells(r, c) <> "" Then...

Hi SkipVought, I had tried using pivot tables but not that particular approach and whilst it worked perfectly it basically puts me where I originally started. I still need to insert rows and copy the actual usage number etc, hence I discounted the pivot table route. Again, many thanks.

Hi SkipVought, This is the data normalisation process as the source system is precluded from extract report development or enhancement due to it's impending demise. Additionally, the knowledge gained will be useful elsewhere and help develop my meagre VBA knowledge. I have tried to attach a...

Hi Andrzejek, Apologies for the poor formatting, but yes what you posted is what I have.

Hi I have a spreadsheet of 9,000 rows by 25 columns and I need to transpose some of the data as follows, can anyone suggest a solution, other than manually transposing? In all columns row 1 is column header, all data from row 2 onwards. Column A has Part Number Column B has a Count of locations...

SkipVought, I hope this explains things. I have other columns, but once I have the gist of how the code works, I should be able to complete the rest myself. CD_No RfqNo ItemNo Customer PartNo Order_Recd TargetDueDate Cust_Dely_Date Contract_Review_Tgt Contract_Review CD_Drwg_Tgt CD_Drwg_Pr...

Hi SkipVought, Below is a very reduced version of the layout as requested. Tried to utilise TGML but apologies if not adequate. CD_No Order_Recd Cust_Dely_Date Contract_Review_Tgt Contract_Review CD_Drwg_Tgt CD_Drwg_Pr CD_Drwg_Fin Rep_Date 12345 01/02/201228/02/201206/02/2012...

Hi SkipVought, I've uploaded a sample of the Excel sheet with comments appended to cells to show the CF outcome required. Many thanks for your help.http://www.mediafire.com/?fc1inaimm0jd8mm

Hi, I have an excel spreadsheet which monitors the progress of new parts through our business. I have been tasked with setting up a traffic light system to flag up the status of each of the stages, with each row of the sheet covering one part, each column covering each stage of the process...

I'm using a "WhatDates" form with an OK button linked to the following code: Private Sub cmdPreview_Click() 'Private Sub cmdPreview_Click() 'On Error GoTo Err_Handler 'Remove the single quote from start of this line once you have it working. 'Purpose: Filter a report to a date...

OK. I've added a column into the Closed Issues query called Filter:[Closed Date], but where to I put the VBA code? Do I create a form with a radio button linked to the code? Sorry to be a bit slow

Hi, I'm using a copy of the "Issues" database template in Access 2003 and in the view reports section, after selecting a report I want to offer the user the ability to filter the report by a StartDate and EndDate. This selection is to be applied to different query based fields, depending on...

Skip, Sorry, though it was a dead duck without normalising. If you could get me started using the sheets as they are, that would be an enormous help. The lady using the workbook is spending hours calculating values across hundreds of rows, and her fear is missing a modification to a sumif or...

Skip, Quite right, the workbook isn't mine. Tried to get the owner to "normalise" but it feeds into a corporate scheme that gets normalised after the detailed breakout I've shown. They need the workbook as is. Looks like the manual formula route I initially set up as a temporary solution is...

Have an Excel 2003 workbook containing multiple sheets; “ProjectedVolumes” “ProductLines” “Supplier1” “Supplier2” “Supplier3” and so on “SummaryByLine” “ProjectedVolumes” A B C D E ProductLine Year1 Year2 Year3 Year4 Code1 X...

My Apologies, posted in forum 703: Microsoft: Access Reports as suggested. Thank you.