Pulling data from one worksheet to another

N

neospec

New Member
Joined
Oct 19, 2006
Messages
23
I have 2 worksheets that I am working with.

One is a monthly Sales Report ran from our Accounting software, the other is a Sales Report Analysis.

Based on the MAS Code (a code in the Sales Report), I need it to goto the 2nd worksheet, find that MAS code - then the total $ for the Code - and insert it into another cell on Sales Report Analysis.

I'm a little lost on this one. If you want examples, let me know.[/code]
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
Sort by date Sort by votes
Ive read all through it and all about VLOOKUP, but it don't think it can do what I need.

Can I post the 2 excel files?
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Solved
Add total row with a loop
Replies
4
Views
140
gberg
G
Kaz09
  • Question
Copy rows from multiple sheets based on data
Replies
1
Views
151
Fluff
Fluff
F
  • Solved
Macro to add sum to all worksheets in a workbook except for a certain worksheets
Replies
3
Views
261
Alex Blakenburg
A
N
  • Question
Migrating a data pull
Replies
0
Views
88
Natemoney2
N
M
  • Solved
Moving Table Row to Another Table Based on Condition
Replies
2
Views
256
MJaspering
M

Forum statistics

Threads
1,214,920
Messages
6,122,264
Members
449,075
Latest member
staticfluids

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top