Z_Sutcliffe123
New Member
- Joined
- Apr 5, 2019
- Messages
- 8
Hello,
I am working with a spreadsheet that is split by Parts
as you can see below.
I need column A to pull revenue from columns F, H and I organised hierarchically by the date. So for example, cell A2 should contain "14/02/2019" because that is the earliest date and then B2 should contain the revenue figure adjacent to it "£100". Then A3 should pull "26/02/2019" and then B3 should contain that date's adjacent revenue figure "£324.11". This also needs to be dynamic. So if I put in a date "10/02/19", then I that should be placed in cell A2 with it's corresponding revenue in B2. The figures that were originally placed in A2, A3, B2 and then B3 get shifted downwards.
I appreciate any help or guidance!
I am working with a spreadsheet that is split by Parts

I need column A to pull revenue from columns F, H and I organised hierarchically by the date. So for example, cell A2 should contain "14/02/2019" because that is the earliest date and then B2 should contain the revenue figure adjacent to it "£100". Then A3 should pull "26/02/2019" and then B3 should contain that date's adjacent revenue figure "£324.11". This also needs to be dynamic. So if I put in a date "10/02/19", then I that should be placed in cell A2 with it's corresponding revenue in B2. The figures that were originally placed in A2, A3, B2 and then B3 get shifted downwards.
I appreciate any help or guidance!
