• Excel Macro

    I created a macro and it is saved in personal.xls. How can I make this macro available to other users? I want to be able to give them the ability to run the macro - they do not need to modify it.

    lorit365 pointsBadges:
  • Finding Seasonality for a large number of items in Excel.

    I am trying to establish any seasonality with what is, unfortunately, a large number of items and a relatively small time sample.  I have 32,000 different items which have typically sold at a steady pace over the past three years.  I have the sales of each item by month for the previous three...

    XENOPHON222,340 pointsBadges:
  • Cell color coding

    I am using a spreadsheet designed by someone else and it has some formatting gin place that when a date is entered if it is within a certain period the cell goes green if not red and so on. I need to add some columns and apply the same formatting however for some reason I cant see the formula used...

    Mas85 pointsBadges:
  • UK date formatting in MS Excel 2007

    As I enter a date in UK format in Excel 2007 it is taken as text. The date I entered is 23/12/2009. How to get it as a date.

    kotayyam5 pointsBadges:
  • What are Excel internal limit for size and formula complexities/

    MS Excel 2003 and 2007 crash when handling oversized spreadsheets. The RAM memory is 4 gig and has plenty of memory. The machine is running Windows XP Pro. The spreadsheets have many calculations and formulas and have been set to Manual. Also have tried the 'control-end' on each sheet to no avail....

    Gaiusd5 pointsBadges:
  • Excel 2003 docs now won’t open in Excel 2007

    I created som docs using Excel 2003. New computer has Excel 2007 installed and now when I open the docs they are unreadable. Any help would be appreciated.

    Anniedun5 pointsBadges:
  • vlookup in Excel 2007 to 2003

    Is it possible to vlookup in 2007 excel file to 2003 excel file

    Suresh123455 pointsBadges:
  • Password remover for Excel 2007

    I have forgotten my password for my imp Excel sheet. How would I recover that Excel sheet now?

    Gvk5 pointsBadges:
  • Macro to breakout data into separate tabs

    I have a weekly report that holds line item detail for seven different account numbers. The data is going to vary from week to week and I need vba code that will separate the data by account number into different tabs. Any tips on how to write the code? RWC

    HNAvigator20095 pointsBadges:
  • SUM and IF formula

    Using Sum on a column of currency of 2 decimal positions. Using IF to compare that Sum total to another total. To my knowledge, all cells are defined a 2 decimal postions. Some value entries result in the Sum total having a "1" in the 10 decimal position and some value entries do not result in the...

    LASloan5 pointsBadges:
  • VB6 App with hardcoded SQL to access a Access 2007 DB

    Hi Team, I have a query that I run successfully in native SQL within Access 2007 but if I use this code within VB6 it seems as though it is not using the "From" & "To" dates. It does return values but it amounts to the complete database totals. The extra code added to the production code was...

    Witsend5 pointsBadges:
  • Zero keeps disappearing in my Excel spreadsheet column

    So I'm adding some of my personal information into an Excel 2007 workbook and I've noticed that when I put in a number count that starts with zero, it automatically disappears. Here's an example: 012345678 changes to 12345678 What do I have to do keep the zero as entered and not disappear.

    ITKE347,960 pointsBadges:
  • Recipient list

    Not all my recipients from my Excel document are in my mail merged document

    LynnMT5 pointsBadges:
  • Excel 2007 – how to add a average formula to that cell/s that ignoring 0%’s

    Okay I figured out how to ignore zero %'s for a graph. Now what I'm stuck on is how to add a average formula to that cell/s This is what I had: =IF(SUM(U171,U122,U74,U27)=0,#N/A,(SUM(U171,U122,U74,U27),(AVERAGE(U171,U122,U74,U27)) Thanks,Jared

    Jreifenstein001185 pointsBadges:
  • Excel assigning values to lists

    I have to assign dollar values to each of these job functions. All the values are $100.00 for each function except for Administrative which is 0. The functions are: Administrative, Draft, Revise, Review, Research, Conference, Telephone Conference. I have put them in a drop down menu. How do I...

    pathetic335 pointsBadges:
  • How to fit a lot of text into a cell in Excel 2007?

    Is there a way to add a large amount of text into a cell in Excel 2007? I need to add 1,941 words (10,460 characters) into a single cell in Excel. The cell is set to the maximums of 255 column width and a row height of 409.5, but I still can’t place all of the text within the cell – this with...

    ITKE347,960 pointsBadges:
  • Adding a query into a Microsoft Excel 2007 table

    I have added a query into a Microsoft Excel 2007 table. But, I'm looking to add a parameter from one of the cells into the query. Is there a way to do this?

    ITKE347,960 pointsBadges:
  • Privacy warning in Microsoft Excel 2007

    When I'm tried to save a spreadsheet in Microsoft Excel 2007, I often get this "privacy warning" message. This happens with both macro and on-macro spreadsheets. Is there any way to get rid of this message?

    ITKE347,960 pointsBadges:
  • Imbed and Link External Excel Spreadsheet into Visio

    Looking to utilize an external spreadsheet which maintains various information pertaining to our move from one data center to another. Items included are ip address, rack, U, hostname. The question is I want to utilize this spreadsheet as my source. Then within my Visio, I have tabs for each Rack....

    Aguacer08,135 pointsBadges:
  • VLOOKUP in Excel 2007

    I have 2 columns on an excel spread sheet with the following formula; VLOOKUP(D2,$A$2:$B$2090,2,FALSE) if I copy from column one cell A(2thur209) it produces the corresponding name in column B, but if I type the same name it produces #N/A. What is the problem?

    Newkid4735 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