Hi I just want to know if it is possible to have macro for my excel file. Please see attached "Data.xlsx" for my excel data sample. And please see attached image "Output.jpg". The value in Column D of Sheet2 will be the basis for how many rows will be inserted on the last Name of the same items on Sheet1 and copy values from Column B and C of Sheet2 for the corresponding Code. Thanks you in advance if someone can give me advice on this.
Output.jpg
Hey!! Try this.
But I gotta be honest. I am not convinced with my own code because i think its error prone.
It will not work correctly If the count of that Particular item in sheet 1, does not match with Number of Area Under the Code in Sheet2.
You could use some help from the gurus.
However you can still give it a try.
Thank You,
Deep
Last edited by NeedForExcel; 05-11-2013 at 03:14 AM.
Cheers!
Deep Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks