• Automatic date

    How can you set up a cell to activate the current time when another cell has data entered into it? Just want to track what time DATA was entered in the other cell.

    Bispo120 pointsBadges:
  • Scrolling

    In working with MS Excel 2003, there are darker scroll lines vertically & horizontally on the worksheet. When I try to scroll the page down below the line, only those cells scroll, not the whole sheet. How do I fix this?

    nccoolmom10 pointsBadges:
  • Opening Excel

    We use a shared workbook. As I understand how Excel is supposed to open, it should be at the same place where I last saved it. Instead, it opens at that location and then jumps to a weird place on another sheet. I cannot figure out why or how to make it go back to opening normally.

    tlsanders11,340 pointsBadges:
  • Convert from text to number – exporting to Excel 2003 from SQL Reporting Services 2008 R2

    Hi I was trying to export a report which is in float format. When I do that, all the numbers in excel have a green small tag beside it saying "The number in this cell is formatted as text or preceded by an apostrophe". I have to sum my report values and this can only be done after I convert each...

    DhivyaJ10 pointsBadges:
  • Microsoft Excel 2003 / Auto complete a word

    Is there a way, using Microsoft Excel 2003, to have the sheet auto complete a word after typing only the first few letters. What I would like to do is simply this: I want the user to enter the first letter of someone's last name in a cell and have the choices from an established list elsewhere in...

    SteveGambon5 pointsBadges:
  • How to set searches within Excel to default always to the top row

    I want “Find and Replace” search result Excel row to always rise to the top of the page when I make a search window inquiry. It seems to only rise to the top of the page if the "find and replace" inquiry RESULT is not already visible on the existing viewing page. If it IS on the page somewhere,...

    Encourager5 pointsBadges:
  • Create a macro for populating cells.

    I get raw data and need to clean it up. The data is a bunch of different products and the spreadsheet tracks the time it takes to process each individual product. The spreadsheet had about 100 different products. The first column is the product name, then the rest of the columns are subcategories...

    Notwellversed20 pointsBadges:
  • invoice displays 0s when blank

    I created an invoice. I have used the cells A through G. Where A is the description of items and G is the Total sale. My problem is when A is blank G displays $0.00 for total. How can I get G to be blank when A is blank? Some other cells in between display 0 as well. I am currently using Microsoft...

    Abys5 pointsBadges:
  • VBA Copy and Paste using dates

    I have a spreadsheet that I am compiling for completed work orders. The sheet I want to copy the information from is called "Completed". In column H, I have the date each work order was completed and the dates are formated mm/dd/yyyy. I would like to have a code that will copy the work orders that...

    Bbourque965 pointsBadges:
  • vlookup

    how can I convert then match two lists of numbers?   One list has thousands of 7 digit numbers.   The other list is even longer, but contains all of the numbers in the first list, looking at the first 7 digits of each.   The difference is, the numbers have an additional digit on the end.

    Jkg5 pointsBadges:
  • Automated export/import between Microsoft Outlook 2003 and Microsoft Excel 2003

    I need to keep track of my activities in a excelfile and am looking for a way in wich my appointments (in my Microsoft Outlook 2003 calendar) automaticly get imported in specifed fields of the Microsoft Excel file. This is part of a monthly report to account for my time, and how much time I spent...

    Nizw120 pointsBadges:
  • problem with zero’s after macro has run

    Ihave a pivot table that gets data from a server.In my pivot table some cells do not have values.After the macro has run then on my report template all values are pasted, and the cells that was empty is now filled with zero's.What can i do so that in the report it still shown a blank cell,not...

    RVDW5 pointsBadges:
  • How do I bring specific data from one Excel spreadsheet to another?

    We currently pull a report of data that needs to be broken into many client related files. Not each client needs all the data that is reported in this Excel spreadsheet. Is there some sort of method that we can automate this process to pull data, align in a new Excel spreadsheet with specific...

    Jtuliao5 pointsBadges:
  • Looping to create new workbooks using a set “transaction” number

    I'm playing around a bit and can't figure out why the following code does not save a total of 5 files in My Documents(default) The files should be named in a sequence of 1 - 5 (In my Excel spreadsheet (A1)=1 and (A4)=5) The code works once through, but when ".SaveAs Filename:=Start" comes back...

    McNitro255 pointsBadges:
  • Conditional formatting in Microsoft Excel 2003

    Basically I have 2 columns the first column has years in it & the second has random letters. Now, going down the 1st column it reads: 2007,2007,2007,2007,2007,2008,2008,2008,2009,2009,2009,2009 And going down the Second Column it reads: A,B,A,B,B,B,A,B,A,A,A,B Note: This is just a segment of the...

    Bmutton5 pointsBadges:
  • Replacing this ListBox code with Treeview code in VBA

    I am importing the Board file and loading the data into treeview directly(Busname as parent node and NetName as Child node with delimitor as ! and i have taken the (myArray(i), "!")(1)) as Bus name and (myArray(i), "!")(2)) as Netname. Simultaniously i am tracking the Duplicate Netnames Listedin a...

    Maheshvba5 pointsBadges:
  • Link Outlook Calendar to Excel Spreadsheet

    Hello I am new here and this is my first post. I am wondering whether is possible to link Outlook 2003 Calendar to a spreadsheet in the same way as you would link 2 spreadsheets. For instance if a new entry is created in the Calendar the spreadsheet would be updated automatically. So far the way I...

    Yosiniro5 pointsBadges:
  • Excel file problem in Lotus Notes

    When the user is trying to open an attachment ms excel 2003 file, the user is not able to open it, but the user is able to open the file after it is saved to the computer/ The user is having problem only witht he excel files.Can anyone please help me with this?

    Wind80720 pointsBadges:
  • VBA – selecting middle portion of a string

    I'm having trouble pulling the middle portion out of a dynamic string. Ex: Orginal String 1 = John Doe, Age 35 (asd) Original String 2 = Tom Thompson, Age 100 (jkl) I need the code to produce... New String 1 = 35 New String 2 = 100 I've tried to research this, but am new to VBA and a lot of what...

    McNitro255 pointsBadges:
  • Excel 2003 Help: How to delete duplicates from specific colums and criteria

    Hi I have already sent my question here: http://www.vbforums.com/showthread.php?p=3477514#post3477514 But I will ask the same again: In my Excel file I have several columns and lots of rows. I want the macro to check the column named REF (let say it's in the B column). And it will check if other...

    Groom5 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