I have a list of direct debits,
sometimes I need to edit or adjust the amount i'm paying for one or more of them for that month
I need a macro that can ask me which ones I want to change and by how much and then add reduce the following months amount by that amount?
So here in...
I was wondering if it's possible in Excel to automatically rank numbers from highest to lowest? So in this example, you see that the numbers go from 5 to -1, but if I were to change the -1 to 6, Excel would automatically change the list so that cake is first, candy second and chocolate...
Previously, I have done an Advanced Filter query, with the Extract in the same Workbook, and:
1.) Sorted the Extract
2.) Made some changes to the Extract
Sometimes this had a bad effect: With whatever change I made, it did the same thing to the rows above and below it - unwanted changes
I am new to board and dumb, hoping someone would share a simple VBA code
I have a large table of data of ~10000 rows.
I'd like VBA Code to loop through:
1) evaluate data in column A for cells that contains 5 characters ending in letter "X"
2) If it finds such, I'd...
I am downloading data from JDE in excel and dates are appearing like as follows, how to change them to normal DD/MM/YYYY ?
I have a formula using the INDIRECT function to reference the name of the tab indicated in cell A11. This formula works and pulls in the indexed value in column G on that page. What I'd like to do is copy this formula across several columns and have the referenced index column change to H:H...
I am new on here and have a small problem. I want a command button to copy a range of cells and past somewhere else on the sheet. Simple enough I know, but if I have range("A1:A10") no problem, but I want range(A1:A&H1). I know this won't work, but I want the value to change to...
I have a worksheet with a column with date and time that I get from our IT showing all incoming and outgoing calls. The date and time column is formated to show Aug 30, 2019 7:15:22PM. I want to change the format to be mm/dd/yy hh:mm. When i highlight the column and go to custom and format the...
Hope someone can help
I am trying to change the calculation returned in 1 cell depending on the entry of "X" in another
If an "X" is entered in I2 run the calculation in Worksheet1 - =IF(I$2="x",LOOKUP(AY5,'1'!A$3:B$65)+1)*AY5
If an "X" is entered in J2 run the calculation in Worksheet2 -...
Good day all
I need help with a MS Word form. I've searched all over the net and followed everything I've seen (I think) and I'm still stuck.
I have a word table that I want people to fill out as a form. but I don't want the person to be able to change the forms layout. Specifically the height...
I like to have all my spreadsheets as Arial size 8, many spreadsheets I receive from colleagues and clients as different sizes and font and I just change manually by highlight all and edit.
Should I just use a macro and shortcut key to change this or can anyone suggest a better way?
I have my format control to change by week stating for 2019 and it runs to week 52 but i want that to change in 2020 to start week 1 thru week 52.
Control set to
Minimum Value: 44 i started with the data for week 44
Maximum Value: 52
Incremental Change: 1
Page Change: 3
Cell Link: Calculation!$A$2
I have a workbook that gives me a number depending on cell color using Define Name. I named it GetColor. I used a previous post in MrExcel to do this. When I change the color, the number does not change automatically. What am I doing wrong?
This is what I am using...
I have a range of cells with values inside. The values have pattern such as '123-abc'. Now I need to change the value of selection to just 123.
I currently use left function to loop over the selection. But it's very slow because I have 1000 cells.
Ok so a bit of a strange one i'm doing a Billing cycle that shows how much is owed but i need to be able to adjust the amounts and could do with a macro to help.
So I have three ranges we take to take into account.
AC10:AC26 is my indicator for what we are goig to change.
I am looking for help to change a row of cells color based on a date.
Here is the problem:
If a person is to leave a job on a future date (X) and I want the row of cells containing that persons data to change colors based on how close today's date is to that future date.
If the future date...
I am having an issue performing a mass update on url addresses within excel.
I have a macro embedded spreadsheet that contains a list of url links to file folders. The purpose of the macro is to select each folder individually and email out to the relevant person.
The root file...
<button class="js-vote-down-btn grid--cell s-btn s-btn__unset c-pointer" title="This question does not show any research effort; it is unclear or not useful" aria-pressed="false" aria-label="down vote" data-selected-classes="fc-theme-primary" style="margin: 2px; box-sizing: inherit; font-size...