Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create Workbooks and then create Worksheets within them
use the advanced filter to extract unique values from column C, so say
column K then you can create the workbooks by reading down column K and add sheets easily by reading down column A adding the sheets to the relevent workbooks coding this is simplistic, if you need help - reply and ask "ryguy7272" wrote in message ... Seems like a tall order. Let's start with something relatively easy, and go from there. Take a look at this link: http://www.rondebruin.nl/copy5.htm The code loops through a range (or your choosing) and copies records with the same value in a column to a new sheet or workbook. Start with that and post back with your progress. HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "K" wrote: A B C €¦..col CC 22 JIM SS 33 JIM VV 34 TIM AA 45 TIM XX 77 KIM MM 88 KIM I have above data in sheet and I need macro which should do things (see below) 1 - Looking at column C values in above data, macro should create workbooks according to the numbers of one dublicate value (for above data it will be 3 workbooks) and name them "JIM" , "TIM" and "KIM". 2 - Then looking at column A values in above data macro should create 2 worksheets in workbook "JIM" and name them "CC" and "SS" as in above data in column C where the value is "JIM" in same row of column A it has the value "CC" and "SS". 3 - In cell A1 of sheets "CC" and "SS" put the value which appear in column B. (which will be 22 for worksheet "CC" and 33 for worksheet "SS") 4 - Repeat no. 2 and 3 for workbook "TIM" and "KIM". In other words macro should produce below result 1 - Workbook("JIM") with Worksheets("CC") & Worksheets("SS") and in Worksheets("CC").Range("A1").Value = 22 and Worksheets("SS").Range ("A1").value = 33 2 - Workbook("TIM") with Worksheets("VV") & Worksheets("AA") and in Worksheets("VV").Range("A1").Value = 34 and Worksheets("AA").Range ("A1").value = 45 3 - Workbook("KIM") with Worksheets("XX") & Worksheets("MM") and in Worksheets("XX").Range("A1").Value = 77 and Worksheets("MM").Range ("A1").value = 88 I'll be very greateful if any friend can help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How use info in Excel shared worksheets to create new worksheets | Excel Worksheet Functions | |||
Macro to Create Workbooks & Worksheets | Excel Programming | |||
Auto Create workbooks and worksheets per columnar data | Excel Programming | |||
Create workbooks from worksheets | Excel Discussion (Misc queries) |