Hi ollyolly, That means the value in Cell A1 on Sheet1 is the arrival time, This time should be inserted into cell C1 on Sheet2 as you hit the enter Key on Sheet1 after typing entrants number in Cell A2 on Sheet1. Right ?
Regards Prince On Monday, December 17, 2012 3:04:33 PM UTC+5:30, ollyolly wrote: > > Swapnil & Prince, >> > Thanks for your swift replies, I'll try and respond to you both in one > post. > The spreadsheet I am trying to write is to record the arrival time of > event entrants at certain locations. > Sheet 1 cell A1 contains the time function =now(). > Sheet 1 cell A2 is where the entrants number is typed in and recorded by > hitting the enter key. > Sheet 2 cells A1 to A500 lists the numbers 1 to 500. > Sheet 2 cells B1 to B500 lists the entrants name. > Sheet 2 cells C1 to C500 is where I'm looking to locate the cursor to > insert the arrival time. > > For example: > Entrant 5 arrives at 11:50. 5 is entered into sheet 1 cell A2 and enter > is hit. > I then invoke the macro most probably by a keystroke CTRL+something. > The macro would contain the following - > The time in cell A1 is copied to the clipboard. > Sheet 2 becomes displayed, the cursor moves to cell C5. > 11:50 is pasted into C5 using the paste special value command. > > If entrant 350 arrived then the macro would go to sheet 2 cell C350 etc. > > I hope this helps. > > > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
