Hudson
11-19-2016, 07:12 AM
Hi all,
Can some one advice . how to create a VB code that dynamically create cope of work book with values ( formulas needs to brake up ) . for example : i prepared a macro template which has 7 sheets with different names . however one of the sheets named " Summary " has formulas where its data source is from remaining sheets . now i want a VBA code to be create . that dynamically create another work book and copy past sheets (" summary"," Invoices","Credits") only . and to be saved by the today report with date . can that be happend ?. am i expecting too much ?.
any inputs are appreciated.
Can some one advice . how to create a VB code that dynamically create cope of work book with values ( formulas needs to brake up ) . for example : i prepared a macro template which has 7 sheets with different names . however one of the sheets named " Summary " has formulas where its data source is from remaining sheets . now i want a VBA code to be create . that dynamically create another work book and copy past sheets (" summary"," Invoices","Credits") only . and to be saved by the today report with date . can that be happend ?. am i expecting too much ?.
any inputs are appreciated.