Add data to rows consecutively

[moonbreakker]

Hello,

I am making a sheet and stuck half way..
In attached workbook, sheet 1 is not supposed to be touched.

In sheet 2 you can see, mechanic name, work done (free or paid) and amount.

I want a code and button in sheet 2.. I will enter data in only 1 row in sheet 2 and hit button, and it should get auto inserted in sheet 1 in next empty row (ie row 94 in sheet 1.)

I will select Mechanic in sheet 2, select work type, and enter amount.. These 3 details will be filled in sheet 1 , row 94.
Date should be auto =now() automatically..

Also is there a way to check if by mistake button is pressed 2 times that its a duplicate entry? I want to avoid duplicate entry and need some warning.

This seems very complicated, as i have googled a lot and i dont know vba..But i tried using conditional format and all.. but cant figure out a way..

[moonbreakker]

Please Login or Register  to view this content.

[moonbreakker]

in attached book in sheet called "main" i need to copy b2 to e2 into sheet1 into last empty row (94)
Data duplication check is secondary.. i will use some funcion for it.

Thanks

[jaslake]

Hi moonbreakker

Assign this Code to your Button.

Please Login or Register  to view this content.

[moonbreakker]

Hello John. Thaks.

John, hmm sorry, but does not seem to work.
Can you do it in my file? I have uploaded my file

Last empty row of sheet1 should be updated.
In sheet2 row 2 should be copy pasted to last row in sheet 1...
And date =today()

Also if anything can be done to avoid duplicate entries.. (thats secondary)

Thanks.

[jaslake]

Hi moonbreakker

It won't work on the new File because the Structure is different from the original File.

Doing the Data Entry on a Worksheet I can think of no clean way to update the SR NO and Date Fields before the Button is clicked.

Because you want the SR NO and Date Fields auto-populated I'd suggest a User Form for your Data Entry.

Shall I pursue this approach?

[moonbreakker]

Worked with old sheet. I changed some parameters. Sr No not updating is OK with my. My purpose is solved. Thank you very much.