MsCrystal1
New Member
- Joined
- Jun 30, 2015
- Messages
- 6
I need to mimic an Access report in Excel.
The report is based on a flat file where dates repeat and contract numbers repeat.
Essentially, I’d like to do something like a vlookup, but feel it may be a simpler way.
I have the following information in rows as my source
Contract Name, Submission Date, Amount, Approved, On Target, Off Target,
I’d like this information to populate based on the Contract Number and Submission Date
So Contract X, MAR 2014 Amount, Approved, On Target, Off Target
Contract X MAR 2013 Amount, Approved, On Target, Off Target
Contract X MAR 2012 Amount, Approved, On Target, Off Target
Contract X MAR 2011 Amount, Approved, On Target, Off Target
and then move on the next Contract value
In access I’m able to create a report template which populates based on the single table and knows to move on to the next contract/line . I can also group by contract which puts all contract data on one tab
I realize I could create separate tables, but I’d keep the file as small as possible.
The report is based on a flat file where dates repeat and contract numbers repeat.
Essentially, I’d like to do something like a vlookup, but feel it may be a simpler way.
I have the following information in rows as my source
Contract Name, Submission Date, Amount, Approved, On Target, Off Target,
I’d like this information to populate based on the Contract Number and Submission Date
So Contract X, MAR 2014 Amount, Approved, On Target, Off Target
Contract X MAR 2013 Amount, Approved, On Target, Off Target
Contract X MAR 2012 Amount, Approved, On Target, Off Target
Contract X MAR 2011 Amount, Approved, On Target, Off Target
and then move on the next Contract value
In access I’m able to create a report template which populates based on the single table and knows to move on to the next contract/line . I can also group by contract which puts all contract data on one tab
I realize I could create separate tables, but I’d keep the file as small as possible.