Hello all,
on the following Macro:
, I know that the command
Please Login or Register to view this content.
, it's wrong.Please Login or Register to view this content.
because if I put a reference column in number as 16, the Macro Works fine.
Please could you tell me how designate that?
And if I want to look for not in one single column but 5 or more or less, how could I do it?
Thank you so much.
Last edited by coolx72; 09-24-2018 at 09:02 AM.
code tags ok...
Last edited by protonLeah; 09-24-2018 at 03:04 PM.
Ben Van Johnson
I have corrected that.
I'm sorry for any inconvenient.
Assuming that cell contains a column number or letter, use:
Please Login or Register to view this content.
Rory
Thank you Rorya,
I've tried that but it comes out with an error. Maybe is it because I`m using Mac?
Thank you very much
No, that should work on a Mac. What exactly is in cell AV1 on the active sheet?
16 that would be correspondent on column 16 (P)
But besides this if I would like to look in more columns would be possible?
Thanks
I suspect the wrong sheet is active when the code runs. Which sheet has the 16 in cell AV1?
Maybe because does not make much sense that error.
"Jugs Tarjs Acum" is where is to look for the information
"Impedidos" is the output table that works fine if I put 16 corresponding to (P).
Each time I want to check the players that can not play the next round, I have to edit the macro and change to 17, 18 etc.
thank you once again
I'd suggest you specify that sheet then. Try this:
Please Login or Register to view this content.
Hello again Rorya,
You are the Man. Thank you so much !!!
I would like to ask you 2 more things please:
1- On previous solution, I copy first all to maintain formats then values to avoid circular and maintain the values of the source table. On your project what should I change?
2- If I want to have the possibility to see which players had cards from round 4-10, this would correspond (16-22)
My solution, for sure not yours, I would repeat at least ten times the macro changing (AV1-BE1) and then. Other easy way?
3- On the file there is other VAB on Duplicados sheet, when I execute happens the same that I solved before but with this code I don't know what to put that would be after paste all, paste values to not have circular and also to maintain initial table values.
And thank you once again for your time. It is fantastic
BR,
Pedro
For #1:
For #2, change the code to take the column number as an argument, then call it from separate routines:Please Login or Register to view this content.
which you'd then call like this:Please Login or Register to view this content.
or in a loop.Please Login or Register to view this content.
For #3, I think you just need to change this:
to this:Please Login or Register to view this content.
Please Login or Register to view this content.
Thank you Thank you Thank you
About your message:
For #1:
IT`S SOLVED !!! THANK YOU. Just a request If I have a column to put the round number that is on line 1 from 16-20 column, when it send to "impedidos", is there some option to put the value of each column on line one of "Jugs Tarjs Acum" ? Thank you and pardon for one more request.
For #2:
Does not recognize the name of Macro: Sub Impedidos(vColumn)
I change it for: Sub Impedidos(vColumn), and does not work either or I wrote it wrong.
Atached is the actual solution.
For #3:
Works very well but does not have the format
Thank you and I'm sorry for bother you again
Last edited by coolx72; 09-24-2018 at 12:04 PM.
I'm afraid I'm not clear what you mean for #1. Can you give a specific example of what you want to put where?
Re #2, you need to create other macros that call the Impedidos routine and pass the required values to it, as I showed.
For #3, use this:
Please Login or Register to view this content.
Hello Rory and thanks for everything time and knowledge once more.
About the #1, Please forget it, any way, I found a solution with lookup, based on cel AV1
Nš INSCR TEAM INSCR TEAM Nombre. DNI FECHA DNI ROUND
3 Team A 3 Luis Figo 983425794 12-04-1995 1
6 Team B 6 Leonel Messi 698746508 18-01-1994 1
Regarding the #2, I don't want you to do my work, but I don't have a clue how to do it.
Concerning the #3 works, however it ask me to confirm for all registers. If I have 1 line ok, If I have more it would be more easy do automatic acceptance.
Thank you once again
Hello again Rory #3 Solved
I added this command: I don't know if it is dangerous:
So the macro final result it would be this one:Please Login or Register to view this content.
SO please if you could help me with #2 everything would be solved.Please Login or Register to view this content.
Thank you once again
I already showed how to do #2, and gave a couple of example lines. You create another macro that calls the first one passing the required column; you can’t run the first macro directly as it now needs an argument passed.
Hello Rory,
Thank you once again.
At the end with a filter column I got the result.
But I would like to understand your solution.
Thank you once again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks