#1
|
|||
|
|||
Need help consolidating data from separate sheets
Hi,
I'm trying to keep on top of payments made to me and was hoping someone could help me with the following... I have two sheets in my workbook. One contains customer name, project number and some other values. The other one contains the payments and payment info. Both sheets have the project number in common (or at least should). What I'm trying to do is the following: Priority 1: In a sheet (could be the first one), I'd like to be able to expand a client, then have a list of their projects and how much has been paid up until now. If I expand the project line, I want to see the separate payments made. Priority 2: If payments doesn't have valid project number (no matching lines from sheet 1) or it's missing, I would like them sorted in some way making it easy to see and manually fix. (not important - should never happen) If someone could help me with this I would be extremely grateful! Cheers, Lars |
#2
|
||||
|
||||
Hi
please post a sample sheet showing what you have and the expected result ( no pic please)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Checking data in separate files | ksigcajun | Excel Programming | 7 | 05-22-2014 08:54 AM |
Combine Data From 2 Sheets into a new sheet | bremen22 | Excel | 1 | 09-11-2013 12:59 PM |
How to separate specific columns from the data | kumar | Word | 1 | 06-04-2012 01:46 PM |
Consolidating data using Macro | mrjamez | Excel Programming | 2 | 05-22-2012 06:50 AM |
How to syncronize data in two different sheets | diegogeid | Excel | 2 | 09-30-2010 12:19 AM |