hi all
I have a workbook and i want to rearrange data (a huge list) from sheet1 into sheet2, i tried but i can not do it. could anyone to help me, please?
any help is appreciated!
thank you in advance
john
hi all
I have a workbook and i want to rearrange data (a huge list) from sheet1 into sheet2, i tried but i can not do it. could anyone to help me, please?
any help is appreciated!
thank you in advance
john
Last edited by john55; 01-06-2011 at 01:04 PM.
hi, why not to use pivot table?
hi,
watersev, thx, but i do not know how to! could you help me, please?
sort of this
thank you for solution!
i tried, i do not manage, all i did it's a really...i can not say it!
is there another way to extract it and have the desired output?
thanks for assistance
john
Last edited by john55; 01-05-2011 at 09:30 AM.
see attachment, run macro "test"
I', sorry for my late reply!
Thank you for your help, I try to adapt the code but i rcv an error, I check n check n check...
john
I assume the data in real file differs from the one in example, am I right? What do you mean by "adapt the code"?
The code works fine on example file.
Last edited by watersev; 01-05-2011 at 02:43 PM.
yes, it does a little bit! is my mistake i did not copy very well the data into test file.
post new example, i'll have a look
hi,
here it is! thanks for help!
see attachment, run macro "test"
hi,
thank you very much for your help, it works fine!
I have a small issue, the data is sent to a user form, but if there are 2 or 3 people with the same last name, in the user form
is displayed only one.
is there a way to distinguish between them by midle name or first name and to have the possibility to choose (from combobox) if the first one is not what i'm looking for?
i attached a file.
any help is really appreciated!
john
Last edited by john55; 01-06-2011 at 10:57 AM.
I reduced the unnecessary complexity of the userform.
hi snb,
it works very well, like a charm!
thank you for your time and help!
john
There's one more thing:
to arrange data fom sheet 1 to sheet 2:
first delete column E in sheet1
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks