Solved

Excel Formula

Posted on 2016-09-20
6
118 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 30

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 30

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41808089
You're welcome Surah!
And I assume that worked for you.
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

 

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 30

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

Question has a verified solution.

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

This article will show you how to use shortcut menus in the Access run-time environment.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

861 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