Hello everyone here,
I have a complex issue and I need your help to solve it together:
I have excel sheet has over 400,000 row extracted from a company database.
The sheet has many Ref. Start with Ho1 and the data below for each reference would like to make it as follow:
there are 2 columns F (Descr 1) & G (Descr 2) and i want to copy the (cell B6 to column F and cell D6 to Column G) beside numbers as shown in attachment and i want the same description to be draged below till the last number for Ref no
anybody can help with equation, VBA anything i will be most appreciated.
Bookmarks