scprism
08-13-2010, 07:58 AM
Sorry for the really confusing the title im not sure how to explain what im trying to do!
Ive been asked by a client to amend a spreadsheet so that when on a sheet a date is typed in, it puts an x in the right column in another sheet.
For example:
I put the date in Sheet 1 as 23/04/2010 next to a customers name
In Sheet 2 i would like an X to appear in a cell (lets say D3) under the April column for that customerIm not sure if this is possible but anyone taking the time to help me would me much appreciated!!
Thanks in advance :thumb
Shaun
Ive been asked by a client to amend a spreadsheet so that when on a sheet a date is typed in, it puts an x in the right column in another sheet.
For example:
I put the date in Sheet 1 as 23/04/2010 next to a customers name
In Sheet 2 i would like an X to appear in a cell (lets say D3) under the April column for that customerIm not sure if this is possible but anyone taking the time to help me would me much appreciated!!
Thanks in advance :thumb
Shaun