need vba code export data to closed workbook sheets
Dear sir
i have one file saved in [Master] file with multiple sheets tab named by country ledger name.
i have another workbook [Misexpanse] with data range of A:K i want split A:A rows as per name of country ledger names move to master file sheet where sheet name and ledger name meet
if rows value is Alabama and sheet name is Alabama then 11 rows move to corresponding sheet with heading
find the attachment
|