Please send me formulas on Microsoft Excel to merge sheets, extract data from multisheets into one, generate alphabets from a to zzzz... and refresh multi-files linked to websites.
Thanks a lot for whatever help you can give me.
Regards,
Suraj
2007-03-08 06:35:07 · 6 answers · asked by Anonymous in Computers & Internet ➔ Software
Well there are no shortcut formulas for the tasks you mentioned. But if you are doing similar tasks again and again, you can use macros.
Go to Tools -> Macro -> Record New Macro.
Assign a name to the macro and execute the set of commands which you thinking you have to repeat more number of times. The macro will record the group of commands until you stop recording. It will then execute them when ever you play it.
This thing really saves a lot of my time.
Hope it works.
2007-03-08 06:58:08 · answer #1 · answered by dharmin 2 · 0⤊ 0⤋
There are no "formulas" to do that, what you have to do is learn how to program in "Visual Basic for Applications", or simply VBA. As for arranging things alphabetically on a crescent or decrescent orientation, simply use the proper buttun after selecting the rows you wish to affect, it´s one like this "A>Z".
2007-03-08 06:46:19 · answer #2 · answered by Gabriel G 3 · 0⤊ 0⤋
No Formula is there, you just go format>cells>alignment option after selecting the cells which u want to merge. the just select merge cells.
2007-03-12 00:12:12 · answer #3 · answered by Anonymous · 0⤊ 0⤋
that is not. H24+a million=B24 is invalid. H24+a million can in user-friendly terms be an rvalue (on the superb suited area of an = sign). BTW, the functionality you want is the variety between the specified quantity and the specific quantity.
2016-09-30 09:46:45 · answer #4 · answered by barksdale 4 · 0⤊ 0⤋
Hi Suraj
http://www.exceltip.com/
visit this site , it may help you
2007-03-08 22:26:55 · answer #5 · answered by Anonymous · 0⤊ 0⤋
You need a user manual.
2007-03-08 06:41:46 · answer #6 · answered by john b 5 · 0⤊ 0⤋