Hello Sir
I am looking for a macro
we have to look for only positive numbers in column S of sample1.xls & match column Y of sample1.xls with column B of sample2.xlsx
if it matches then clear all the data in that row from column C of sample2.xlsx
In the sample file
3rd row data will be cleared from Column C(we will not clear the data of column A and Column B, clearing of the data will be start from Column C)
Hi dumdumbum,
Try the below code on a copy of your file
Please Login or Register to view this content.
If I was able to help, you can thank me by clicking the * Add Reputation under my user name
Thx Alot Nankw83 buti will put the macro in vba.xlsm,each file is in different path
& Sorry Nankw83 for not providing that info to u in the earlier post
Last edited by dumdumbum; 06-02-2020 at 10:33 AM.
Do you mean the main file where you're reading the data from is different or the file where you want to delete the data from is different ?
Yes all files are located in a different path
And i will run the macro from vba.xlsm (Macro will be Placed in vba.xlsm file)
Macro will be putted in this file which i have attached below
Ok, I have added a prompt for you to select the file
Please Login or Register to view this content.
Sorry Nankw83, I don't need any prompt to select the file
The macro should do this automatically , the reason for this is I have 3 macros that will run back to back ( I am looking to automate the same, No manual work will be done from my end)
So request u plz have a relook Sir
If the files are located in different path which you don't want hardcode in the VBA as provided in post #2 & you don't want to select the file yourself as provided in post #4, could you explain how this should be done ?Originally Posted by dumdumbum
I got it , there is some misunderstanding
Plz assume any location u want & I will edit it from myself as per my pc & file location but I don't need any pop up Sir
Refer back to code provided in post #2 & change the below path to what you have in your PC
Please Login or Register to view this content.
Yes this I know but I am confused with sample2.xlsx, how I mention the path in the macro for the same, when I got ur post# 2 macro at that time I tried to edit it by myself & I got stuck in putting the location of sample2.xlsx so I asked u
I'm not certain that I follow … Simply open your Vba.xlsm file & insert a new module (Alt + F11 --> Alt + I + M) the macro in post #2 & just change the file where you need to read data from
Instead of Active sheet I will put ws2Please Login or Register to view this content.
And at the top I will put Dim Wb2 As workbook & ws2=wb2.sheet.item
Am I right?
Sure give me a sec I will let u know
If you need to specify the sheet of file Vba, you can do it like below
Please Login or Register to view this content.
Please Login or Register to view this content.
I used this nankw83 getting error with "expected end with" could u help me for the same
I've revised your code a little, try it now
Please Login or Register to view this content.
Last edited by nankw83; 06-02-2020 at 11:45 AM. Reason: Small correction in the code
This code need some slight changes Bcoz we have to delete the data if column S of sample1.xls has positive numbers (But this macro delete the data if column S of sample1.xls has positive numbers & If column S has any alphabets also, it should not delete the data if column S has any alphabets)
Plz run the Macro on sample file and notice the error Sir
Last edited by dumdumbum; 06-02-2020 at 12:04 PM.
This is not an error, it was not asked for in your original post. Anyway, I've added one more condition as highlighted below
Please Login or Register to view this content.
Awesome Nankw83, Thnx Alot for ur Great Support
Glad to help & thanks for the reps !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks