1
  • Put rows in numerical order

    I have data entered randomly and now I want to sort it numerically using a certain column as the numbers to sort.

    Kooka5 pointsBadges:
  • In Excel how to autofill a cell that references a list?

    I have defined a list. Now I am at the drop down on another sheet.  Instead of scrolling to the item in the list...  (a very long list), I would like to be able to start typing a few letters, and the lists shortens to just that initial input.  Much like a combo box can operate in VB.net. Any...

    Rdn5 pointsBadges:
  • Unlocking VBA project using VBA code

    Can i use vba code to unlock my x-cel vba project protected by password? I need to unprotect my project to add some code and then reprotect it.

    Yves69520 pointsBadges:
  • Message Alert Box in Excel 2003

    I have a two files, one is the consolidated time monitoring and the other file is the individual time monitoring. The individual time monitoring file has 30 sheets which is the name of each agent and in shared mode. On that file, agents are responsible to provide/indicate the things that they've...

    Eron09135 pointsBadges:
  • Edit-Find Excel 2003

    I prepared an Excel 2003 file containing about 10 spreadsheets for a company whose name appeared in the spreadsheets. The sheets contain confidential information about the company the file was sent to. I now wish to send this file to others having deleted the name of the original company for...

    RobSoros5 pointsBadges:
  • Images from web in Excel

    if i want to paste a picture in my excel page through net and i want it keep changing as it changes on the web how can i do that?

    12345678235 pointsBadges:
  • Pulling information from one spreadsheet into another spreadsheet.

    We have two spreadsheets created and spreadsheet b has referenced totals from certain columns from spreadsheet a. The problem is that the spreadsheets are maintaned by 2 different people. And throughout the day spreadsheet a gets new information added to it, how can this information be brought into...

    Jacketfan5 pointsBadges:
  • Excel date format

    I am trying to copy data from one of our systems into Excel. Everything copies into Excel except the dates. My source data date format is MMM DD, YYYY (example Jul 14, 2004). I have tried changing the Excel from general to text and also tried changing the date formats.

    Tamara5 pointsBadges:
  • Excel affecting other windows

    When one of the employees that I deal with saves or copies a document in excel, it closes all open windows on the desktop and doesn't save or copy the document. This issue is intermitant. Any ideas?

    Wolfshaker5 pointsBadges:
  • How do I sort an entire state customer list by only the zips I work with?

    how do I sort an entire state customer list by only the zips I work with

    Mayabel025 pointsBadges:
  • How to convert the currency in Indian Value in Excel 2003

    Dear Sir, I am not able to convert the value like this even by using the custom format in Excel 2003 - 100,75,75,750.50 or (100,75,75,750.50) Can you suggest a good way to do this which also takes care of low values like - 75,750.50  

    Ravichan425 pointsBadges:
  • Excel 2003 cell protection function

    How to lock selected cells when the protect sheet feature is turned on?

    Damient5 pointsBadges:
  • Cross associate between 2 excel 2003 files

    I have a data base of 3000 products each product has a unique code followed by 5 different cells of information. I need to, on a daily basis produce a spreadsheet showing which products are used in each of 400 shops. All i want to do is type the unique code in column C on the spreadsheet and have...

    Tallbloke5 pointsBadges:
  • Excel 2003 ranking with VLOOKUP

    I know there is a way to rank a list without using the "sort" feature in excel but rather formulas. I need to sort the list of 25 items below by the first column with the highest value first. What formulas do I use? Thanks for the help. Weight Management 65% 74% 67% 84% 75% Healthy Heart 46% 24%...

    Jha9005 pointsBadges:
1

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