Creating new new worksheet from from a list

  • HI, i have a list of unique names in a workbook and want to create new new worksheet according to those names. the list of unique names are in sheet1 in a column to .other other thing is that .there is data on that those names which also to transferred to that respective sheet.
    i have to do the same procedure daily so wanted to have vba coding for that which automatically create new worksheet and also transfer data on those particular sheet.
    one more thing that data which is once tranferred should not be deleted and new data be pasted below the data on respective sheet.supoose a new unique name comes it also automatically create new worksheet without deleting the other sheet.

  • Re: Creating new new worksheet from from a list


    Hi and welcome to the forum.


    I haven't had time to test this nor to add all of the things that you want but it should help get you started.


  • Re: Creating new new worksheet from from a list


    Hi Jainny


    Welcome to Ozgrid. Try the following. Notice I added headers which is important for this method.


  • Re: Creating new new worksheet from from a list


    hi.the sheet is working but there are some problem as the data is not copying in a right way.i was not knowing that header is needed so i didnt pasted but now i have made an header also.i have attached to another sample report.in sheet one i have attached the data that have to be pasted respected sheet on day 1 and on sheet to the data have to pasted on day 2.sheet b is the way i wanted it to be the outcome.

  • Re: Creating new new worksheet from from a list


    the sheet also merging two similar name in one sheet only like it is taking BAJAJ and BAJAJHIND same sheet and updating data in bAJAJ sheet.and suppose i change value of column a in sheet 1 of a to aa.it create new worksheet but doesnot change post the data..

  • Re: Creating new new worksheet from from a list


    hi,there is a problem in the above code as after running the macro, sheets are properly made but the in d sheet dcb is also showing which i dont it to be there.it shld be unique sheet and the data to be transferred should also be of d not of dcb.

  • Re: Creating new new worksheet from from a list


    hi, hey it still not working.problem is still there.in D sheet data of dcb is still coming.

  • Re: Creating new new worksheet from from a list


    hi,
    i am trying to do same thing and have deleted all the sheets and new sheet that u have attached "filtertonewsheets(1)" i ahve downloaded that and had tried but is giving the result.
    can u recheck whether the sheet that have been attached has the updated code and if yes then do try add to two new names in column a "bajaj" and "bajaj hind" in sheet1 and ran the report..

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!