Inserting rows automatically

Sandeep Dangda, on Friday September 5, 2008 12:15:04 PM

Hello,
I want to put one formula or function or button in a cell that whatever no. I put in cell the same no. of rows containing some particular datas get inserted in following row.
One more thing how to use hyperlink for hided worksheet. Suppose I hide sheet2 and sheet1 is having one link that is hyper linked with sheet2 and when I click in corresponding cell in sheet1 then this hyperlink will not work.

Configuration: Windows XP
Firefox 3.0.1

Reply to Sandeep Dangda Report this message to moderators Go to last message

This message seems useful, vote!
Report this message to moderators

notebookpc, on Friday September 5, 2008 03:23:12 PM

hey there,

have you checked in the help files of excel itself if you found something ?

Reply to notebookpc

Ask your question Reply

Results for

Group/Move Rows to New Worksheet VBA Hello, I'm trying to find some VBA to do the following steps in excel: 1. Look down column A for similar values (will be in alpha order). 3. Group rows that have similar values in column A 4. Search for worksheet named with value in column A. 4a.... en.kioskea.net/forum/affich-30660-group-move-rows-to-new-worksheet-vba

Copying data to next row automatically Hello, I have a form, which has been designed in an excel sheet, which has various fields. All these various fileds, should get copied in one single row, basis the name selected. for ex: Name Login time Log out time Training taken Date taken XYZ 18:00... en.kioskea.net/forum/affich-30430-copying-data-to-next-row-automatically

Processes - autorun - autorun.exe The process autorun.exe (autorun) is a generic Windows 98/NT/Me/2000/XP process which automatically runs a program from a CD-ROM when the CD is inserted in the disk drive. The process autorun is not in any way a virus, a worm, a Trojan horse,... en.kioskea.net/processus/autorun-exe.php3

1 2 3 Next

Results for

Disactivate the command autorunDisactivate the command autorun Autorun is a command application which takes automated action during the insertion of CD-ROM etc. This feature is designed to boost up an installer once a floppy drive is inserted. However this may be a... en.kioskea.net/faq/sujet-665-disactivate-the-command-autorun

Excel tips : How to insert date In an Excel cellExcel tips : How to insert date In an Excel cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press “CTRL”+ “;” in the chosen cell. To insert current... en.kioskea.net/faq/sujet-313-excel-tips-how-to-insert-date-in-an-excel-cell

How to insert picture background on Microsoft!How to insert picture background on Microsoft! To make a work sheet more appealing, you can add picture to your background. Below is a tip for doing so. Open your Microsoft and select “Format”> “Backgrounds” > “Printed... en.kioskea.net/faq/sujet-334-how-to-insert-picture-background-on-microsoft

1 2 3 Next

Results for

VB code for copy data from one excel sheet toHello,All I have one problem Please give me Solution Plese.I have 20 diffrent sheet with same format and i have one more sheet with diffrent format Now,I want to Copy 2 Column to othet sheet rows .How can i do automatically????? Example Sheet-1 col1... en.kioskea.net/forum/affich-29772-vb-code-for-copy-data-from-one-excel-sheet-to

Macros to copy Cells in ExcelHello, Can you please modify the below code, so that only 10 rows per sheet are pasted in Master.xls. Also I need this feature to be included . i.e., once after completion of pasting 10 rows in Master.xls, the macro should do the job of inserting new... en.kioskea.net/forum/affich-29575-macros-to-copy-cells-in-excel

Ma portable hard disk ix fukd upHello, im using 160 GB hard disk, well i used it about 3 months but now its dead...if i insert it dhen computer ix restarting automatically.....help man...how do i fix it? en.kioskea.net/forum/affich-27939-ma-portable-hard-disk-ix-fukd-up

1 2 3 Next

Results for

Download Audio/Video To ExeYou touch do not know how make to throw automatically the reading of your audio files or videos from the insertion of the CD in a reader, then use this tool. Audio / video To Exe is an application allowing to convert the audio / video files into... en.kioskea.net/telecharger/telecharger-438-audio-video-to-exe

Download RemoteKeysSome tasks are repetitive when you work on your computer, as to insert the date, names of contacts, calculations, etc. Remote Keys is a program allowing to automate complex controls or simple jobs. For it you only have to choose among 2500 buttons... en.kioskea.net/telecharger/telecharger-496-remotekeys

Download AutomizeEven if you are not in front of your screen of computer, you can carry out tasks by programming them. Automize is a tool intended to perform this function of automize of tasks. You can so program beforehand more than 1000 different tasks a day. He... en.kioskea.net/telecharger/telecharger-603-automize

1 2 3 Next

Results for

Office Automation - Introduction The term office automation refers to all tools and methods that are applied to office activities which make it possible to process written, visual, and sound data in a computer-aided manner. Office automation is intended to provide elements which... en.kioskea.net/bureautique/burintro.php3

1 2 3 Next