Can anybody help me in putting multiple excel files in a new excel
file as a new worksheet?
I have 7 various files with various reports, I need all these report
files in a new excel file from where I keep them as a row data for my
report.
At present I am manually copying all the files and putting
Yes, Mayank
There is a formula called: Text
Wherein A1 cell contains date and if u wanna give result in b1 cell then
type:
=TEXT(a1,"") You will get day of that particular date
Hope, it will help u. And if u still face difficulties, contact me without
any hesitations.
Regards,
S
Hi,
You can try the "RIGHT" Formula, where; it will give you the last 6 digit
from the particular cell.
=RIGHT(B4,6)
Best of luck...
Regards,
Sanjaykumar
On Sun, Oct 19, 2008 at 7:15 PM, Mattathil M. Pradeep
<[EMAIL PROTECTED]>wrote:
> Dears..
>
>
>
> H
Hi Friends,
Can anyone advise me, how can I arrange sheets in ascending order in excel
file?
Thanks in advance.
Regards,
Sanjaykumar
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group
12:17 pm, sanj <[EMAIL PROTECTED]> wrote:
> > Hi Friends,
> >
> > Can anyone advise me, how can I arrange excel sheets in ascending
> > order?
> >
> > Regards,
> > Sanjaykumar
>
> >
>
--~--~-~--~~~---~--~~
Visit t
Hi Keyur,
Yes, you can select the column which you want to hide and to go to Format
Menu --> Column --> Hide.
On Mon, Jan 5, 2009 at 4:56 PM, Keyur Shah wrote:
> hi,
>
> Can anybody guide me how to hide data in column sothat no one can visible
> and i want to lock sheet that mouse pointer m
