DCrake
10-17-2010, 03:53 AM
This is a far fetched request, but anyay I am going to ask.
I am undertaking a data take on exercise from Excel to Access and the client has an income and expenditure worksheet that is very much like a crosstab with exp types as column headings and week ending dates as the row column. The data is the summation of various costs. Now what thaey have done is to add comments to the cells to state what the sub total relates to. For example if the value is £100 it may say Inv100 £25 Taxi, Inv200 £200 Food.
What I want to try and do is to extract the cell comments into some variable or something that I can print out to save me clicking on each cell and manually writing down the contents of the cell comments. Is this acheivable?
I am undertaking a data take on exercise from Excel to Access and the client has an income and expenditure worksheet that is very much like a crosstab with exp types as column headings and week ending dates as the row column. The data is the summation of various costs. Now what thaey have done is to add comments to the cells to state what the sub total relates to. For example if the value is £100 it may say Inv100 £25 Taxi, Inv200 £200 Food.
What I want to try and do is to extract the cell comments into some variable or something that I can print out to save me clicking on each cell and manually writing down the contents of the cell comments. Is this acheivable?