Excel question

[Spirit's Slave]

I'm working on a spreed sheet and I want parts of it set up so that what ever I type in one cell it will automatically change in another.

eg: In cell FF4 I type in "15". I want cell D20 to change to "15"

How do I do it?

 

[HomeLAN]

Set the formula in cell D20 to "=FF4" (without the quotes). it'll automatically change to reflect whatever's in FF4.

 

[Luis G]

that or $FF4 if you want to lock the formula, in case you want to copy paste and it doesn't update the column/row to which it is pointing.

 

[HomeLAN]

Actually, that would only lock the column. To lock the cell, it'd be $FF$4.

 

[ClaireBear]

Aaarrrgggh! EXCEL! Unclean! Unclean! Unclean!

 

[HomeLAN]

Argh, Excel! Necessary! Necessary! Necessary!

Couldn't do my job without it.

 

[Professur]

shore ya coold. Shorely ya recall Lotus 1-2-3-4-5?

 

[MrBishop]

shore ya coold. Shorely ya recall Lotus 1-2-3-4-5?

Far too well...thanks for the reminder

 

[paul_valaru]

shore ya coold. Shorely ya recall Lotus 1-2-3-4-5?

or a pen and paper......manual entry bookkeeping......my personal nightmare

 

[HomeLAN]

Or I could go get star office or open office. Gotta have a spreadsheet proggy, though. I'm not breaking out the ledger paper.

 

[chcr]

First thing I learned to use a computer for was a spreadsheet.

 

[Luis G]

Actually, that would only lock the column. To lock the cell, it'd be $FF$4.

I knew it didn't look good with just one $

 

[HomeLAN]

Hey, the more $ the better.

 

[Inkara1]

That's why Home Depot isn't going to be my career.

 

[catocom]

Or I could go get star office or open office. Gotta have a spreadsheet proggy, though. I'm not breaking out the ledger paper.

HL have you ever tried Medlins GL?

http://www.medlin.com/

My unc used to work for the IRS (retired) and keeps quite a few books still.
Medlin is his main tool.

 

[HomeLAN]

Never have, mostly because the price for what I do use is acceptable, and the updates to things like payroll rates are dependable as hell.

I'd like to be secure in the knowledge that my software will be properly updated for things like the new 941 form next year.

 

[Luis G]

OpenOffice.org works pretty well.

I'm no heavy msoffice user (in fact I use LaTeX for making documents), but it opens and saves succesfully to office files. And the interface is quite similar.

 

[catocom]

Never have, mostly because the price for what I do use is acceptable, and the updates to things like payroll rates are dependable as hell.

I'd like to be secure in the knowledge that my software will be properly updated for things like the new 941 form next year.

MY unc uses MS Money for some of what he does.
He said there's something there where you can just print your own
tax forms right off of it, or when it hooks to the inet or something.

 

[HomeLAN]

For some of them, yes. I've always wondered just how careful they are keeping some of that shit up to date, though. The last thing I need is a red flag for a payroll tax audit.

 

[PT]

18 posts on updating one cell in excel, nope, we're not geeks.