1) Please let me know the how to split the spreadsheet and how to remove the split in spreadsheet in EXCEL 2007.




2)A Spread sheet in Excel 2007 has some numbers which are taken from another worksheet. The link to another sheet still exists. I would like to break this link and just have the numbers. There are many links in one sheet and I want to just have numbers in the sheets without link and I want to do this in one stroke. How to do this?



Thanks

HI ALL!

I HAVE CREATED AN INVOICE TEMPLATE IN EXCEL. THIS HAS AN AUTONUMBERING CODE FOR THE SERIAL NUMBER. EACH TIME A INVOICE IS MADE AND THEN SAVED THE REOPENING SHOWS THE NEXT SERIAL NUMBER. I ALSO NEED TO LOCK THE CELL CONTAINING THE FORMULA BEING EDITED. I HAVE MANAGED THIS AS WELL. SO FAR SO GOOD. HOWEVER, WHEN I OPEN THE INVOICE THE AUTO NUMBERING FORMULA DOES NOT WORK. ANY SUGGESTIONS PLEASE. I CAN USE THIS TEMPLATE AS AN EXCISE INVOICE ONCE THIS PROBLEM IS SOLVED. THANKS

E-mails have now proved as very cost-effective and efficient means of communication especially in the corporate world. Are E-mails and other electronically/ computer generated communications recognized as valid piece of evidence in a Court of law? If so, please cite Section number (with case law, if any) of the relevant Legislation/ Act which recognizes E-mails as well as other electronically generated documents as legally valid evidences.

Regards

Please help me.....
By mistake I have deleted one important file from my office server but which I want to recover otherwise my articleship will be in danger.So please help me

Plase let me know, if any one know about this,
that an important file has been deleted by me & it is also deleted from the Recycle bin.
I want to recover that file
that file is very important to me otherwise i will be in a great promblem
please let me know if there is any way to recover that file as soon as possible

I want to denote the PAN database. Now suppose a PAN is ADOPM5655S, i want to denote it on the basis of the 4th caracter i.e "P" as individual Similarly suppose in case of a Company, it would be as "C" the fourth caracter. How can i do this by using the formula?

Im using Tally 7.2 server of which is not mine but another computer. The problem is that on starting Tally 7.2 it shows "no companies on disk!" message. The source of data for 7.2 is located on server obviously. When i get to the tally data folder in server it says

"Server is not accessible. You might not have permission to access this network resource. Contact the administrator of this server to find out if you have access permission.

Access is denied."

How to resolve this?

hi

hello frnds i just want to know practical knowledge of LAN,MAN,WAN & VPN.

hi i m a c.a final student. pls provide advice regarding mics prepartion. which author book to refer for preparation?does preparation from dinesh madan is enough for mics?

Can we extract data from Tax Credit Form 26AS into Excel ?