• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 138
  • Last Modified:

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
0
surah79
Asked:
surah79
  • 3
  • 3
1 Solution
 
Subodh Tiwari (Neeraj)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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now