excel - Create and auto-populate new sheets based on Master sheet -
my question how create new named page, set out in new layout, populated existing data. example, “new sheet” “c3” takes data “full info” “d5”, etc. having being named “a3”. i run small business 800 customers, , tbh, laid original sheet out wrong - although seemed sufficient @ time – 1 row per customer, several columns. have found code create , rename new sheet based on cell value (a3), , other code copy cell values 1 sheet another. works on pre-existing sheet, , don't know where, or how, fuse together. (i want unique customer page billing , archive purposes, unless has better solution). creating , renaming: sub createsheetsfromalist() dim mycell range, myrange range set myrange = sheets("full info").range("a3") set myrange = range(myrange, myrange.end(xldown)) each mycell in myrange sheets.add after:=sheets(sheets.count) 'creates new worksheet sheets(sheets.count).name = mycell.value ' renames new worksheet ...