Place / Pull Html Table Into Worksheet
I need to copy/cut and paste an Html table from a website into and Excel sheet without the data being transposed. See link for the table I need to get into Excel:
http://www.voedingswaardetabel.nl/voedingswaarde/?vw=vv
Then cut and paste it to Excel, you see the data is now vertical. I need the table horizontal as it appears on the website.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Lookup: Pull Any Color Choices Associated With A Year From The Data Table On The First Worksheet
I have a data table that contains begin dates, end dates, and colors. The data is input starting with the earliest begin date. On a second worksheet, I have a listing of the years starting with the year of the first begin date and ending with the end of this year. I need to be able to pull any color choices associated with a year from the data table on the first worksheet. Some years may not be specifically listed in the data sheet as the person could have had the same color choice for several years. Sometimes a person could have more than one color choice in a year. I am at a loss for how to get to the data I need. I created an example spreadsheet to demonstrate the data I am working with, and an example of what I need my results to look like in the end.
View Replies!
View Related
Pull URL From HTML In Text File
I have some code that loops through a bunch of text files, finding any that contain an href, and printing that entire line (if found) into excel. These text files are source code for a website. What I need to do, is within this line being pasted, is grab only a few things from within some tags such as the info between <title>This is the title</title> the tags and print it into a colum, I do not want the entire line, just certain things that are in the line. I have supplied the code that I currently have. I have it so that 'WholeLine' contains the entire line. Can I manipulate that with something like Cells (myR, 3).Value = WholeFile(?). Sub CheckTextFilesForHREFs() MsgBox "Press OK to begin report" Dim WholeLine As String Dim myPath As String Dim workfile As String Dim myR As Long
View Replies!
View Related
Fill In The 3 Criteria Fields, Calculate The Result, Copy The Result, And Place It Into The Correct Place On The Table
I have a macro that imputs data from an external database and puts it into a temporary worksheet. This data has 3 columns (ID, Date, Amount). I am then making another sheet which has X number of tables (one for each ID), with the years being the column headings, and months being the row headings. ie. | ID X | +------+------+------+---> | | 1999 | 2000 | 2001 | +------+------+------+------+---> | Jan | $100 | $250 | $300 | +------+------+------+------+---> | Feb | $200 | $300 | $200 | +------+------+------+------+---> | Mar | $300 | $250 | $100 | +------+------+------+------+---> | Sum | $600 | $800 | $600 | | +------+------+------+---> | ID Y | +------+------+------+---> | | 1999 | 2000 | 2001 | +------+------+------+------+---> | Jan | $100 | $250 | $300 | +------+------+------+------+---> | Feb | $200 | $300 | $200 | +------+------+------+------+---> | Mar | $300 | $250 | $100 | +------+------+------+------+---> | Sum | $600 | $800 | $600 | | +------+------+------+---> Currently I have a few hidden fields for the DSUM Criteria. I start making the tables. And then filling in table based off of the month and year. Doing so I need 3 criteria: >= First Day of the Month <= Last Day of the Month = ID # The problem is it takes Excel too long to fill in the 3 criteria fields, calculate the result, copy the result, and place it into the correct place on the table. Is there another way to get this data into the correct tables faster? Instead of using DSUM?
View Replies!
View Related
Parse HTML Code, Create A Table
I have a function that locates a table on a webpage and pulls the html code into one cell in a worksheet. Basically we can call this one cell a text file. I need to parse through this text file (cell A1) to create a table. This text file only has info for 1 table, the table always has 12 columns, the rows are variable. I would like it to then write back this parsed text file back into excel as a table, say starting in cell A2 on the same worksheet.
View Replies!
View Related
Create Html Table From Range Of Cells
I am trying to output tables from excel to an HTML file using the following subroutine. It creates the table as I would like, but I am having a brain cramp trying to figure out how to get the cell data into the routine. The part in error is in the code below, in Red. I need some way of entering something like " Sheet(SheetNum)&.Range(Column&Row)&.Value" Private Sub CreateTable(Center As Boolean, Border As Integer, Width As Integer, SheetNum As Integer, StartRow As Integer, EndRow As Integer, StartColumn As Integer, EndColumn As Integer) Dim Row As Integer Dim Column As Integer Dim ColumnID(1 To 15) As String Dim CellLoc ColumnID(1) = "A" ColumnID(2) = "B" ColumnID(3) = "C" ColumnID(4) = "D" ColumnID(5) = "E" ColumnID(6) = "F" ColumnID(7) = "G"..................
View Replies!
View Related
Import Java Script Table From HTML File
I have an htm file, and i see the table. But when I go to import, it only brings in a few words -- none of the tables that I clearly see. I noticed that the tables appear to be created using Java. How do I import the table. If I select and copy/paste it works -- but I have 100s of these and I would prefer to figure it out and then program it.
View Replies!
View Related
Formula To Lookup Data In A Vertical Format And Place In A Table
I have a RAW DATA work sheet that has data of electricity consumption for a given week but it is in a vrtical table. I have many other work work sheets in the workbook that I require to look at the RAW data and the return the correct information in the specified cells I need the store number that is in cell F1 of each sheet and the Date on each sheet that are on Row4 of each sheet to Look up and match the information in ROW1 for the store number and columnA for the dates. then in columnB of RAW DATA I have time intervals of 30mins which need to match up with the time intervals on the sheets and display the readings from the RAW data on the sheets. ******** ******************** src="http://www.interq.or.jp/sun/puremis/...<CENTER><TABLE cellSpacing=0 cellPadding=0 align=center>Microsoft Excel - Energy Analysis WE15-03-09.xls___Running: 11.0 : OS = (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutA2A3A4A5A6A7A8=ABCDEFGHIJKLMNO1Reading DateReading Time8912116617118519682296710191119125612571292209/03/200900:0012.5926.74929.69668.728.6487.526.5616.2312.6416.3818.08317.02719.569309/03/200900:3011.8467.211.49610.1245.8726.821.817.9811.3216.711.96214.65619.243409/03/200901:0010.7368.11211.19811.286.27.415.2330.3412.0416.269.5527.26429.02509/03/200901:3010.78767.612810.68510.40725.6966.814.888.936.8416.618.53448.72645.4432609/03/200902:0011.0727.235213.01310.3235.9288.814.757.875.9218.059.38247.09445.3136709/03/200902:3011.2996.819210.26210.1765.70410.414.758.135.0916.489.0566.88325.1984809/03/200903:0011.8116.18248.952411.3695.88.314.697.774.9916.87.20964.71046.2496RAW DATA [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
View Replies!
View Related
Pull Out Specific Data From Table
I don't know where to begin or if this is even possible. I have report that I need to format. See example file. Note: real file has 2000 rows. The book date and book amount in the orginal is the POS date and POS amount in the format sheet. I don't need the "over/short" data from the original. Col. A contains store #'s and they are 2,3,or 4 numbers long preceeded by an "S-". In the formatted sheet I need the "S-" removed. The data is grouped by column C. 3 of the same equals 1. Groups vary.
View Replies!
View Related
Using If, Extract Data From One Worksheet And Place In Another
I am trying to create a basic order history in excel from orders generated on our limited ERP system. I have exported the data required and imported to excel, but due to the export limitations, I can only export certain fields at a time. This means that I have to create three sheets for all the data I require. The first sheet has the bulk of the data and is now nicely collumned. However, I cannot get both the customer code and full customer name on the same sheet due to the aforementioned limitations. Sheet 1 has customer code and other data, sheet 2 has customer code plus full customer name. I have created a collumn for the customer name on sheet 1 (A3) next to the customer code (A2) Basically, what I am trying to get it to do is as follows: In "A3" I need to create a formula that states that if A2 contains a certain customer code, then look in sheet 2, match the code and place the full customer name for that code. Bearing in mind that we have over 395 customer codes in use, so asking for a specific code to lookup would be as time consuming as entering the codes manually.
View Replies!
View Related
Place Month Of Date Cell On Another Worksheet
I have two workbooks, one a database that accumulates data over time, and the other a monthly report that needs to be populated based on information from the database. When moving data between the two, the following works fine (snipped a lot for ease of reading): Workbooks.Open (database) ', Password:= / Workbooks(reportbook). Sheets("Sheet1"). Range("A1").Value = month(Cells(282, 5)) As you can see, it simply puts the month from a cell in the database into the report workbook. However, if I change Range("A1") to Cells(1,1) I get a runtime error: Workbooks.Open (database) ', Password:= / Workbooks(reportbook).Sheets("Sheet1").Cells(1, 1).Value = month(Cells(282, 5)) I can generally work around this issue by changing the active workbook, but doing so is a big pain. Is there any way to use the second bit of code without popping an error message?
View Replies!
View Related
Move Chart To Specific Place On Worksheet
now I thought about recording the macro, but it's an offset and if you click the chart, then it'll mvoe somewhere else even though the charts are always placed in the middle when generated. So I think I need to place it in a specific range. I want to use XY coordinates or range labels or something to that effect but would like something to this affect: With Charts.Add .ChartWizard source:=Worksheets("sheet1").Range("a1:a20"), _ gallery:=xlLine, title:="February Data" End With I got that in VBA help, but I'm not using Chart wizard, my code just creates the chart from the data on its own with specific chart type. So anyway, how would I make it put each of my five charts for the 25 people in the same place for every person. Performance Errors etc etc etc all will go in the right place everytime, regardless if you start with the page scrolled. I should do range right, but how do I change this macro to do it without chart wizard...just a chart that's already created and named. QUESTION: How do I place charts that are created from a data source onto a specific area of one worksheet, and those charts are always in the same place regardless of the person'a name.
View Replies!
View Related
Pull Found Records From Table Based On Single Column
I have the following data :- SHEET 1 COL A_______COL B________COL C V1990_______J100_________U1212 H2323_______Y999 U2222 SHEET 2 COL A_______COL B________COL C U2222 I0000_______U8900________T67888 H2323 I need to search data from range defined A1.C3 and if any data in that range found in the sheet 2 that having the same records.
View Replies!
View Related
Macro To Copy And Place Data To Specific Place
I am after a macro to do the following, my visual basic skills are very limited (non existant):- Look at the date in cell A1 on Sheet 'Live Report' and err 'remember it' Copy a range of cells from A3 to A10 on 'Live Report' Go to sheet 'Monthly Summary' and find the date that had been remembered previously (this date will be in column A on 'Monthly Summary' which will probably be a mixture of values and formulas). After the date has been found paste special and transpose the 'values only' copied range from 'Live Report' (A3 to A10) in column B on 'Monthly Summary' next to the date that has been found in Column A.
View Replies!
View Related
Pull In Address From Another Worksheet
I have two worksheets. The first is a master listing of all stores for a certain client. They are all assigned a store number. The second sheet is a list of all invoices, I need to be able to type in the store number and it pull up the street address, city, state and zip, all in different columns.
View Replies!
View Related
Pull Data From Two Other Worksheet Per Condition.
The spreadsheet will be have 3 worksheets. The first worksheet will be the mastersheet (Form-01 in the attachment) that will be used as a summary/receipt for the person participating in the auction. The second worksheet will be a list of the people participating in the auction (Names) will all applicable contact info. The third worksheet will be the list of all the items for the auction (Auction Items) with all relevant information per item and a unique number for each item. The idea is to be able to track information during the auction on the "Auction Items" worksheet, there is a column for the bidder ID of the winning bidder. Then after the auction is over and its time to settle up be able to go to the master sheet (Form-01) and enter the Bidder ID# and have the other fields auto-populate.
View Replies!
View Related
Pull Information From Worksheet To Outlook
I want to setup an excel spreadsheet that will list employees and when exams were completed on them. The exams need to be completed once a year. I want the excel spreadsheet to send out an email to their corresponding supervisors when is within one month or so of an exam needing to be completed so their exam can be scheduled accordingly. I have searched this forum and read through some of the other posts regarding exporting data from excel to outlook. This seems like what I need to do but I wanted to see if anyone has an advice on what way is better than the other? Also, if excel is setup to push the data to outlook, does the excel file need to be open? In other words if Jimmy comes within one month of his exam but no one opens the excel file will it send out the email to outlook? Is it a better option/ or possibility to have Outlook pull/check to see if the condition exists where an employee is within a month of his exam and then let the supervisor know?
View Replies!
View Related
Vlookup: Pull Data From One Worksheet To Another
I am trying to pull data from one worksheet to another. I am using Product ID numbers. The problem I am having is that not every Product ID I am searching has a partner on the second list, so I get an #N/A. In stead of #N/A I just want a "0". my vlookup looks like this: =IF(VLOOKUP(A1,Sheet2!A5:C500,3)>0,VLOOKUP(A1,Sheet2!A5:C500,3),"0"). If A1 does not find a match on Sheet2, it returns "#N/A" when I want it to return "0".
View Replies!
View Related
Pull Info From 1 Worksheet Into Another - Not A One-to-one Relationship
I have one worksheet with 238 rows and another with 163 rows. I want to pull information into the sheet with 238 rows whenever there is a match to a record in the 163 rows. I tried VLookup, but as soon as it gets to a record in the 238 that doesn't exist in the 163 it gives errrors and stops. I've looked at =offset and =offset(match) but I'm not finding anything that deals with the situation of not always being a one-to-one (or even one-to many) relationship. Ultimately I want to pull the Category & Project fields into the records matching on IDNumb in Sheet 1 but Sheet 1 has more records than Sheet2. example......
View Replies!
View Related
Pull Web Page Into Worksheet
Can you use something like that to pull "All the text" from that URL back to Excel (like in Select All, Copy, PasteSpecial) rather than using SendKeys? The existing URL listed in your Test Sub would be fine to use in the example. If so, could you please modify the Test Sub code to show the code?
View Replies!
View Related
Pull Details Of Each Person From Another Worksheet
I have worksheet 1 which calculates a member's pension which is based on his date of joining a scheme, date of leaving, salary and yearly contributions paid into the scheme. Normally I would input these details manually but now I have a large number of members to produce figs for. These members' details will be on worksheet 2 with a separate row for each member's details. I want excel to process each member one by one and enter his details in worksheet 2 on the calculation worksheet 1 and put the results in worksheet 3. Is this possible? And how???
View Replies!
View Related
If Statement To Pull Values From Another Spreadsheet / Worksheet
I have two spreadsheets, i suppose one part of the solution may be to copy spreadsheet 2 into a new worksheet in spreadsheet 1, but this is my current situation: Spreadsheet 1 has "Employee lastname" in column F, "Employee Firstname" in column G. Column A in this sheet needs updating with the data populated in column H for that employee in spreadsheet 2 - the lastname is contained in column B, firstname in column C - so i need to to a match.
View Replies!
View Related
DSUM Function To Pull In Data From Another Worksheet
I've been using the DSUM function to pull in data from another worksheet. In brief, the problem is that when I Cut & Paste the formula from C7 to C8, I want the Column reference to change but not the Row reference. If I copy across the Columns then the result is OK – e.g. The Formula will change from… #=DSUM([HBAP_SHUTDOWNS_2008.xls]NWM_SuccessfulShutdownsByDepartment!$A$4:$E$2924,"Total",'Calculations Page'!A$17:A$18)# To… #=DSUM([HBAP_SHUTDOWNS_2008.xls]NWM_SuccessfulShutdownsByDepartment!$A$4:$E$2924,"Total",'Calculations Page'!B$17:B$18)#.........................
View Replies!
View Related
Pull Data From Worksheet Based On ID Number
I have 2 worksheets (Sheet1 and Sheet2). Sheet 1 contains around 3000 records with multiple fields (columns). Column A contains the ID number. Sheet 2 contains some records with different fields except for the ID number which is common. I need a macro to retrieve information from sheet1 and copy it to sheet 2 based on the ID Number; i.e the macro needs to get the ID number from sheet2, locate it in sheet1 and copy the data from column D in sheet1 for that particular record and paste it in sheet2.
View Replies!
View Related
Add Another Worksheet & Continue Importing The Html Files Until There Are No More Files To Import
I'm using the following code to import thousands of html files into my spreadsheet. The code is working fine. Since I am importing thousands of files, when there is no more space on my worksheet, the code stops with an error message. I want to make this code add another worksheet & continue importing the html files until there are no more files to import. Sub Master_Importer() Dim I As Long Dim strFilename As String Dim strPath As String strPath = "file:///C:/Documents and Settings/c/Desktop/New Folder/" With Application.FileSearch .LookIn = "C:Documents and SettingscDesktopNew Folder" .FileType = msoFileTypeAllFiles .Execute For I = 1 To .FoundFiles.Count strFilename = Mid(.FoundFiles(I), InStrRev(.FoundFiles(I), "") + 1) With ActiveSheet.QueryTables.Add(Connection:= _ "URL;" & strPath & strFilename _ .......................
View Replies!
View Related
How Can I Pull Selected Rows Of Information From 1 Worksheet Page To Another
how to reference cells in 1 page from another and understand basic formula's, and would appreciate any input on how or if i can acheive what i'm trying to accomplish. I have a worksheet with say 100 rows of information, it is a list of materials to go into a construction job. the columns to the right of the description calculate volume/quantity etc and produce a cost for the item. what i want to do is have a summary page that only lists the items that are being used, not all 100 items are in every job and i dont want to have to print the whole list with a bunch of empty values, which will just waste paper and ink. I'd like to enter a value in a cell or setup a check box or something that i could somehow use to then list that row or a part of that row of information on a seperate sheet, for a nice concise, easy to read list of job materials. i would like to do produce 1 sheet with the cost associated with the item, and one without cost.
View Replies!
View Related
Pull Out The Data In The DATA TABLE Sheet
I've been playing around with VLOOPUP, MATCH, SUMPRODUCT... But I can't seem to get this one right.. See the attached Excel file.. I think it should be fairly explanatory.. I want to use the dates in SUMMARY sheet, to pull out the data in the DATA TABLE sheet. The numbers in Column A on the DATA TABLE sheet, is first date in each month, and the numbers represent the day of the month.. . Example: 01.01.2009 1 2 3 4 5 .. 30 01.02.2009
View Replies!
View Related
Date/Time Formula: Pick Up A Date With Time Entry On A Worksheet And Place It Into A TextBox On A UserForm
I am attempting to pick up a date with time entry on a worksheet and place it into a TextBox on a UserForm. Format on the sheet is mm/dd/yyyy h:mm AM/PM. The UserForm is placing the value as mm/dd/yyyy 12:00 AM. here is the Private Sub UserForm_Initialize() If Not Range("dDate").Value = "" Then TextBox2.Value = Range("dDate").Value TextBox2.Text = Format(DateValue(TextBox2.Text), "mm/dd/yy h:mm AM/PM") Else TextBox2.Value = "" TextBox2.SetFocus End If End Sub "dDate" is the named range where the date is sitting. The format is also set on the TextBox2 exit event. Can anyone see why only the date portion is being transfered with the default 12:00 AM for no time component of the value?
View Replies!
View Related
Fill Table From Other Worksheet
I've been trying for a while now but I can't do it so I was wondering if anyone could do it: 2) To get the "Overdue Items" page to update according to the overdue items The database has been shortened drastically to be able to be able upload
View Replies!
View Related
Summarize Worksheet Table
This data consist of a long list of staff id with exception type and points. However, I have only a certain number of staff from the long list which is applicable to my department. For example, I only need data for 4 staff from the list. This list will duplicate the staff id based on dates. Therefore, there might be several cells with exception type and points for that particulat staff . Example is for staff M41 as below: Date Staff ID Exceptiontype Points Item# Dec 1 M45 Contract 1.0 44556 Dec 1 M41 Contract 1.0 44578 Dec 2 M43 Contract 1.0 44579 Dec 3 M46 Contract 1.0 22569 Dec 4 M41 Contract 1.0 44572 Based on the above data, I need to summarize as below: Staff ID Exception Type Points Exception # M41 Contract 1.0 44578 M41 Contract 1.0 44572
View Replies!
View Related
Exporting Worksheet To Access Table
I have a script that exports an excel worksheet into an access db table and thsi is working fine. However i want to define a specific worksheet where the data is being exported from within the code but im having trouble doing, its using just a range at present.
View Replies!
View Related
Table Name Or Number For Current Worksheet
Does anyone know the VB syntax for obtaining a table name or number on an existing worksheet? I'm using Excel 2007 and have a worksheet that is one large table. I have a macro which copies the worksheet to a new sheet, converts the table to a range and then edits out the elements I don't require (my macro won't strip out information I don't require if it's still a table, which is why it's converted to a range). However, every time I copy the sheet, the table number increments by one. For example: Unitlist is the original table name. When I copy the worksheet, the table on the copied sheet becomes Unitlist1. If I delete the sheet and copy it again, the table becomes Unitlist2 etc. etc. In order to get around this, I need to be able to reference the name of the table on the copied sheet and then use that reference to convert the table to a range. I can convert the table to a range using: ActiveSheet.ListObjects("Unitlist1").Unlist However, I need an automated way to obtain the table name. I've attached a copy of my macro for further reference. Sub CopySheetDeleteData() Dim c As Range Dim i As Long With Application .Calculation = xlCalculationManual . ScreenUpdating = False Sheets("Units").Copy After:=Sheets("Units") ' rename the sheet Sheets("Units (2)").Name = "ExportUnits"......................
View Replies!
View Related
Consolidate Data Into One Worksheet/pivot Table
I have a 208-tab workbook (4 employees with 52 submitted weekly timesheets). I need to consolidate and pivot job costs based on these submitted timesheets. There are two kinds of jobs: a list of products, from which the employee chooses through a drop-down list. There are also "Tracking Job ID" codes that are numbers between 7000 and an unknown ending number, which the employee types into the sheet. In both cases, the % of work performed is multiplied by the employees hourly rate and creates a total. I need a pivot table that collects these totals from all the sheets. I tried to use a VBA template from contextures.com just with a few examples from my workbook, but I don't know how to use VBA, so I failed. The only thing I did was substitute their example sheets with a few sheets from my workbook and re-wrote that part of the array formula. see attached workbooks.
View Replies!
View Related
Edit Worksheet Data Table Via UserForm
I have a spreadsheet that summarizes variations on a project. On the "Variations" tab a userform pops up that asks the user to select from 3 options: 1. Create new variation This launches another userform that allows the user to enter the necessary information and create a variation sheet. This userform updates "VarSummary" and also creates a new sheet for each variation created. I have been able to do all of this so far. The summary sheet "Variations" tab uses the data on the "VarSummary" tab. This is the code I used to add variation Private Sub cmdadd_Click() Dim iRow As Long Dim ws As Worksheet Set ws = Worksheets("VarSummary") With ws iRow = . Cells(.Rows.Count, 2).End(xlUp).Offset(1, 0).Row 'Copy the data to the database .Cells(iRow, 1).Value = Me.txtVarRecNo.Value .Cells(iRow, 2).Value = Me.txtDate.Value .Cells(iRow, 3).Value = Me.txtChg.Value .Cells(iRow, 4).Value = Me.txtSrcRef.Value .Cells(iRow, 5).Value = Me.cbstatus.Value .Cells(iRow, 6).Value = Me.DirQty.Value .Cells(iRow, 7).Value = Me.DirVal.Value............................
View Replies!
View Related
Filter Table And Then Copy The Results Onto Another Worksheet
now i have filtered data in a table, i want to use the results by printing off a table showing just these and the appropriate rows from other tables on worksheets. these all have a specific ID which is how they are traceable to each other. like a related field in an access database. two tables/worksheets are like so: table1: Reg No | Rank | Name | Initials | Troop | etc table 2: Reg No | JCLM1 | JCLM2 | SCLM1 | SCLM2 | etc If i were to filter the second table by JCLM1 = YES then i want to create a printable list of all those but also to include the related records from table 1. is this possible?
View Replies!
View Related
Auto Sort A Table As Data Is Changed In Another Worksheet
My problem this time is in regards to auto sorting a table as data is changed in another worksheet and is auto copied within the said table. I.E. I need the Fax page (second last), the table has to auto sort based on column " C ". This is easily done using custom sort but can it be done automatically ? I want to lock the page so nobody modifies it. I attached a copy of my work so far, using Excel 2007. All the sheets are locked except " Player DATA " and " Fax ". The password is " Moose ".
View Replies!
View Related
Copy Pivot Table Data To Worksheet & Name Them As Per Their Field Name
I've tried my best to describe my dilema. I import data in an SQL query from a mainframe. This data shows a job number, site address, job number and a length. Multiple lengths on the same site appear as separate entries. I use a pivot table to calculate a total length and also formulas to determine whether a site is in an East or West area. I then need to then be able to copy the 'East' jobs to an 'East' worksheet and the 'West' jobs to the 'West' worksheet. But, I only want a site to appear once with the total length.
View Replies!
View Related
|
TRACKER
