Hello,
It has been a very long time since I have posted on here, so I apologize in advance if I am rusty on any preferred protocol and information/data to include on a post.
I need to be able to able to obtain the average daily balance of each case, for each quarter. Since I have not found a...
average daily balance
daily balance
dynamic columns
dynamic name
dynamic number of columns
excel
function
list.accumulate
list.generate
loop
power query
repeat
running total
Hello,
I want to loop over all indices in a filtered column & do something for each indice each time, how can i do that please ?
Thank you in advance :)
Hi all,
I have the below data, in column L:
COLUMN L
1
2
3 AADDYE
4 FJGLLT
5 FJJDUE
6 FJGOTR
7 ADREWS
8 FSERTT
9 MBJGFR
10 FKOORR
I want the output as per below when I run the marco to be:
"AADDYE","FLGLLT","FJJDUE", - looping until the final data...
Hi All,
I am still fairly new to Macros and VBA however I am learning from Mr. Excel's 2013 VBA and Macros book. I am attempting to write a macro (see below) that will Loop through the current workbook sheet by sheet and find the specific text to derive Top of Range and Bottom of Range, deliver...
Would anyone be able to help me with the following VBA?
I've no idea of how to do it.
If D15 < K15, then increment Y15 value+1 (This would need to loop until the condition is met)
Then go to next row and check the same.
This would have to apply to rows 15 to 44
Thanks
Dear Mr Excel
I would be so grateful for some help with this.
I have 4 Sheets that contain data that i am trying to write a code for.
MessagesSheet (Which is named "replies" followed by "date" and "time"): This contains text messages received. The data is organised as follows: Each row...
Hi to all.
Got 1 problem(for now :eek:) cant figure it out.
got row data on the left side (filled rows)
if row (column A4) is not empty > copy row (formulas and conditions) F1 (from column BJ to GK) behind (after BI column)
loop till last row.
Would be grateful.
Here is the scenario :
I have "n" Workbooks which get filtered and their data is copied to a "Master Excel"
I have created the whole process for a single workbook named "1".
But in order to replicate that process for the other workbooks (named 2,3,4....so on), I have to copy-paste the whole...
Hello everyone!
I'm looking for some help on how to go about making a code to Loop a file with 3 tabs and then copy, paste, and save another spreadsheet with the data. To be more specific I'm trying to do the 4 things below.
I would like to have the code in an excel (called "Data") that will...
Hi folks,
I am unable to figure out how to solve the following problem.
I have a working loop that runs down a list of names in column B (Account) and retrieves data from individual account workbooks on our network (quite a few) and puts them on the main sheet like below.
My problem is that...
Hi folks,
I am not very versant with chart objects and keep getting stuck with the following problem. Thanks for your help!
I have put a simple version of a minisheet below with data. I could not figure out how to capture the charts in the minisheet so an image of the "desired result" is...
Hi folks,
Is there a way to auto-fill laterally across columns like there is down rows perhaps using a macro?
I was thinking this might be handy in some instances I've run into, but I'm not sure how to make the ActiveCell part work.
Sub FormulaFill()
'
Dim rng As Range
Dim y As...
Hello,
I have recently started to code a macro to help me repetitive data analysis with very few knowledge in coding languages.
I have came up with this code, the idea is that I import my data on the sheet "raw" then I select the different series of values and name them in a new sheet. Since I...
Hi! I need to loop through a dynamic data set, only the range in which the data are entered is given.
I need to loop through every cell and copy the value to the end of another column. I totally managed that for the first column but now I am stuck with telling excel to increment the row and...
Hello! I'm stuck with this for several weeks and that's why I'm asking for your help.
This code interacts with a third party application, sending values and printing documents from it.
It works fantastic, only for the small detail that with the passing of the iterations the cpu fan starts to...
I have two workbooks; one with data to be replaced (main workbook) and another where to find data to replace with (secondary workbook (converter) / two different sheets; product and subproduct).
In main workbook there is columns:
A: row_id = not to be touched
B: product_id = product code to be...
Hello,
I want to download the Stock list in one go with a loop when I refresh the page.
I want it to download every stock in the stock list to the "combine sheet".
----Combine sheet
1st share "C3",
2. Share "C163" ... I want to download as in the example.
----In the same way, I should...
Long time reader, first time poster!
I'm trying to create a Loop that names a sheet based on a cell value. If the sheet name already exists then the macro will pop up a message box with an entry field to enter a new name and that will Loop until the user enter a sheet name that isn't already...
Hello all,
New to the thread so I do apologies if this isn't sufficient.
I am trying to create VBA code for Index Match Match with a loop.
I have attached an image to help.
To detail the problem;
- Cells A4:C13 have permutations from myarray (1,2,3,4,7) where I want 3 numbers picked and...
I have a piece of code called "restoredataval" which i need to apply to certain tabs in about 15 workbooks all of which have a varying number of tabs.
What i want to do is open the file, select the tabs I need the macro to run on and then press run. The macro should then Run through each tab...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.