Hi
I need a help to create a macro to filter out the unique value from sheet 1 and pest in sheet 2
The only condition is in sheet 2 it should pest in 4 lines interval .for example I have just pest 4 name in sheet 2,and it should be automatically.
If I update sheet 1 it should update sheet 2.
Regards
Arindam
Hi Arindam,
You should first make sure the sheet names correspond to what you're asking. Sheet 1 you have named Sheet2 and Sheet 2 you have named Sheet3, can confuse some of us if we do not check the sheet's index.
I'll see if I can do something for you.
How's your vba (macro) knowledge?
BTW what's the Excel version you're using?
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Hi Keebellah
Sorry for the inconvenience
I am using Excel 2007
Yes I have mistaken the sheet name ,also I just wanted to add one more things.
From sheet name "Arin1" the Unique name should copy in Sheet 2 called "Arin2" along with the name count of A2:A356 for Arin1 is that Possible.
In the new attachment I have update Arin2 how I required.
Thanks in advance.
Arindam
Now you are confusing me.
In Arin1 you have two columns. Which one is the list you want the unique names tin Arin2
Your first example wast just one column in Arin1.
Please be clear about this. we try to help but explain and don't upload a different lay-out.
And if you are using Excel 2007 why are you saving the file in the old xls format and not xlsx?
Here's a file based upon the first explanation and one column in Arin1
Just press the big button to run or add a name to the list and it will run automatically and update Arin2
Hi Keebellah
again Sorry for the inconvenience
Arin1 - Unique value of B2:B356 should pest in Arin 2 C4 Ex:-"abhishek.amit"
In Arin2 D4 ---I need the count of A2:A356 when the Name 2 line of Arin1 is matching as Arin 2 C4 .
Hi Keebellah
again Sorry for the inconvenience
Arin1 - Unique value of B2:B356 should pest in Arin 2 C4 Ex:-"abhishek.amit"
In Arin2 D4 ---I need the count of A2:A356 when the Name 2 line of Arin1 is matching as Arin 2 C4 .
What do you mean with Ex:-"adhishek.amit"? Exclude this name?Originally Posted by arindamsenaxa
And why do you save the file as xls?
Example :- "abhishek.amit" in C4 @ Arin2
Here it is
Try
Please Login or Register to view this content.
Last edited by jindon; 12-10-2015 at 05:00 AM.
Hi
I think its still not clear to you
look in to Arin1 B:-- B2:B245 reflecting so many duplicate name i need that name to be copped uniquely in Arin2 C4
after that it will reflecting abhishek .amit in C4, amit.upadhyay in C9
so now it should calculate the name count when
in B2:B245 is = abhishek .amit ,
if you check abhishek .amit name is reflecting 9 times so
Arin2 D4 should count 9
Arin2 D9 should count 2
Arin2 D14 should count 10
Arin2 D19 should count 12
This is working fine
Thanks and cheers
If that takes care of your original question, elect Thread Tools from the menu link above and mark this thread as SOLVED.
Hi jindon
I need a slight formating change in sheet 2 can you please help me in that .
I have attached the new file along with this ,please check the Sheet 2 .
Regards
Arindam
Last edited by arindamsenaxa; 12-10-2015 at 09:30 PM.
Please Login or Register to view this content.
................
Hi Jindon Thanks for your response
I think it is not pulling the correct data can you please look in to this.
and is that possible when it's pull the Name2 data it should pull in assenting order.
Last edited by arindamsenaxa; 12-10-2015 at 09:46 PM.
What are you trying to do with me by changing data layouts each time???? Huh?
Hay I am extremely sorry for that .but I need it seriously ,I was just trying to execute one report .I believe this is the last change I need in this.
Cheers
Please Login or Register to view this content.
Have you even looked at my file?
Arin,
The 'Arin with code' file you attached. What code? Sorry man, you really don't know what you want and like jindon says you keep changing layouts and more of that.
Make up your mind and once you've done that stick to it.
Most of us here are trying to help people like you but you are the only one that can tell us what you want but then you should tell the same thing every time and not keep changing around.
It's just like lying, once you start you always tell a different story (not that you are lying), you just do not seem to be able to decide what you want.
Also, if you really are using Excel 2007 why are you still posting Excel 95-2003 version files?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks