I have a daily task of inputting data in the top row which i have just created.
I want to use a data form but I understand that the output form a user form goes to the bottom of the range.
Any help to get it into the top row would be much appreciated.
Attach a sample workbook. Give an example of your desired results. For how to attach workbooks at this forum check out the link in my signature below.
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
So what is your requirement? Do you want to create a userform that can input data in the topmost row that has been created using enter tip button?
Also, what if there are lets say 3 top rows empty? Where should the data be placed?
pls see the .xlsm file I attached.
I want to fill each row that I need to insert - normally 1 but sometimes 3 - into the row(s) which I have entered in row 3.
I currently have a macro which inputs date in A, Day in B, and copies formula from the cells below in K,L,M and N.
I then input manually the country, name of the horse, the tipster and the bet amount. I want to use a user form to control this input.
Hope this explanation assists with ur understanding of the worksheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks