• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Guide Please

B

BABAR ALI 3614

New Member
HELLO EXCEL EXPERTS, PLEASE GUIDE ME FOR THE FOLLWOING

I HAVE 3 RANGES AND EACH RANGE BASED ON TWO COLUMNS, ITEMS CODE & EXPIRY DATE
I WANT TO COPY CODES AND DATED RANGE BY RANGE TO THE DOWN SIDE, 1 RANGE, THEN 2ND RANGE THEN 3RD RANGE AT THE END, AND REMOVE DUPLICATES FROM TWO COLUMNS CONSIDERING EXPIRY DATES AND CODES AS ONE, NOT SEPERATELY.

PLEASE NOTE THAT RANGES ROWNS ARE NOT FIXED, RANGES ARE VARIABLE BUT PLACE OR THE POSITION ON THE SHEET IS ALWAYS SAME, CHECK THE IMAGE, WEEK 1+WEEK 1 NEW QTY & WEEK 2 ARE MY DATA RANGES, SUMMARY IS THE RESULT


1736840786356.png
 
BABAR ALI 3614
Are You sure that You read well Forum Rules before Your the 1st posting?

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
eg How to get the Best Results at Chandoo.org
and
PLEASE DON'T SHOUT! We have big ears and will hear you just the same.
( You used only capital letters - which is ... shouting).
 
You must log in or register to reply here.
Back
Top