Anyone else addicted to Excel spreadsheets?

immoral_angeluk

4maxine wrote: »

Open the sheets you want to link.
Click on the cell you want the data to appear in and type =
Go the other sheet and click on the cell with the original data and hit "ENTER"

and voila.....

don't forget to save it afterwards

Ooooh so that's where I've been going wrong.. lol

tigtag02

sloppy_saver wrote: »

with all these socialising threads how is anybody supposed to get help?
any requests for help will just slide right down the board because all these social threads hog the place.

you dumbasses.

:T :T :T Now you have learnt copy and paste we might let you have a go on excel

skylight

Oooooh....

handbags at [STRIKE]dawn[/STRIKE] 6.25pm.....

bandraoi

GingerSte wrote: »

I have to admit I haven't used my financial spreadsheet for a while, as I got used to my financial situation (I got in debt after finishing uni and moving hundreds of miles away from home about 3 or 4 years ago). Today I can practically remember every bill I've got going out for the month, and as most of them are on direct debit I don't need to do anything except check my statements EVERY MONTH.

However, I do use spreadsheets on a very regular basis for my work, things like designing prestressed concrete beams, retaining walls, all sorts of structural design really. I can even define new functions (to an extent),to make my life easier.

Just so you know, my largest Excel file is 33Mb. Any challengers?

As a fellow structural engineer, I suggest you take a look at MathCad, it's miles better than Excel for that sort of work.
It's a great piece of kit and far more fun.

GingerSte

Thanks bandraoi. We've got MatchCAD in the office, although I haven't used it.

Unfortunately I've got enough on my plate trying to learn MATLAB and LUSAS.

rhubarb_and_custard_3

[/LIST]

immoral_angeluk wrote: »

How do you link them? i've been trying to do a debt one but can't get my head around it.. any tips?

Hi if you want to link two spreadsheets together. open the spreadsheets together (minimise the one you want to get information from, then say if you wanted to have a total of amounts from one excel spreadsheet put the = sign click the cell you want info from the click+ then click the cell from the other spreadsheet (you want the info from) then press enter. this should then bring you back to the first spreadsheet. as the individual sheets are updated your info should be updated too.

ZTD

rhubarb_and_custard wrote: »

[/LIST]

Hi if you want to link two spreadsheets together. open the spreadsheets together (minimise the one you want to get information from, then say if you wanted to have a total of amounts from one excel spreadsheet put the = sign click the cell you want info from the click+ then click the cell from the other spreadsheet (you want the info from) then press enter. this should then bring you back to the first spreadsheet. as the individual sheets are updated your info should be updated too.

Just be careful an consistent with your naming convention - it uses the full path when referring to your other spreadsheet. This is a pain in the rear end at times...

bandraoi

keep the two spreadsheets in the same folder at all times, and you should be ok.

ZTD

bandraoi wrote: »

keep the two spreadsheets in the same folder at all times, and you should be ok.

But bang goes the hierarchial naming system...

sammy115

http://www.mrexcel.com/learn-excel.html

IA try this book. It's good. Someone else mentioned Mr Excels site and its from there.

And I adore Excel - its what i do freelance.