• 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

    Run time error 1004 reference is not valid

    Hi Hui, I have already record the only that pivot part in 2007 version and below is the script ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "DataBase!R1C1:R5329C21", Version:=xlPivotTableVersion12).CreatePivotTable _ TableDestination:=""...
  2. A

    Run time error 1004 reference is not valid

    HI Team, This is A Pradeep Kumar from India, I like this site because I am learning new things about excel which helps me in my daily official worl. I am an employee in a private company. At present I am working running a macro in MS 2003 version but while running same macro in 2007...
  3. A

    Proportionately distributing invoices as per number of Associates

    Hi Team, I need your help in excel macro and I am attaching sample file in details, Here I have different Cuntry and Associates should work for different country. I need to allocate the invoices to associates as per their cuntry wise. Example: If in Mexico WE have 145 invoices and 4...
  4. A

    Get the address(column) of active cell

    We are really sorry for more confusion ,but hope the below detailed explanation would help you to understand the requirement of us. We have TEXT to be find in Entire row # 16 If the Text value which is "410" is found then we select that cell , from that active cell need that Column Letter...
  5. A

    Get the address(column) of active cell

    Thanks Sir for your quick response... But I need to know that... example:- I want to find a name "Pradeep" in a particular worksheet wchich is exist in cell D18. Here I want the result of that entire column no. with alpha numeric e.g; as in the preivious mail you replied dat "Activecell.column"...
  6. A

    Get the address(column) of active cell

    Good Morning Team, how to get the address(column) of active cell where active cell is not fixed, example : cell (A4)then we need the row = 4 & col =A . cell (G4 then we need the row = 4 & col = G . Regards, Pradeep
  7. A

    Macro Help for proportionately division of data by number of associates

    Hi Prasa, Yes you right but what I want is I run the macro in SAP that data will be extracted and i need to call macro (Excel) from SAP, the above macro which i metioned earlier comments. So I already run the macro for SAP but I am not able to run a macro in excel as per my requirement...
  8. A

    Macro Help for proportionately division of data by number of associates

    Hi Team, I am in problem to assign macro for below query; I have data of 300 line items and 5 associates are there. I need to allocate the data only 240 line item out of 300 line items among the 5 associates proportionately and rest of 60 line items to be deleted. Could you please help on...
  9. A

    Alphanumerical separation

    Hi All thanks for guiding me. Here is the real example in my daily work; Column A Ref:RP46799651130293,By order:/43662837 LAYOS SV,Pymt.Det:/RFB/EX25268614 Ref:5403102831049500,By order:/96851333 KESTREL LINER AG,Pymt.Det:/RFB/IM15622962 Ref:6202382332592900,By order:/03886484 B H...
  10. A

    Alphanumerical separation

    Hi Chandoo Ji, This is Pradeep, I have data wchich contains alphanumerica like invoice number,vendor name,systemid (e.g; fg21567 AT&T GP1) here AT&T is Vendor name. Like this I have huge data and I have to separate vendor name. Could you please help on this Thanks, Pradeep
  11. A

    weeknum formula in VBA script

    Hi I am Pradeep. I am trying to write a weeknum formula in VBA script bur it not recognise in VBA script while I run the macro. I am trying as =weeknum() which is not recognise in the excel macro. Is there any VBA script for this Weeknum formula in excel macro? Could you please help....
Back
Top