surah79
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome Surah!
And I assume that worked for you.
And I assume that worked for you.
ASKER
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
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
Yeah better you open a New Question based on your recent requirement.
ASKER
thanks a lot
ASKER