Dharmendrasingh
New Member
- Joined
- Oct 5, 2014
- Messages
- 1
Hey Guys,
Please solve :
I have workbook name "Dashboard" and "Not Require" and save on same location. Now Dashboard workbook is only active and I have to do below with using Macro :
1. Fist I have to open "Not Require" workbook.
2. I will make vlookup in Dashboard workbook on column A from "Not Require" workbook.
3. I will drag up to end of DATA in Dashboard workbook and do the row past special so formula can remove.
3. Now i have to make filter on found DATA (exclude #NA).
4. Delete filtered DATA.
5. remove filter
5.Close "Not Require" workbook.
It is challenging query.........
Please solve :
I have workbook name "Dashboard" and "Not Require" and save on same location. Now Dashboard workbook is only active and I have to do below with using Macro :
1. Fist I have to open "Not Require" workbook.
2. I will make vlookup in Dashboard workbook on column A from "Not Require" workbook.
3. I will drag up to end of DATA in Dashboard workbook and do the row past special so formula can remove.
3. Now i have to make filter on found DATA (exclude #NA).
4. Delete filtered DATA.
5. remove filter
5.Close "Not Require" workbook.
It is challenging query.........
