Need Help with Excel Cross Reference Formula

  • Thread starter Constantin Nechita
  • Start date
C

Constantin Nechita

<iframe src="https://skydrive.live.com/embed?cid...EF5915117221!140&authkey=ACNmeSkCm_L_shM&em=2" width="402" height="346" frameborder="0" scrolling="no"></iframe>

This is an small project of mine.In the "bank data" sheet there are some bank transactions,in "table" sheet there are two tables :In the first one there are banking amounts for specific dates(b5:h5) for specific shops (a6:a7);in the second table I want to put the amount from "bank data" from col D in K6:Q7 having as reference the date from col C and shop no from col B from"bank data" sheet.
The purpose of this is to try in matching the amounts from K6:Q7 with B6:J7..

Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
export excel data to access table using ADO 0
VBA macro guru help needed! 1
application.goto reference using references in the worksheet 2
help with "Goto" command 2
Desperately Need Excel Formula Help! 3
In Excel, How to get cell reference of a particular word in anoth. 3
Help with Excel phone list 1

Top