Excel Formula

Hi guys

Need help in copy(on 2 condition are true) the rows from one sheet to another using a formula and then copy those rows "n" number of times according to the user input.

Please find attached the sample template
Copying from Sheet2 to sheet1 depends on the two condition like brand and family has a match in sheet2 and copy the rows qualified  depends how many time the user wants

thanks
Test_Data.xlsx
surah79Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
Please refer to the attached and let me know if I understood your requirement correctly.
Test_Data.xlsx
0
 
surah79Author Commented:
thanks a lot for your quick help on this
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome Surah!
And I assume that worked for you.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
surah79Author Commented:
Hi Subodh

Do you think I should  open a new question on this

Can we also copy and repeat all the combination of data present in the other sheet?
for example
As User input is W(Brand) F1(Family) 2(No Of time to Copy)
W  F1  T1
W  F1  T2
W F1  T1
W F1  T2

Thanks
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Yeah better you open a New Question based on your recent requirement.
0
 
surah79Author Commented:
thanks a lot
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.