Dear All
in attached sheet, i have a data(which will vary as per my need) in sheet 2 and I want that repeat cell rows value with given figure(which is in column N in sheet 2) in sheet 1 and also adjust these value in columns as per their header in sheet 1 and others data(yellow highlighted) will remain same and auto appear in their columns, and all data should convert in upper case..!!yellow highlighted are constant their will no change in any case and blanks column will remain blanks..
i share only sample data it can be large and differ...
need your kind help on this
Adeel
Bookmarks