On Monday, December 17, 2012 9:02:21 AM UTC, 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
Swapnil,
Thanks for your reply.
I read your explanation twice and I think I understand what you are saying.
I've inserted a new line at the top of sheet 2. I've made the minor
modifications in the visual basic editor and all works, thank you very much.
I'm just amazed that you can write such st
On Thursday, January 10, 2013 6:33:12 PM UTC, andrew...@tiscali.co.uk
wrote:
>
> Swapnil,
>
> I have been pottering around with the spreadhseet you started for me.
> I've added a few bits in readiness for passing onto those who would be
> doing the time recording at the various checkpoints.
Swapnil,
Fantastic, just what I needed. Thank you very much.
Prince, thanks for your efforts, now sorted as you can see.
Cheers,
Ollyolly
On Monday, December 17, 2012 9:02:21 AM UTC, ollyolly wrote:
> I am looking to write a macro in excel.
> I wish to position the cursor on worksh
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:
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, olly
>
> 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
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, ollyo
