• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    Open an excel from word and filter a particular column automatically [SOLVED]

    FYI the below link helped me how to assign a macro to text in word document. http://word.tips.net/T001571_Assigning_a_Macro_to_a_Button_in_Your_Text.html
  2. A

    Open an excel from word and filter a particular column automatically [SOLVED]

    The above code worked....Thanks Colin. Jason, Yes it can be added. But, as I mentioned in my previous post, my document has multiple sections and the excel has lot of content in it. I just wanted to give the user a feel that when he clicks on the link in a particular section, he gets only...
  3. A

    Open an excel from word and filter a particular column automatically [SOLVED]

    Sub recordreference() ' OpenExcel Macro Shell ("C:Program FilesMicrosoft OfficeOffice12excel.exe ""DoctorReference List.xls""") Worksheets("Patient").Select ActiveSheet.Range("$A$2:$CZ$65535").AutoFilter Field:=65, Criteria1:="US" End Sub The above code gave a compile error message...
  4. A

    Open an excel from word and filter a particular column automatically [SOLVED]

    Hi, I have a word document with multiple sections in it. The detailed specifications of each section is available in an excel sheet. As there are multiple sections, each section has different specifications. The excel has many columns, out of which one column indicates the section name. All...
  5. A

    Reference to newly created Pivot Tables every time in a normal table [SOLVED]

    Sheets("Report").Select Columns("D:D").Select Selection.Replace What:="'Sheet1'!#REF!", Replacement:= _ "'Sheet1'!$A$3", LookAt:=xlPart, SearchOrder:=xlByColumns, _ MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
  6. A

    Reference to newly created Pivot Tables every time in a normal table [SOLVED]

    I used the location but not the name of the PT. =GETPIVOTDATA("ABC",'Sheet1'!$A$3,"product",'Report'!C5) A macro creates 3 pivot tables in the worksheet by name "Sheet1" The report is in worksheet "Report" Before the 3 pivot tables are created, the macro deletes the content in entire...
  7. A

    Reference to newly created Pivot Tables every time in a normal table [SOLVED]

    Hi, I used macros to create 3 different pivot tables in a one worksheet. I created a normal table which is a form of report whose calculations are based on the data from these 3 tables. Both these worksheets are in the same workbook. I used GetPivotData to refer to these pivot tables in the...
  8. A

    Excel Macro: Closing the Source workbook after Copy Paste [SOLVED]

    Hi, Requirements: I have a workbook by name Source with a worksheet by name Data. It has columns from A to E, but I don't mind how many rows and columns it has. I have a workbook by name DestBook with 3 worksheets - Dest1, Dest2, and Dest3 Purpose: Delete the existing contents in the...
  9. A

    Create pivot table in an existing sheet

    The source is an excel sheet which has exactly 5 columns as required for building the 2 pivot tables. First row carries the header data, which is essential in building the pivot tables. Some times the source Data ranges from A1:E3500. Sometimes the data extends beyond this range. User...
  10. A

    Create pivot table in an existing sheet

    For the Dynamic Table issue, I need to copy paste the entire data from a database to the existing sheet "Input Data". Saying that, I need all the columns for a row, but not part of the row. Considering this case, I "think" creating a dynamic table is not a feasible solution. Please let me...
  11. A

    Create pivot table in an existing sheet

    I'm able to generate the Average function for the "New Unit Value" Datafield. Thanks for the suggestion.
  12. A

    Create pivot table in an existing sheet

    Thanks Jeff for sharing valuable insights. I made changes to the code. Shown below is that: -------------------------------------------------------------------------------------- Sub MakePivotsAdvanced() Dim DataRange As Range Dim Destination As Range On Error GoTo errhandler...
  13. A

    Create pivot table in an existing sheet

    Thanks Jeff. I tried giving the exact range and also creating a table and giving that in the range. Still the same error. ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= "Table1", Version:=xlPivotTableVersion14).CreatePivotTable TableDestination :="Sheet1!R1C1" The...
  14. A

    Create pivot table in an existing sheet

    Hello, --------------------------------------------------------------------------------------- Purpose: Using a macro, I would like to create a pivot table from input source; but in an existing sheet ---------------------------------------------------------------------------------------...
  15. A

    Unable to get PivotItems property of the PivotField class [SOLVED]

    Thank You! This helped me resolve the error. Appreciate for your help
  16. A

    Unable to get PivotItems property of the PivotField class [SOLVED]

    Hello, I did a search for this concept before posting it here. I'm new to VB and don't know much about the programming concepts. However, by recording the macro, i'm able to modify a VB code for creating a pivot table in an excel 2003...
  17. A

    Hello .. Introduce yourself

    Hi All, I know some excel stuff, but started practicing VB recently to write some macros. I'm here to share my knowledge and learn from others.
Back
Top