Posts by alhagag

I really appreciate for your assistance ,time and patience this post takes much more time actually what i attached in post# 28 this what I work for them there is still request , but I can't ask for you now if I don't fix this problem ,it doesn't make sense my request

I'll try to find where is problem , if I found out I'll inform you

best regards,

alhagag

would you check what show me in file search

ok I copy and paste but there is problem it shows data from before the topic headers despite your code indicates from row6

please check my file and see what happened

I explained what I want I put what I want in sheet result

Quote from Mumps

This line of code:

Code

desWS.Range("A6:E" & LastRow).ClearContents

deletes all the old data before copying the current data so there should be no repeated data. Please post copies of your actual files, not pictures, so I can test the macro properly.

please tell me where exactly I put this line I think this line will solve what I'm looking for so if is not I will issue whole expected result

thanks again

as you want

i think this line code is wrong about preparties i put every time in specific location but it gives me error method range of object -worksheet failed

where I put this line?

I tested your file it repeats copying data and became slow

still repeat and untidy

as in the picture when I run macro it brings data from row6:8 but when I run macro again it copies the same data again I don't want if I press macro continuously

ahhh ! I've found the mistake as your file and code search in a2 but my original file based on b2 yes it works as based on a2 but i don't bring data repeatedly just update if change old data or add a new data when run macro repeatedly

hi, Mump very strange ! theses are the same files this is what I got as in my picture

thanks Mumps but your code is something wrong it copies the topics heads not data values and it copy repeatedly i would just one time if is a new data or change old data then just update not copy repeatedly old data every time run the macro

Sorry Mumps for delaying answer you , just the file search is open it brings all data from the others files without open any file

hello

I search macro bring data from multiple closed workbooks in multiple sheets so I have file called search in cell b2 write the number based on col a in multiple closed workbooks into multiple sheets then show the result in file search col a the name file is existed data and col b,c,d as existed in files and the column e sheet name are existed in files

great work yes this is better every thing show i can see what i add and change after adding many thanks

i know about my code i need amending based message box or alternative

about the message is very important for me , so what you suggest ?

yes you can see that and avoid any mistake while filling data show the quantity before and show how it is after add