No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Hello all, I am trying to write a code. I need the code to do the following: An input box asks for a number, Then the below code divides values in a given column and paste them in the next available empty column. Then the 2nd formula runs and it … |
|
Dear all, I have the following macro and have tried a few things to make it run quicker but it still takes too long. the below code only runs on one column but i have 40 such columns. so all in all macro takes about 30 mins to run. Any … |
|
Hello, i am working on a macro where i need to copy data from a sheet to a different sheet in the same workbook. i normally use "vlookup" or "Sumif" or "Sumproduct" formulae to do the job. the datas is quite large and it takes ages to refresh the data … |
|
Hello, I am trying to write a macro to add a few headings. I have the following macro. Sub DOPaste() Dim i As Integer y =11 z = y Do While Sheets("Investments").Range("A" & y).Value <> "" i = 1 Sheets("Investments").Cells(z + 1, "D") = "Interim for year" Sheets("Investments").Cells(z + 3, … |
|
I am trying to create a macro which could copy information from a datasheet and past it into sheets which are named as one of the Cells in column A. I have a datasheet which contains five columns full of data. Column A contains the Client references. There are 200 … |