Hello,
In page1 a1 row has the labels.I want labels text to be added in front of each cell of coloumn.What is needed is on the page2..adding label to column.xlsx
Hello,
In page1 a1 row has the labels.I want labels text to be added in front of each cell of coloumn.What is needed is on the page2..adding label to column.xlsx
Last edited by zeroist; 05-20-2014 at 08:58 AM.
Is this what you wanted?
In sheet 2 cell A2 copy:across & down.Formula:
Please Login or Register to view this content.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
sorry but it gave errror
Are you sure? See attached file. It seemed to work OK for me.
I am sorry I forget to say that empty cell should be passed.It works but not pass the empty cells.
OK. We'll get there...
Formula:
Please Login or Register to view this content.
Try that.
If this works, please mark the thread as CLOSED and consider adding reputation by clicking on the star at the foot of this post.
opps something wrong with underlined part![]()
Please Login or Register to view this content.
can anyone produce a macro for bulk files plz.
Again, I don't see what's wrong. see attached file.
it is now ok.thank you very much and rep..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks