Hi
I have data in excel i want pull that data in particular format. In attach file i show the data & expected result also i upload only 1 sheet data but i have for than 10 to 15 sheets data and i want dynamic range because data is more than this till 100 rows & columns are till Z.Please give me macro for this
I have data in excel i want pull that data in particular format. In attach file i show the data & expected result also i upload only 1 sheet data but i have for than 10 to 15 sheets data and i want dynamic range because data is more than this till 100 rows & columns are till Z.Please give me macro for this