hello
I have this macro it brings specific data form sheet1 to sheet2 based on headers but I would also mod the code or alternative when I write the code in COL A in sheet2 then brings the values based on values in COL A and the topic headers I put some data when search based on COL A and the headers in sheet2
HTML Code:
Last edited by ABDELFATTA; 04-29-2021 at 12:45 PM.
Hi ABDELFATTA,
Does the code you posted work as needed ? What exactly the change you need ? It is not clear to me
what I want when when write the values in COL A in sheet2 based on COL A (CODE) in sheet1 then brings the data based on headers
my code brings the data when write the headers in sheet2 but I would add condition also depends what write in COL A as i put the result should brings the data based on write in COL A and headers but the original code brings all data based on the headers
Try this ...
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
thanks but if I add the rest of headers in sheet2 it doesn't work
Ok, try now ...
Please Login or Register to view this content.
it gives error 'This change cannot be performed on a merged cell' in this line
HTML Code:
Is this error based on your sample file in post #1 or in your original file ?Because I am not getting this error based on the sample file
yes the same file but version office 2019
Try removing the merged cells in Sheet2 range H9:K14
excellent! it works perfectly thanks for provide me solution
Glad to help & thanks for the Rep+
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks