Solved

Excel Formula

Posted on 2016-09-20
6
78 Views
Last Modified: 2016-09-25
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
Comment
Question by:surah79
  • 3
  • 3
6 Comments
 
LVL 28

Accepted Solution

by:
Subodh Tiwari (Neeraj) earned 500 total points
ID: 41808077
Please refer to the attached and let me know if I understood your requirement correctly.
Test_Data.xlsx
0
 

Author Comment

by:surah79
ID: 41808083
thanks a lot for your quick help on this
0
 
LVL 28

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41808089
You're welcome Surah!
And I assume that worked for you.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:surah79
ID: 41809850
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
 
LVL 28

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41810108
Yeah better you open a New Question based on your recent requirement.
0
 

Author Comment

by:surah79
ID: 41815178
thanks a lot
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

948 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now