+ Reply to Thread
Results 1 to 9 of 9

Vba for move data & clear entry screen for entry new data..

  1. #1
    Forum Contributor
    Join Date
    01-29-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    418

    Vba for move data & clear entry screen for entry new data..

    Friends i m working a excel sheet & i wanna a vba for my easy working..

    I have 2 sheet in my excel work book
    1 entry
    2 items

    in entry sheet we enter data & after run vba data move to item sheet & ... Entry space clear

    my example sheet attach with this

    where we show what i want
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,152

    Re: Vba for move data & clear entry screen for entry new data..

    Do you mean that the data from Sheet1 should be copied to Item Sheet? Only data having "Yes" in the 1st column should be copied, then changed to No and then the remaining columns cleared?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Vba for move data & clear entry screen for entry new data..

    If there is already data in the items sheet, do you want it over-written, or do you want the new data transferred to the bottom of the old data??
    Gary's Student

  4. #4
    Forum Contributor
    Join Date
    01-29-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    418

    Re: Vba for move data & clear entry screen for entry new data..

    oh sorry i forgot to change sheet1 name to entry ......

    in entry sheet that is example data.. that i want to move... every time move data.. add below last blank row

  5. #5
    Forum Contributor
    Join Date
    01-29-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    418

    Re: Vba for move data & clear entry screen for entry new data..

    Quote Originally Posted by arlu1201 View Post
    Do you mean that the data from Sheet1 should be copied to Item Sheet? Only data having "Yes" in the 1st column should be copied, then changed to No and then the remaining columns cleared?
    yes i wanna same.. only yes in the 1st colunm shoud be copied.. then change to NO and then the remainging columns cleard.. but in category colum.. where i want predefiend data validation data...

  6. #6
    Forum Contributor
    Join Date
    01-29-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    418

    Re: Vba for move data & clear entry screen for entry new data..

    Dear arul1201 Sir/Mam

    i have given ans of ur query regarding create vba for my workbook... hope u understand what i want in a vba.

    looking for ur +ve responce...

    Thanks

  7. #7
    Forum Contributor
    Join Date
    01-29-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    418

    Re: Vba for move data & clear entry screen for entry new data..

    Friends my problem still un solved..

    If u ppl understand my problem then tell me is it possible through vba or not...

  8. #8
    Forum Contributor
    Join Date
    01-29-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    418

    Re: Vba for move data & clear entry screen for entry new data..

    frnds i m still waiting responce to my thred.. for vba help..

  9. #9
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,747

    Re: Vba for move data & clear entry screen for entry new data..

    Hi santosh226001

    This code is in the attached...let me know of issues.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1