Excel - A macro copy to cell based on a specific criteria

[Closed]
Report
Posts
1
Registration date
Monday January 28, 2013
Status
Member
Last seen
January 28, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,


how to split the data from state wise using macro

ex:
Location type month year state
India email 12 2012 UP
India email 12 2012 karnat
India email 12 2012 kerala
India email 12 2012 TN
India email 12 2012 MP

need each state each sheet

2 replies

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
44
Hi mani11,

I would like to work with you to find a solution. Please reply with a little more clarification. I would like to know what is meant by "need each state each sheet". A good idea will be to upload your sample file to the below mentioned site:

https://authentification.site

Note: Please do not upload any file with any confidential or protected data such as name, phone numbers, etc.

Please do write back to us.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768