Washcare
asked on
Based on the value in AF, delete some of the contents of H
Good Afternoon
I am looking to ensure that the contents of column AF, which can have mulitple values, pulled from a sharepoint site, only has the value associated with the value in column H. I like this to work through all of the rows in the spreadsheet.
Example
H contains: Apple
AF contains: Apple=2, Orange=3
I would like to end up with AF containing: Apple=2
Many thanks
I am looking to ensure that the contents of column AF, which can have mulitple values, pulled from a sharepoint site, only has the value associated with the value in column H. I like this to work through all of the rows in the spreadsheet.
Example
H contains: Apple
AF contains: Apple=2, Orange=3
I would like to end up with AF containing: Apple=2
Many thanks
ASKER
Wow
Do I need to change any of this to look at my specific columns? I have put this into a module, what is the correct way to use this?
Many thanks
Do I need to change any of this to look at my specific columns? I have put this into a module, what is the correct way to use this?
Many thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Many thanks, I understand know where the code need to be modified.
Thank you
Thank you
Open in new window