• 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. koi

    Delete Range if column A is zero

    Hi All, I have a range of data from A3:J100, and i need the code to delete range A3:E100 (can be lastrow as well) if it find zero on column A3:A100 basically something like below, but somehow this code doesnt work, Thanks for helping me Sub DeleteRange() Dim r As Long Dim LastRow As Long...
  2. koi

    Find lastrow & copy down

    Hi, I've managed to do it perfectly, please see below in case someone need similiar code Sub test() Dim i As Integer Dim FirstEmptyRow As Long Dim paste_range As Range Dim source_range As Range Dim LastRow As Long Dim UserInput As Long UserInput = _ InputBox("How Many Times?") 'you can...
  3. koi

    Find lastrow & copy down

    Hi All, I need help with how to find lastrow on sheet "temp" in column A, and copy it down how many rows according to number of input text box can someone help me on this? Thanks
  4. koi

    copy link from multiple sheets

    Hi All, nevermind the code works perfectly, only i have another sheet name "data raw" so the code also copied the data from that sheet Thanks All
  5. koi

    create new sheets and rename it based on lists

    Thanks All for the help, @Alan, the approach you gave me is giving me error and only add 1 sheet at the time @Fluff13, perfect solution, i can always put new name on "List" sheet A1 to A something....then run the macro, and it will create the list accordingly, meaning i can always add 10 names...
  6. koi

    create new sheets and rename it based on lists

    Hi All, I have 2 sheets named "list" & "template", on "list" sheet A1 is New1, A2 is New2 etc until A25 is New25 all i want is the macro to copy the whole "template sheet" and then create new sheet but rename the new sheet as as per "list" sheet A1:A25 and if I want to only create 10 sheets...
  7. koi

    copy link from multiple sheets

    Hi Chihiro, I've done some modification by adding helper range on data sheet, so the code only 1 lines like your original one, it works perfectly no matter how many times i run the macro...the problem is the macro start on A4 line instead of A3 lines, can you give advice on how to make it...
  8. koi

    copy link from multiple sheets

    perfect, Thanks Chihiro
  9. koi

    copy link from multiple sheets

    Thanks Chihiro, it works well for copy and paste as value, thumbs up ! another question, what if i have another sheet name "something" but i dont want to include ...i only need from data1, data2, ...data100
  10. koi

    copy link from multiple sheets

    Hi Chihiro, I also think about Indirect but then i have 100 sheets so I'm thinking the file could be heavy, basically I have "Summary" Sheet, where I need to make the link from A1:C1 refer to data1 sheet, and A2:C2 refer to data2 sheet till data100 example below : Summary!A1 = data1!C1...
  11. koi

    copy link from multiple sheets

    Hi All, sorry for this newbie question but i hope someone can help me to solve it, i have link in A1 like ='Sheet1'!$G$5, what is the fastest way to copy that link in A2 for ='Sheet2'!$G$5, and in A3 = ='Sheet3'!$G$5 ? i dont mind using vba as well if normal formula wont work, Thanks
  12. koi

    Copy X lines down, and paste transpose

    Thanks Marc, didn't read quite well that i supposed to put it in the sheet module, it works like a charm !! again thank you !
  13. koi

    Copy X lines down, and paste transpose

    Thanks a lot Marc, but i got error code: "invalid use of Me keyword" any idea why? or probably we need to specify the sheet name?
  14. koi

    Copy X lines down, and paste transpose

    Hi All, i need the macro to copy x lines down based on the input in helper column, and then paste transpose it to another cell. example in D2 the number is 3, then the macro will copy B2-B4 (3 lines down), then paste transpose it in E2:G2 then it search again in D2:D to find another...
  15. koi

    Error in get IE macros

    Hi All, I need help again for the error that i'm getting in the macro, everytime it happened i need to click on the yellow arrow and move up a bit, then click on continue so that the macro will run, and after it run..the error wont happen again. question is why it is happen on the first time...
  16. koi

    insert/embed pdf file

    Hi All, I need help on insert several pdf file into several excel file, can it be done by using names? i have excel files naming as : 1.xlsm, 2.xlsm, 3.xlsm, and i want to insert 1.pdf into 1.xlsm in the sheet1, 2.pdf into 2.xlsm in the sheet1 and 3.pdf into 3.xlsm can it be done like that...
  17. koi

    compare multiple text in 2 columns

    Hi Luke, if now i want to find the similiar things between A & B, with the sample above, can it also be done? Thanks
  18. koi

    compare multiple text in 2 columns

    Hi Luke, Amazing Job, you got it first time right, thanks a lot for helping me ! koi
  19. koi

    compare multiple text in 2 columns

    Hi All, hope you are all good and well, I have this most difficult task that i cannot solve, hope that you have the answer for it. example 1: in column A i have : I.like.eat.sushi in column B i have : like.meat in column C i would want it to say : I.eat.sushi example 2: in column A i have ...
  20. koi

    vba to write several closed book from open source

    worked like a charm!, cannot thank you enouh Chihiro !! THANKS
  21. koi

    vba to write several closed book from open source

    Hi Chihiro, i can tell that it is working, size of the excel file is changes.. but when i open the file, excel is open but the content is grey, what could possibly go wrong here? Thanks
  22. koi

    vba to write several closed book from open source

    Hi Chihiro, i agree with that, it can be open, write, save and closed without even appear
  23. koi

    vba to write several closed book from open source

    Hi All, just want to ask if it is possible to write several closed workbook, from an open source i.e i have 3 closed WB named as book1, book2 and book3 i have open excel file with 3 things from A1 to A3 that i need to write it to book1 A1:A3. then from open source B1:B3 need to write it to...
  24. koi

    sum last row in a range

    Thanks All for the helping, Hui solution work best although Narayank second one also works, regards, Koi
  25. koi

    sum last row in a range

    Hi Marc, can you give some more pointer? or example since all i've done with the recorder cannot give me dynamic rows if i adding more rows
Back
Top