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...
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 =...
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...
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...
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...
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]...
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...
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?
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...
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...
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/
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...
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...