• Multiple VLOOKUP with multiple results

    There is 3 sheets 1st master sheet,2nd B-1 & 3rd B-2.In (master sheet) column A there are repeating towers name (eg:B-1,B-2,B-1,B-3), column B there are repeatation of apt. no. (eg: 101,102,101,103,104,102), column C there is a amount(eg: 15000,20000,etc.), i want to give formula in each sheet to...

    Excelaccountant20 pointsBadges:
  • How to save the exported Excel files from Oracle Forms 6

    Hi, I am using oracle forms 6.0. I generate multiple excel files from oracle forms and am using ole2 to export the data into excel. But i dont know how to save those files into the local machine. please someone help me. Thanks in advance

    Rajanoracle10 pointsBadges:
  • How to create Excel objects from ASP.NET

    hi can any clarify my doubt as described below. i have created object for excel in asp.net on executing the line of code "excel.workbooks.add()" i am getting following error, ""Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the...

    Bala1155 pointsBadges:
  • How can i transfer more than 16384 records into Excel2003

    Hi All, I am trying to transfer a table with more than 20,000 records from access2003 to Excel2003, The code i am using within VB goes like this Private Sub Allstock_excel_Click() Dim filename As String filename = "D:\Automotive_Rapore\Archives\AllstockReport\Allstock_" & Format(Now,...

    Kentster5 pointsBadges:
  • Automatically update a cell with DATE/TIME STAMP when row has been changed.

    Can and EXCEL function or macro automatically update a cell with DATE/TIME STAMP when any cell on the row has been changed?

    Modiyooch540 pointsBadges:
  • export the data from excel into a database

    Hi Is there a way to transfer the data in excel sheet into a table in any databse with the use of ODBC connection?

    Jacky160 pointsBadges:
  • One cell acting on another

    I have a complex question...so bad, in fact, that there's a screenshot that better explains what I need: http://junk.tecsbrain.org/excelquestion.gif Basically, I get a bunch of values from a listing, punch them in, and then correct any mistakes in those values. Right now, I manually move from one...

    Tecsbrain5 pointsBadges:
  • Trying to copy a value created within a subroutine to another cell in the same worksheet

    I have a string of cells that are populated by my macro. what i need to do is: each time the value populates, i need to copy just the value to another cell so i can record the results of the macro for a long string of numbers. heres what i have, this is not working for the last step - Sub Count()...

    Irish44455 pointsBadges:
  • excel formula

    i am working on a worksheet and need totals from a prior worksheet, for one cell i use =sheet2!A3, when i try to get the total from A3 and A4 i do not get the total, i have tried =sheet2!A3+A4, but that does not work, please help

    Clw5 pointsBadges:
  • Switching Excel Custom Views Based on Selection

    I have two saved Custom Views for a protected worksheet that I use as an input and summer page for an estimating spreadsheet. I want to include a validated cell on the front page which would select one of these two custom views based on which answer the user selects. Unfortunately I am very limited...

    Brgbldr5 pointsBadges:
  • Office 2007

    I have been having problems opening Excel documents. I have to use Internet Explorer to open these files. I have uninstalled office 2007 and re-installed it but it still hasnt made any difference. Any headway on this would really be helpful. Cheers.

    Yusufidris10 pointsBadges:
  • Data Label Help

    Hi I have made a stacked column graph comparing three types of presenters by percentage. I am trying to make a data label appear at the top of each three stacked bars that shows the total percentage for all three. I know I can do this by way of a text box but I would like the label to update...

    Hmarshall055 pointsBadges:
  • how to get the check boxes data in to excel sheet

    i am using lotus notes. in which i write an agent to export the excel and in that i have a option of one column in which i have check boxes and out of that any number of check boxes can be checked. but all the checked items have to in to the one cell on;y in the lotus excel sheet. how is it...

    Sravanthinandigama5 pointsBadges:
  • Excel cell contents change when performing Word mail merge.

    I routinely use Word Mail Merge Wizard to produce mailing labels, extracting the address data from an Excel spreadsheet. When performing this operation today, the zip codes of the last five additions to the spreadsheet, while appearing completely normal in the spreadsheet, change to 0 (zero) in the...

    Nclimey5 pointsBadges:
  • Lonking worksheets in Excel.

    I am trying to link an Excel sheet from one workbook to another and it is working, but it does not look the same. I want the linked sheet to look exactly like the original sheet, but it doesnt work. I think it may be because the original sheet was manually inputted and i created a range and named...

    DDP5 pointsBadges:
  • Excel graph gaps

    I would like to create an "x,y" type plot ("scatter graph" in Excel terms) in which the "x" array is continuous, but some of the "y" values are invalid because the formula has a limited valid range. I can use an IF to substitute "" or "nil" "invalid" or something for the invalid "y" values....

    TomGlass20 pointsBadges:
  • Help finding duplicate info in Excel in different columns

    Hi, I have an excel spreadsheet that looks like below: Origin Store1 Store2 Percent Source Warren 12345 45678 2.45 b Warren 45678 12345 2.45 r I want to be able to recognize and delete one of these rows as a duplicate. The info is the same just in a different column whether it be Store1 or Store2,...

    Hmstacco20 pointsBadges:
  • coordinate file import

    can I import cartesian coords into acad from wordpad or exel

    Moseseh5 pointsBadges:
  • MAXIF formula

    Excel has SUMIF and COUNTIF functions, but I don't find a comparable MAXIF funciton. Can such a function be added into Excel? Any suggestions for sources?

    TomGlass20 pointsBadges:
  • Excel Macro to Create additional Sheets, based upon cell values

    I have a spreadsheet that contains a report of which department has an item entered. what I want to accomplish is to move the individual 'department' data to thier own sheets. I have one case where I will have 4 different departments combind on one sheet, the remaining will occupy thier own sheets....

    Donatelo305 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following