+ Reply to Thread
Results 1 to 1 of 1

looking for a shortcut key that will work in a macro

  1. #1
    Registered User
    Join Date
    12-31-2013
    Location
    London, Canada
    MS-Off Ver
    Excel 2010
    Posts
    3

    looking for a shortcut key that will work in a macro

    Hey ya'll!

    I have created a table for tracking rental equipment and have run into a silly hiccup. In the worksheet, if you enter data in the fields with salmon colour (agent_id use drop down menu), then hit loan it will paste that entry under rental_log. If you immediately hit return (under action) it will paste the entry under the previous one but will now include return date and loan duration date as well as clear the input fields. Here is where I am running into a slight problem. If I fill in the fields with different data, and hit loan, instead of recording that entry in the next open row under the return_log heading, it copies it right over the first entry and the same when you click return (over the second). I would like for the entry, either from a loan or return, to be recorded in the next open cell under the return_log. So far, I have tried a number of shortcut keys while recording the macros but they all end giving me the same result.

    Any suggestions and/or help with this would be great!
    Attached Files Attached Files
    Last edited by michaelmcn; 01-22-2014 at 02:16 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to show Which macro didnt work in a nested macro
    By akhileshgs in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-10-2013, 03:21 AM
  2. Perform macro "on open" specific file- store macro in Personal Macro Workbook?
    By thompssc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2012, 12:38 PM
  3. lookup macro, solver macro, realtime macro
    By xelhelp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2011, 06:14 PM
  4. Cannot find macro error when running a macro from a macro in a diffrent workbook.
    By Acrobatic82 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2010, 09:22 AM
  5. [SOLVED] Macro calling another Macro: "The macro 'Personal.xls!FindChar"
    By William Benson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2005, 09:05 AM

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