Data Update thru UserForm

Dear Experts,

I have created a Userform. I want user to feed details in Userform daily and the same needs to copied into 'Daily Report' sheet.

I am looking for following in 'Daily Report' sheet...
1. Date Stamp/Date Fed by User in Daily Report (Column A)
2. Food Type, Items, Quantity to be updated only by using Userform (Column B, C n D)

3. In Userform,
I have textbox, which displays the recipe of Items... I have managed to display in TextBox but they are not aligned.
How do you I align by keeping constant headings? (headings as per Recipe sheet)

I have attached the file for your reference.

Regards,
Harish

Good Morning x65140,
Thanks for sharing link... this worked out for me on 2nd point of my query.

Request you to help me on the 1st and 3rd points, which am unable to do.

I am looking for following in 'Daily Report' sheet...
1. Date Stamp/Date Fed by User in Daily Report (Column A)
2. Food Type, Items, Quantity to be updated only by using Userform (Column B, C n D)

3. In Userform,
I have textbox, which displays the recipe of Items... I have managed to display in TextBox but they are not aligned.
How do you I align by keeping constant headings? (headings as per Recipe sheet)

I am reattaching the updated file.Testing.xlsm

Regards,
Harish S

Hi Harish

1) u want the reciepe sheet data to be shown in userform ?
2) next from userform u will update the data in Daily Report sheet ?

is it right ?

Need to one more clarification,
- quantity mannaully enter by user
- when ever user click on ok then current Date should paste on Report Daily Sheet in column A right

Originally Posted by harish.chinni

Yes Naveed,
You understanding is right.

In detail...
When user select Food Type & Item in UserForm... then data related to Items should display in textbox below...

Regards,
Harish S
+91 99808 07270

Ok All right i got it

just give me some time, this is lunch time here in my office once i will get back from lunch i will work on it and i will provide u today EOD.

Originally Posted by harish.chinni

Yes Naveed.

Thanks in advance.

Regards,
Harish S
+91 99808 07270

Hi Harish

find the attached file and let me know is it what your looking for

just open the attached file click on the button

hope this will work for u

Try this updated version

i have make some slight changes use this Version 2 File

now try this version 3 File and let me know

hope this will work perfectly

Hi Harish

check it out the Version 4 File and let me know