• How would you calculate, using the spreadsheets statistical functions, the cheapest option at the fastest speed with the least downtime?

    i have 5 tables each including speed, price, download limit, average downtime and the average uptime. i was asked by my teacher to calculate all these so i get one number, to find out which is the best value for money for someone to go for. i just need to know what do i calcute to what to get my...

    Moron125 pointsBadges:
  • Word 2007 Captions – Automatically insert characters *after* numbered label?

    Hello everyone, I have many images in my document which need captioning, and I would like to be able to automate an operation which up until now I have had to do manually: insert a punctuation mark after the text that is automatically added by word (i.e. label and number) when you go to...

    Longtalker5 pointsBadges:
  • How to capture the height,width of the latest picture inserted in word using macros,VBA?

    Hi, My task involves capturing the height , width of the latest picture inserted in word using macros,VBA.

    Iamfromhyd20 pointsBadges:
  • 2003 Excel crash

    Excel 2003 crashs when opening a Excel 2000 spreadsheet with graphs. Recovery removes the graphs.

    Prthibodaux5 pointsBadges:
  • 2 criterias

    I have 2 spreadsheets. The first one contains data for the mos of July and August. The 2nd spreadsheet contains Sept data. The unique columns in both are segment number and business center number. How can I get sept numbers into the first spreadsheet

    Bella5 pointsBadges:
  • Is there a macro to transfer a row of data from top to bottom row of range ??

    I use excel 2007. I have a s/s encompassing over 350,000 rows. Data consists of a series of ranges from columns A:N and rows varying in number between 3 and 30. There are two blank lines between each range of data. Each range is (with exception) numerically ordered down column H (e.g, 1, 2, 3,...

    Colwyn25 pointsBadges:
  • Excel Error

    I have been experiancing this error with/in excel; "Compile error in Hidden module: TFworkbook When I remove a internal templet "EY TAS datebook" the error disappears. The problem is that I need to have the templet. The box that pops up is a visual basic box does anyone have a suggestion

    Rjk10 pointsBadges:
  • can anyone help with a formula for excel

    I have Excel 2007. There is one sheet with 2 columns of data. Column one has a series of numbers (e.g, 111,22,3333,etc). Column 2 has a series of terms (e.g, work,gym,home,etc). My problem is: whereas there is a series of numbers in column 1, the terms in column 2 only appear on the first row of...

    Colwyn25 pointsBadges:
  • Global.mpt updates

    How do I add a macro to my Global.mpt file? I am using MSProject 2003 Professional and was sent a .frm and .frx files to add to my Global.mpt

    Macohick5 pointsBadges:
  • 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:
  • Conditional formatting

    How do I get conditional formatting in a form to continue to work as a sub form

    Dbarrett5 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:
  • 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:
  • Word 2007 will not open a document when joined to a domain

    When I am joined to a domain word 2007 will not open the document, but if I take the computer off the domain then Word will open the document without any problems.

    Besque5 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:

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