Help for a complete dummy like me!

  • Thread starter Thread starter Dave Harker
  • Start date Start date
D

Dave Harker

Hi!

I'm creating a spreadsheet that will take my daily income
and expenditure balance and post it to a specific cell
against the date for that day in the month. I may be doing
things in an over complicated manner but here goes! I am
able to create a cell reference in a cell by concatenating
the column (eg. J) with a calculated number (eg. todays day
+10) to give the reference (eg. J26). I am now trying to
GOTO the result of that concatenated reference (eg. J26)
and can't find an easy way to do it. Can anyone out explain
to a complete newbie like me what I should be doing?
 
You have to be more specific than this. Having read your text, I stil
have no idea what you want to do. Answer the following questions
please:

1) What is your input (integer or text)
2) Where is your input (sheet and cell names)
3) What output do you want and how does this relate to the input
4) Where do you want your output to be (sheet and cell names)
5) What event do you want to trigger the calculation (e.g. Button)

Answer these and I will try to help you
 
When you say "go to J26" do you mean "select it"? You can do that by using
the arrow keys, or clicking it with the mouse, or using the Goto key (F5)
and typing in the address. But perhaps you mean something else...

--
Jim Rech
Excel MVP
| Hi!
|
| I'm creating a spreadsheet that will take my daily income
| and expenditure balance and post it to a specific cell
| against the date for that day in the month. I may be doing
| things in an over complicated manner but here goes! I am
| able to create a cell reference in a cell by concatenating
| the column (eg. J) with a calculated number (eg. todays day
| +10) to give the reference (eg. J26). I am now trying to
| GOTO the result of that concatenated reference (eg. J26)
| and can't find an easy way to do it. Can anyone out explain
| to a complete newbie like me what I should be doing?
 
Back
Top