Excel people, you are amazing.

So...

Thanks to many people here, i have managed to open a file in excel,
trim it down, find the data i want, select it, copy it, extract the
date..

Now what i'd love to do is:

Look at the date in the file. (Cell F1)
Look at the TillNumber it came from. (Cell F2)
Go back into the main workbook (Stores.xls) and then into the worksheet
based on which till - ie. Worksheets are called Till01, Till02 upto Till
08. Cell F2 in the opened Cap File has which till it is in single figure
format. ie. Just "2"
Look across Row 3, find which column has the date in.

Then paste the data (in the clipboard already) into Column with the
correct date in, and the Row which i've named "Zero"

I've tried, and tried, but i can't get anything to work!
I realise i'm asking quite a few questions on here, i am trying but
it's not always working!
Thank you


--
drucey
------------------------------------------------------------------------
drucey's Profile: http://www.excelforum.com/member.php...o&userid=32553
View this thread: http://www.excelforum.com/showthread...hreadid=534529