change

  1. T

    If statement to seperate transactions by currency

    I am trying to build a spreadsheet to keep an accurate log of transactions, profit and current balance of 3 currencies. However I need help trying to segregate each transaction to only affect the balance of their matching currency. Here is what i have so far. So the goal is if for example...
  2. T

    Macro to pull all amounts into a message box or userform and ask me which ones to edit etc

    Hi Everyone, 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...
  3. L

    Automatically rank list based on numbers from highest to lowest

    Hi all, 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...
  4. S

    Advanced Filter query - What are the rules with editing the extract?

    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 Other...
  5. B

    Conditional change: Change value in a cell based on specific text (ending in "X") in another column

    Hello Board, 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...
  6. S

    How to convert date

    Hi, I am downloading data from JDE in excel and dates are appearing like as follows, how to change them to normal DD/MM/YYYY ? 118362 119002 119246 119273 119316 <colgroup><col></colgroup><tbody> </tbody>
  7. pliskers

    INDIRECT formula with Relative Column References

    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...
  8. B

    using a cell reference in a range command in VBA

    Hi everyone, 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...
  9. F

    Formatting column with custom date format

    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...
  10. D

    Multiple formulas in 1 cell

    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 -...
  11. T

    Help with Word Table

    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...
  12. B

    Arial size 8 as default. Should I use macro or is there a better way?

    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?
  13. L

    Format Control

    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
  14. C

    Cell Color

    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? =GET.CELL(38,Sheet1!$B$2) This is what I am using...
  15. M

    Getting cells to reflect/mirror changes made in another cell.

    Cells: B2, C2, and D2 are the cells. Values: 19, 7, and 12. If I add 1 to 19 and make it 20. I need 12 to change to 13. If I add 1 to 7 and make it 8. I need 12 to become 11. Possible? How?
  16. V

    Is there any way to change range's values more efficiently than looping?

    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.
  17. T

    Macro to change amount of next bill and carry it forward

    Hi Everyone, 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. Z10:Z26...
  18. J

    conditional formatting or formula to change cell color

    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...
  19. M

    Need to change XLSTART location

    My company has completely locked down the C drive of my new laptop. I cannot copy my macro workbook to XLSTART. Is there any way to change the location of the XLSTART folder?
  20. M

    Hyperlink url changes - mass change

    <tbody> Hi 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...

Some videos you may like

This Week's Hot Topics

Top