Hi,
Would like to get you help below scenerio:
I have sheet that looks like this :
one.PNG
I tried the below code - but can work only one direction
wrong result:
Please Login or Register to view this content.
three.PNG
I would like to get below - if it's possible !
correct result
two.PNG
Thanks in advance.
Testing Data:
HTML Code:
This assume columns A:D for data.
Please Login or Register to view this content.
Last edited by JLGWhiz; 10-28-2020 at 11:14 PM.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Thanks ..Successfully fill A portion only..
HTML Code:
Tried but no luck .. still returns the first verbiage on the list only.
If your data is not sensitive, click the 'Go Advanced' button at bottom right of the reply box, then click Manage Attachments to upload your file. After you do the upload, you have to post reply for the link to appear in the thread. If the data is sensitive, then make a copy of the sheet as a separate file and alter the sensitive data to protect it then upload that file. We can work better with actual files than with mock data that does not show the actual grid, formulas or other parameters.
P.S. Using the data you posted, the code worked for me, but I have no merged cells and assumed that the letter in column A would always be 1 row below the Status cell.
Last edited by JLGWhiz; 10-28-2020 at 11:16 PM.
No - The latter A can be anywhere (cell) before next [status] cell downward
I have attached a sample workbook ( Moved column A to column D ).
Thanks again
Last edited by Kevin_M; 10-29-2020 at 06:20 AM.
Okay, I will take one more shot at it.
Remove any superfluous text from rows under your actual data so the code will find the proper cells.Please Login or Register to view this content.
Last edited by JLGWhiz; 10-29-2020 at 10:27 AM.
Thanks. If you move A to cell d2 then it will return only B & C
[i.e Status (A2)- Value1 -Value2- A (D2)]
Other than that - works great.
Thanks again
Thanks, JLG - I fixed that ..no worries.
REALLY APPRECIATED - GREAT HELP!
Thank you so much!
You're welcome,Originally Posted by Kevin_M
regards, JLG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks