Within an Excel file I would like to sort so that anytime a "value", in this case a name, appears in either one of two columns I can see the row. For example if row 1 column C contains "Smith" and "Smith" appears again in row 12 column D, I would like to see the contents of both row 1 and 12.
The same question is asked yesterday on a dutch forum.
This were the 2 results
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Willem -
The attached file works well. However I don't see a "function" or "Formula" in the Input cell. How do I enter that function/formula into my spreadsheet?
Which file your talking about.
The first has a hidden column
The second is by VBA
Upload your file and I will look at it.
I want to look for values from columns C & D but view the entire row.
I think this is what you want.
Exactly!
Now, can you tell me how to do this myself?!
I see what you did in column O but what next?
Last edited by BT3; 04-27-2015 at 02:28 PM.
I format the list as a table and a put a little VBA in it (ALT F11)
Willam, Your talking to a novice here!
Please walk me through step by step.
Thanks
Started from your example #5
Insert a row at the top
Formula in O2: =C2&D2
Copy the formula down to the end of the list.(O592)
Select the whole list (A2:O592)
In the 'Home' tab you find 'format as a table'
click on it and choose the layout you want.
Select 'my tabel has headers'
Then 'OK' and 'Yes'
Start VBA with ALT F11
On the left you see VBAproject with your filename
Select 'Sheet1' just beneath it and put this code in it (right of your screen.):
And it all will work (I hope
Please Login or Register to view this content.)
Willam, last year you helped me to add a VBA into a spreadsheet. Can you please help me again? I have attempted to add the VBA with your directions but have not been able to. If I send you the file can you add it for me? I can email the file directly to you if you would like.
Thank you, Bill [email protected]
Willam, last year you helped me to add a VBA into a spreadsheet. Can you please help me again? I have attempted to add the VBA with your directions but have not been able to. If I send you the file can you add it for me? I can email the file directly to you if you would like.
Thank you, Bill [email protected]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks