Thanks a lot
Now it has solved.
BIG SMILE
FROM
SAVLA
On Sat, Jun 12, 2010 at 12:53 AM, Paul Schreiner wrote:
> As I said:
> Use:
> Selection.AutoFilter Field:=ActiveCell.Column,
> Criteria1:=ActiveCell.Value
>
> --
> *From:* big smile
> *To:* excel-
Hi All,
I've some data in sheet1, people have to work on this data, i've assigned
the work to the concern people, now what i want a macros should be run and
then new files should be created ion the same folder in the name of assigned
peoples and those files should contain individual works that i'v
Swapnil,
One more thing, is it possible to know the cordinates, of where the
chart is located on the sheet and is it also possible to place the
chart according to our needs on the sheet?
Cheers
Harry
On Jun 12, 8:23 am, Harpreet Singh Gujral
wrote:
> Swapnil,
>
> Thanks alot for the post, i th
Hi Iqbal,
I hope the following would be helpful, i have copied the code from the
internet: (Before running the macro select the range of rows, you want
the macro to evaluate)
Sub DeleteBlankRows1()
'Deletes the entire row within the selection if the ENTIRE row
contains no data.
'We use Long i
Swapnil,
Thanks alot for the post, i think you have hit the right node, from
the two codes provided below, i think i will be able to solve my
problem
And thanks for providing an example sheet.
Swapnil: your english may be poor, but you have a great mind. Till the
time you can communicate the ide
Sub Macro1()
'
' Macro1 Macro
'
'
ActiveSheet.Range("$A$2:$T$13").AutoFilter Field:=2,
Criteria1:=ActiveCell.Value
End Sub
On Fri, Jun 11, 2010 at 7:02 PM, big smile wrote:
> Thanks
>
> But my problem is filter *the current cell by raw wise *
>
> I have try your option but i do not get
hey Paul,
Plz let me know how can I atleast display the data like '***'
See teh below message sent my Saurabh... using this we can hike the
contents from formula bar.
Just go to format Cell --> Protection Tab --> Check the hidden box and
uncheck the locked box. Then protect the work sheet.
@ Sau
Just go to format Cell --> Protection Tab --> Check the hidden box and
uncheck the locked box. Then protect the work sheet.
Regards,
Saurabh Patel
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Rajesh Bedse
Sent: Friday, June
Is the attached resolution you want?
Regards,
Saurabh Patel
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Steven Dsouza
Sent: Thursday, June 10, 2010 12:07 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Duplicates in Pivo
i need to copy a file from one folder, break links and save it in a
new folder with a new nameI am able to copy it and paste it in the
other folder but i am not able to break the links...
i tried using break links but it gives me an error.i am not sure
if i should break the links in the hom
If you have cell b9 selected,
do you want the value in this cell
to be used for the filter of column 14, or column 9
(the column of the selected cell)?
also, by using:
activesheet.Range("$A$3:$IX$681")
you're not allowing for any changes to the number of rows.
I would use:
Selection.AutoFilter
On 10 Jun., 14:14, Rod Urand wrote:
> Stuart,
>
> Thank you for going to all the trouble to build this. I do have a
> problem. I just found out that they are indeed free floating
> checkboxes that are not attached to cells.
>
> Are we just out of luck here?
Not at all, I was just using the atta
Hi Dears
Your kind help is needed. How to delete empty rows from a huge table. The
data is scattered in the table.
--
Have a good day!
Muneeb
--
--
Some important links for excel users:
1. Follow us on TWITTER for t
Thnx Paul,
Yeah.. it will display data in formula bar. I don't want to display
that.
Plz help.
~ Rajesh
On Jun 10, 10:58 pm, Paul Schreiner wrote:
> the problem is that you can change the cell formatting to make it LOOK like
> "***"
> but you'll see the actual value in the toolbar at the top,
Thanks for immediate reply.
My 2 nd question solved about print screen.
But to the main question still not resolved.
The problem is i want to filter full raw .
for ex. my cursor is on Raw No. 9 Cell no. B - i.e. - B9
I want to full raw to filtered .
but it does not work.
I have rewrite my m
Hello Ayush, are you still on the air ?.
On Fri, Jun 11, 2010 at 12:03 AM, ayush jain wrote:
> Hi Nikhil,
>
> Please keep group email in all your communications.
>
> You may send us sample data and we will prepare a pivot for you.
>
> Best regards,
> Ayush Jain
>
> On Fri, Jun 11, 2010 at 9:31 A
Dear Ayush,
As per your advise, here i am sending the excel sheet,pl help me to solve
this problem.
Thanks
Nikhil
On Fri, Jun 11, 2010 at 9:33 AM, ayush jain wrote:
> Hi Nikhil,
>
> Please keep group email in all your communications.
>
> You may send us sample data and we will prepare a pivo
Hi Ashish,
Thanks for the Help, It's really too helpfull for me, But
could you give just one more favour, I Imported the data on Excel N
data comes in N numbers of sheet, now I want to "Text to Colunm" of
First colunm (A:A) of every sheet so what the changes I have to do in
that macro.
Can you send me your sample worksheet?
I may be able to help.
I had to do something similar.
I used the top/left location of the checkbox to
determine the cell location to assign.
It's been a while, so I'll have to re-create it.
Paul
From: Rod Urand
To: MS E
19 matches
Mail list logo