LinkBack URL
About LinkBacks
Hi experts
i have excel workbook contain multiple sheet with clumps of data rows i want pick particular cells values
where as A4 is header =B4 Is value
where as A25 Is header = A26 Is value
where as A27 Is header = A28 is value
find the attachment
Hi experts
i have excel workbook contain multiple sheet with clumps of data rows i want pick particular cells values
where as A4 is header =B4 Is value
where as A25 Is header = A26 Is value
where as A27 Is header = A28 is value
find the attachment
Start by unmerging the range containing the text "MANUFACT COUNTRY" in each of the 3 sheets. Then try the macro below. You should avoid using merged cells at all cost because they create serious problems for macros. Do a little research into "CenterAcrossSelection". This has the same visual effect as merging horizontal cells without actually merging them.
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
HI sir sorry for late reply i getting error of this i just tried to solve but not come over of it please help on this
Please attach a copy of the file that is generating the error.
please find the attachment file where getting error
In the first 3 sheets, you have merged cells in row 25 from A:K. Unmerge those cells before trying the macro below. You should avoid using merged cells because they almost always create problems for macros.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks