Results 1 to 7 of 7

No clue where to start - need to move cursor relative to a found cell.

Threaded View

  1. #1
    Registered User
    Join Date
    05-02-2013
    Location
    Tampabay, FL
    MS-Off Ver
    Excel 2003
    Posts
    3

    No clue where to start - need to move cursor relative to a found cell.

    I have a spreadsheet that I use for entering received inventory from packing lists. I search (CTRL+F) enter the item number from the packing list and Excel finds it. The item number is always in column 1. Then I have to cursor over 4 cells to the received column and enter the number received, so that price labels may be printed. Does not seem too hard to do, but when entering a few hundred items, that's a LOT of keystrokes. I'm trying to write a macro that would callup the find function, allow me to enter the item number, find it, move the cursor right 4 cells and put the number 1 in the cell, and remain there in case there are more than one received, which is not often the case.
    I tried using the macro recorder to get an idea of the code, but everything was an absolute value and frankly, not valuable to me. Eventually I would like to add other functionality to it, like checking the number on hand against received and so forth, but really need an idea on how to get started.
    Last edited by ExNavy91; 05-02-2013 at 04:52 PM. Reason: correct spelling

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1