Hi All,
I have an issue with the pivot tables filter, as i need to change the filter
in as many as 10 sheets(20 pivot tables) to get the correct values.
Is there any way where i filter it in one page and the remaining pivots
change accordingly.
Appriciate an early solution from you.
Thanks in a
*Hi,
Please find the attachment for the given problem..
regards,
mathan
*
On Tue, Apr 21, 2009 at 9:26 PM, Geo wrote:
>
> I have data like this:
>
> part# location
> 1 1B-1-A-01
> 5 1B-1-A-01
> 6 1B-1-A-01
> 14 1B-1-A-02
> 12 1B-1-A-02
> 15 1B-1-A-03
> 83
Thanks Gents!
On Apr 21, 12:43 pm, Paul Schreiner wrote:
> In cells C2, use:
> =IF(B2<>B1,"start",IF(B2<>B3,"end",""))
>
> then copy the formula down.
>
> hope this helps,
>
> Paul
>
>
> From: Geo
> To: MS EXCEL AND VBA MACROS
> Sent: Tuesday, April 21, 2009 11
In cells C2, use:
=IF(B2<>B1,"start",IF(B2<>B3,"end",""))
then copy the formula down.
hope this helps,
Paul
From: Geo
To: MS EXCEL AND VBA MACROS
Sent: Tuesday, April 21, 2009 11:56:32 AM
Subject: $$Excel-Macros$$ Show the start and end of groups of cells
Oops.. just noticed that you want the column "D"'s value in sheet2,
Just change it to target.row,4 (D=4)
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If (Target.Column = 23) Then
Sheets("Sheet2").Cells(1, 1) = Cells(Target.Row, 4)
End If
End Sub
Paul
___
I may not understand all of your criteria, but I can get you started.
Excel has "events".
the one you want is the Worksheet_SelectionChange event.
Right-click on the sheet1 tab and select "view code".
in the VBA editor, in the top left box above the text area, use
the pull-down to select worksheet.
Dave,
Thank you for responding and for your code! I incorporated your ideas
along with Habeeb's (above) and my own ideas and came up with the code
below. If you see any room for improvement, please let me know, as I
am still very new to this coding.
Sub fillInTheRows()
Sheets("Raw").Select
Ran
Habeeb,
Thank you for your response! I have taken the concepts in your code
and the code in Dave's post below and I have come up with the
following. If you have any suggestions or see things that I could do
better in it, please let me know as I am still getting the hang of
this coding =)
Thanks!
Solution attached
On Tue, Apr 21, 2009 at 9:26 PM, Geo wrote:
>
> I have data like this:
>
> part# location
> 1 1B-1-A-01
> 5 1B-1-A-01
> 6 1B-1-A-01
> 14 1B-1-A-02
> 12 1B-1-A-02
> 15 1B-1-A-03
> 83 1B-1-A-03
> 16 1B-1-A-03
> 22 1B-1-A-03
>
> In
you wanted to copy all the text from pdf file to excel you images as well
if it matter of copy text in excel sheet with proper formating
you have to use 3rd party activex called SII_pdf and it will convert
PDF file to Text with Command line it means we can use it in our macro
anywhere in batch
Perfect. Thanks, Steve
On Apr 19, 10:32 am, Ashish Jain <26may.1...@gmail.com> wrote:
> Hi Steve,
>
> If we leave the weekend part, your problem is solved.
> You can use pivot table. Put work order in Row field and
> Count of Dates in Data field. Problem is solved (partially).
>
> For more tips,
Dear All,
Need ur help
i have data in Sheet 1
A B C D E F G H I J K L M N O P Q R S T U V W X
Y Z
1
2
3
4
5
6
7
8
9
.
.
.
.
.
.
.
.
.
1
is it possible if i click sheet 1 W1 then i will get D1's value in Sheet
2's A1 range
if i click sheet 1 W2 then i will get
Please go to the below link
http://www.macloo.com/examples/javascripts/alert.htm?testBox=yup&checkthecheckbox=Submit
go and try to click on button with you code , msgbox will display
after this macro does not do anything until or unless we did press it
so i wanted a code in which we get the text
I have data like this:
part# location
1 1B-1-A-01
5 1B-1-A-01
6 1B-1-A-01
14 1B-1-A-02
12 1B-1-A-02
15 1B-1-A-03
83 1B-1-A-03
16 1B-1-A-03
22 1B-1-A-03
In column C, I would like to see this:
part# locationStart/End
1 1B-1-A-01
Could you please send images in .PNG format instead of .BMP.
would be much more lighter in size, try it.
On Tue, Apr 21, 2009 at 12:47 PM, Ajay Varshney wrote:
> Hi,
>
> I have problem in using the given code. I am using two codes one for
> opening the pdf file and second for copy the data from
Sorry, I had the 5 formats set to give me a particular color if a
certain cell
was blank. After the blank rows, everything turned that color because
the whole
rows were blank, which isn't what I was after. So, my first attempt
was to have
a conditon to say if the first cell in a row was blank, to
Steve --
Excel 2003 is limited to 3 conditions
-- since you are talking about 5 or 6 conditions, you must be working
in Excel 2007, without these same limitations
Probably, your 6th rule is present - but, the Conditional Formatting
Rules Manager dialog is only large enough to display 5 rules
Passward is 123456
Thanks & regards,
|| Mudassar Ramzan | MIS Officer | WorldCALL Telecom Ltd | 061- 814-3999 | 0321
7325277 ||
- Original Message -
From: Prem Narayan
To: excel-macros@googlegroups.com
Sent: Tuesday, April 21, 2009 12:08 AM
Subject: Fwd: $$Excel-Macros$$ Re
Hi,
Can anyone tell me if there is a limit on the number of conditions you
can place on a cell? I've got 5 and actually need 6, however, when I
select apply, the last condition disappears.
Please advise,
Steve
--~--~-~--~~~---~--~~
Hello Ashish,
I am working on a solution for you!
But I still don't know how to attach a file in an answer.
I'm new in this group and I really want to help people with VBA
problems.
But before I have to know how I can attach files.
Best Regards,
Sergio
On 20 Apr., 15:51, Ashish got engagged
Hi Dustin,
Paste the following code into a module.
Sub InsertMissing()
Do Until ActiveCell.Value = ""
A = ActiveCell.Value
B = ActiveCell.Offset(1, 0).Value
If B - A > 1 Then
ActiveCell.Offset(1, 0).EntireRow.Select
Selection.Insert Shift:=xlDo
Hi Laxmikant
Yes, this is possible. Using VBA you can fill forms on internet, even
if it's https.
For more tips, tricks, downloads and problem solutions: visit -->
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst,
22 matches
Mail list logo
