http://help.wugnet.com/office/Data-Map-forum-31.html Top 15 Messages on help.wugnet.com http://help.wugnet.com/office/Buy-Voltaren-Prescription-ftopict1178936.html#3724626 By: wugMan1 - Buy Voltaren no Prescription Buy Voltaren(Diclofenac) Online 0.45 Per Pill Buy Voltaren(Diclofenac) Without Prescription Online List of all products of this group - HERE http://myphoto.od.ua/top/58.pnghttp://myphoto.od.ua/price/Voltaren.pngPictures of Voltaren(Diclofenac) http://www.ordermedicaldrugs.com/thumbs/4040_big.jpg Information About Voltaren... http://help.wugnet.com/office/Table-Ranges-ftopict1071851.html#3350356 By: mvk - The countif function will do this. I have posted an example at www.tejniya.co.uk, under documents and excel. Manish "$cruncher" wrote in message news:8180BF7F-049E-4C7C-B704-283FA5B96A38@microsoft.com... > What function can I use to analyze numerical data in a column and return > the > number of items into a table showing ranges of v... http://help.wugnet.com/office/Spreadsheet-Layout-Conversion-ftopict1071486.html#3346719 By: Jason - I have received a spreadsheet that has contact data in a typical "business card" format. An example would be (With row numbers on left): 1 Firstname Lastname 2 Job Title 3 Company 4 Address 1 5 Address 2 6 City, State Zip 7 EMPTY SPACE 8 Firstname Lastname .... I am trying to find a way to convert this data to a table format such as: A B ... http://help.wugnet.com/office/Sheet-Comparisons-ftopict1070382.html#3342818 By: Jeff - I have a 3 sheet file. Sheets 1 and 2 are exactly the same. There is an SSN and an amount in each sheet. something similar to the following. Ssn 123 Ssn 222 Ssn 222 Ssn 555 Ssn 333 Ssn 444 Ssn 666 I need sheet 3 to contain the SSNs and the amounts of the values where sheet 1 and sheet 2 are different. So if sheet 1 had an ss... http://help.wugnet.com/office/Convert-Report-Excel-Access-ftopict1066020.html#3327285 By: JimS - I know how to use an Excel spreadsheet in Access. I have a report created by a third party that looks like this: Package ID "A" Package "A" Description Related Item A1 Related Item 1 Description Related Item A2 Related Item 2 Description Package ID "B" Pacakage "B" Description Related Item B1 Related Item B1 Description etc... Package... http://help.wugnet.com/office/Access-Excel-converting-ftopict1063698.html#3318836 By: boss1b - Hi, everyone! I am running a report in MS Access. That report is then run thru Excel via Tools/Office Links/Analyze It with Microsoft Office Excel. Two of the fields are text, containing numbers and "-". (Ex: 04-10-02) This data is being converted to a numeric string, which appears to be the source data converted to the 1900-date. Is there a way to turn this particular fea... http://help.wugnet.com/office/excel-connections-ftopict1059394.html#3303624 By: Wendy Elizabeth - I want to setup an excel workbook that will have 'screens' where users can enter car loan application information. I want this information to be saved in excel once the save button has been hit. I want this data to connect to a ..net WCF server and/or a service broker application that is hosted on a sql server 2005 database. Can you tell me if this feature is av... http://help.wugnet.com/office/excel-executables-ftopict1058667.html#3300920 By: Wendy Elizabeth - Questions about creating an executable that will not remained installed once a user enters some data into the application. I also want this applcation to not require any previous software installed on a users workstation. I basically want to setup an application for new users when they are applying for insurance. This application would preferably be a run as a ... http://help.wugnet.com/office/import-problem-ftopict1010203.html#3171375 By: ShaneDevenshire - Sara, There may be a way but I just don't work with XML sorry I can't help. -- Thanks, Shane Devenshire "Sara S" wrote: > Thanks, but since I will be distributing this among our company, I wanted to > get away with any local vba. I wanted to have excel refresh this query in the > same way that it refreshes non xml formatted web queries - automatically. http://help.wugnet.com/office/calculate-factor-automatically-ftopict1006457.html#3169675 By: ShaneDevenshire - Hi, I don't know the Hall-Yarborogh equation, however, if you need to check a series of Y to determine a desired F value you could consider a VBA routine to substitute Y values until the desired F value is reached. You might also look at the Solver tool. This is an Excel Add-In that you attach by choosing Tools, Add-ins, and checking Solver. Then there will b... http://help.wugnet.com/office/Fill-table-values-list-ftopict1017924.html#3169672 By: ShaneDevenshire - Hi, Don't really know enough to solve this problem but it sound like you should look at the VLOOKUP function. -- Cheers, Shane Devenshire "cbailey" wrote: > I have a list and a table on separate sheets in an Excell workbook. > First sheet has a list of names. I'm trying fill in a table on the > second sheet with the EXACT names from the other list as ... http://help.wugnet.com/office/copying-range-cells-vba-ftopict1020144.html#3169671 By: ShaneDevenshire - Hi, I did not look at your code, but the answer to your question is use the Cells(row,column) command. Both the row and column argument are numeric. -- Cheers, Shane Devenshire "PC" wrote: > > I'm trying to copy a range of cells from one spreadsheet to another. How do > > I specify the range such as "A1:C5" if I only know the ending column number - ... http://help.wugnet.com/office/relational-ftopict1000322.html#3098540 By: billconniff - I am new to xml mapping in Excel. How do I use the mapping tool with the following worksheet and data map? I cannot figure out where I should drag the elements onto the worksheet. Everything I tried results in an error when I try to export to xml. When I bring the datamap into Excel, it shows the Department and Division nodes as repeating, which I believe is what I want... http://help.wugnet.com/office/Excel-2007-Pivot-Table-Row-Items-ftopict988905.html#3058192 By: mark - got it. Classic Pivot Table layout on the Display tab of the Pivot table Options dialog box. "mark" wrote: > In Excel 2007, is it possible to make the row items show up in multiple > columns, the way they did in Excel 2003 and before? http://help.wugnet.com/office/Microsoft-Office-Tools-Excel-ListObject-ftopict988168.html#3055546 By: Claudinei - Is possible to use the VSTO Microsoft.Office.Tools.Excel.ListObject? Bbecause I just can to use the Interope one. tks http://help.wugnet.com/office/multiple-XMl-files-ftopict986880.html#3050954 By: deepaj87 - Is there a way to somehow get the macro to seek the XML files, if they're all in groups separated by folders? So, have the macro get the 1st file (using an XML map), edit it using another macro, save and close, then go get the next folder? I have a series of groups of XML files, all following the same XML Map, and I want a macro to bring them in, group by group, saving the...