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

    Query to get data from CSV - very slow

    Hi All, I am using this code to get the data from csv file through query. It is taking around 5 min to run this macro. Is there a way I can expedite it as the data is not too heavy? Many thanks ! Sub Copy_CSV_Data() On Error Resume Next ActiveWorkbook.Queries("PairsRates5").Delete On Error...
  2. F

    Renaming worksheet not working

    Thanks
  3. F

    Renaming worksheet not working

    Hi All, I am copying activeworskeet in all the files in a certain folder. I want to rename the copied worksheet in the destination workbooks but it is not working. Can you please help where I am making a mistake? This is the code line: ActiveWorkbook.Sheets("Actual Receipts*").Name =...
  4. F

    Code help - macro to copy a worksheet to multiple workbooks without opening

    I tried but couldn't do it. Any help?
  5. F

    Code help - macro to copy a worksheet to multiple workbooks without opening

    Hi All, I have one worksheet that need to be copied to 10+ workbooks saved in a folder. I don't want to open the target workbooks for copying purposes. I have the following macro to copy the activesheet and can only select one workbook. Can you help me to increase the selection to multiple...
  6. F

    Formula / cell format help

    Super. Thanks
  7. F

    Formula / cell format help

    Dear All, I receive the excel files with date & time stamp for each entry in column B. I have to calculate difference between previous cell and next cell in column B (say B3-B2 so on so forth). It is giving me value error. I have tried to change the format if column B to custom formats but no...
  8. F

    Error in getting values from a sheet with macro

    It worked. Thanks
  9. F

    Error in getting values from a sheet with macro

    Thanks I will try
  10. F

    Error in getting values from a sheet with macro

    You are right. Can you help me to to add a line to change the above code after following line (that copies the "Data Sheet" worksheet from source file to current workbook) to copy from source worksheet range ("AH8:AK") to the copied "Data Sheet" worksheet in the destination file? Thanks >>> use...
  11. F

    Error in getting values from a sheet with macro

    Is there any way around?
  12. F

    Error in getting values from a sheet with macro

    Hi All I am using following macro to extract specific worksheet "Data Sheet" from all workbooks saved in particular location. Last 3 columns in extracted worksheets is giving me value error (these columns have sumif formula =SUMIF('[PC location of file] Summary'!C:C,E14,'[PC location of file]...
  13. F

    Screen updating message

    How can I hide them ?
  14. F

    Screen updating message

    anyone?
  15. F

    Screen updating message

    Hi All I am using following code to extract wks from different wbs with same name. I am still getting screen alert of update/don't update. Can you suggest the correction in the code to avoid the alert? Thanks Sub CombineSheets() Dim sPath As String Dim sFname As String Dim wBk As...
  16. F

    Instalment / payment plan creation

    Mant thanks Hui. It partially works. The problem arises at the end of 1% block it is doing 100%-sum(....) calculation, instead after the end of last instalment Mar 21 (screenshot below). Also, is there a way dates/months in column B are generated based on values in B2-B6?
  17. F

    Instalment / payment plan creation

    Hi All, I have to create instalment plan for apartment units sold The payment plan for each apartment sold is different as instalment plan differs for each buyer. Is there a way I can recreate the instalment plan based on inputs from row 2 to 6 to get output at row 12-19 ( I have attached a...
  18. F

    Referring to column in a macro

    Hi All,values I have following macro that paste range A7:AC76 from Sheet1 to "Summary" Sheet. At the end it copy the values from Sheet1 column M7 onwards and I have to paste special as values the copied data in column M of the Summary sheet. The problem is how to select the column M of first...
  19. F

    Offset Formula help

    Many thanks. I have a bigger range than I posted in the example. I need to figure out to tailor it for the formula to work.
  20. F

    Transpose data into another WS

    I have tried and found solution for transpose with OFFSET but still require help to apply it consistently. I have posted the question in Excel Formula forum. https://chandoo.org/forum/threads/offset-formula-help.44741/
  21. F

    Offset Formula help

    Hi All, I have to transpose data from rows to columns. I have used offset formula to transpose data in column C to rows starting in column E (please see highlighted in blue). Can you help me with two issues: 1. How to change the formula so I drag it to E2-G2...
  22. F

    Transpose data into another WS

    Hi All, I have installments paid by customers in horizontal format for each apartment sold that I need to convert to vertical format. The format for each unit is fixed containing 17 rows e.g unit 1 is from row 1 to row 17, unit 2 from row 18-34........................... I have attached...
Back
Top