Hi, Please find attached file for solution.
In attached excel, macro is updating arrival time without copying it. And there is no key assigned to macro. When you enter value in A2 cell in Sheet1 and hit enter macro will update arrival time in Sheet2 Regards, Swapnil. On Mon, Dec 17, 2012 at 2:50 PM, Prince <prince141...@gmail.com> wrote: > Hi Ollyolly, > > can you please tell us when this function will be performed. On opening of > the workbook or on any other event. And one more thing where i will get > the cell adress of the sheet 2 to put the cursor into Sheet2. > > Regards > Prince > > On Monday, December 17, 2012 2:32:21 PM UTC+5:30, ollyolly wrote: >> >> I am looking to write a macro in excel. >> I wish to position the cursor on worksheet 2 to automatically enter some >> data. The row number of the new position is dependant on the value of a >> cell in worksheet 1. >> Can anyone tell me how to do this? >> Thank you. >> > -- > 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. > > > -- 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.
Reposition the cursor in an Excel macro_Solution.xlsm
Description: Binary data
