troubleshooting Question

Excel from multi sheets

Avatar of infiniti7181
infiniti7181Flag for United Arab Emirates asked on
Microsoft ExcelMicrosoft Office
5 Comments1 Solution45 ViewsLast Modified:
Hello Gurus,

Good day to you . I would like to get clarified for a below query .


I have an example sheet contains
1. Sheet 2
2. Sheet 1

Sheet 1 contains data , in real i would be extracting from CRM as xls file and i will paste it as Sheet 1
Sheet 2 will be record extraction from Sheet 1 .

What i am trying to acheive is as follows :
1. What formula will be suitable to select with certain details to get extracted for Region and Unit by using Code as baseline . i tried to use Dget function , but it works only one cell at a time , which makes it tedious for 1000 plus line items
2. i  would like to know , if some one gives me diff sheet , how can i understand the difference, in this case , my third sheet there is discrepency in unit for Code 3019 .

kindly advise with suggestions for me to understand the logic for a newbie :)
BR,
sid
Test.xlsx
ASKER CERTIFIED SOLUTION
Roy Cox
Group Finance Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros