₦airaland Forum

Get it solved here. Drop all problems here

just tell me how to link a sheet to another.... by just one click

yutsuf:
just tell me how to link a sheet to another.... by just one click

Could you elaborate please ?

Do you mean something like a macro or button that takes you to another sheet when clicked ?

I need to know how to link 10 stylesheets together in a single click.

emymeeky:
Could you elaborate please ?

Do you mean something like a macro or button that takes you to another sheet when clicked ?

Yes, explain this.

T4kbaba:
Yes, explain this.

Record a macro and assign it to a button

I think what he is saying is, he having different spreadsheets in a workbook and wants a spread sheet to be the main sheet that has options to go to other sheets on a click. Just like DDM in Interpreters and Compilers. Am I write pls?

rahman3853:
I think what he is saying is, he having different spreadsheets in a workbook and wants a spread sheet to be the main sheet that has options to go to other sheets on a click. Just like DDM in Interpreters and Compilers. Am I write pls?

I think you're right. It's very simple and can only be done using a VBA macro. I'll assume he may want other cells hidden apart from the main cell and would require buttons ,specific to each sheet which will activate them .

dhtml18:
I need to know how to link 10 stylesheets together in a single click.

Could you upload a sample workbook at http://d-h.st/ so I can try and fix it ?

emymeeky:
Could you elaborate please ?

Do you mean something like a macro or button that takes you to another sheet when clicked ?

like maybe a code i can write in a cell... and when clicked, it'll link me directly to another sheet/file

rahman3853:
I think what he is saying is, he having different spreadsheets in a workbook and wants a spread sheet to be the main sheet that has options to go to other sheets on a click. Just like DDM in Interpreters and Compilers. Am I write pls?

Guess yes!

emymeeky:
Record a macro and assign it to a button

Explain in details please.

yutsuf:
like maybe a code i can write in a cell... and when clicked, it'll link me directly to another sheet/file

It's simple . just upload a sample of the workbook I can work with on http://d-h.st and send the download link

T4kbaba:
Explain in details please.

You can actually record a macro ( if you have enabled your developers option ) and assign the macro on any button or text

emymeeky:
You can actually record a macro ( if you have enabled your developers option ) and assign the macro on any button or text

l have developers option.How should l assign macro on button.

emymeeky:
It's simple . just upload a sample of the workbook I can work with on http://d-h.st and send the download link

what if i don't know aw to do that

yutsuf:
what if i don't know aw to do that

You mean uploading to the website?

emymeeky:
You mean uploading to the website?

yh

yutsuf:
yh

Then I can't help

What is the work of macro in excel ?

emymeeky:
I think you're right. It's very simple and can only be done using a VBA macro. I'll assume he may want other cells hidden apart from the main cell and would require buttons ,specific to each sheet which will activate them .

VBA macro is the best solution but all he needs to to is use the reference commands and I suggest renaming the spreadsheets to the simplest form so as not to bring up bugging syntax errors

rahman3853:
VBA macro is the best solution but all he needs to to is use the reference commands and I suggest renaming the spreadsheets to the simplest form so as not to bring up bugging syntax errors

Naming is not the problem . he only has to save it in a macro-enabled format

Elegantdiva:
What is the work of macro in excel ?

Macros are set of VBA programs that can be used to give a deeper instructions to excel. Writing a macro has an environment in excel . you can trigger the environment by pressing ALT F11

Tell me how to use it