hi,
i would transfer data not contiguous cells (i1,i2) & columns b,c,e,g,j from sheet to another
hi,
i would transfer data not contiguous cells (i1,i2) & columns b,c,e,g,j from sheet to another
Last edited by ABDELFATTA; 06-10-2020 at 03:12 PM.
It might help us better understand what you want if the result was illustrated using some sample data on the Copy and Purchase sheets.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Hi ABDELFATTA,
Try the below code ... Your file is simple & I highly encourage you to remove the merge cells if you plan to use macros as much as you could as they'll just create more problems
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
hi, nankw it repeats data more than time when run the macro i tested by fill one row it repeats the data and give me error run time 1004 and highlight this line
HTML Code:
hi, jetemc i edited my file and put the expected result in sheet(copy)
I have revised the code … I have only tested it with multiple rows the first time
Please Login or Register to view this content.
great work , thanks so much
Glad to help & thanks for the reps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks