kindly

  1. A

    Edit textfile vba

    I have this code that creates a file with the Current Date and Current Time. (along with other info) I would like to know how can I update the file with the Current time only? Can I request of assistance. Thank you kindly. Open OPath & OFile For Output As #1 Print #1 , Date...
  2. R

    div error % formula

    Morning , I have the following formula within a cell that is formatted as % =1-(AA63/T63) Until I populate the cells included in the formula I returns div error (as you would expect) I am at a loss as to how I can "if error" this formula , can someone kindly help me out ? Thanks Russ.
  3. H

    Use ampersand to change year in formula

    I have the following formula =INDEX('[Sales Report2019.xlsm]Sales by month'!$A$11:$N$11,MATCH('[Sales Report2019.xlsm]Sales by month'!B1,'[Sales Report2019.xlsm]Sales by month'!$A$1:$M$1)) I have the year in Q1 I would like to use an ampersand to combine the year in the formula with the...
  4. J

    customer wise month wise report

    Hi Very Urgent and very necessary. Please someone reply Kindly some one please help me to make month wise and customer wise report from a unsorted data with Pivot Table or Macro. sample file link attached here https://www.dropbox.com/s/cdl5r9k24f6banb/Sample.xlsx?dl=0 :confused:
  5. A

    how to select a cell based on the cell value(cell address written in a cell)

    Dear Team, i am new in VBA using macro by record macro only. Kindly help to correct the below mention VBA code. I want to select a cell in sheet1 based on the cell value in sheet2(cell E3). E3 contain the Cell address of required cell selection. like in below macro address is "A10". but it...
  6. M

    Possible outcome results of 8 soccer matches for 'home', 'draw, 'away'

    Yes I understand that the total number of possible outcome results is 6561. But how can I get there? Any formula in excel? Kindly assist. Thank u
  7. A

    Excel range save as image

    Kindly support to guide about can save excel specific cells as image to a folder .
  8. H

    Power Pivot Formula not working

    I have tried to set up a formula on Sheet4 to compute the Net Value in Col G (it is the value in Col E-Col F eg E2-F2) it would be appreciated if someone could kindly assist me...
  9. R

    Excel Hierarchy

    Hi Please do kindly assist me, I would like to know if it is possible to use a single drill down and drill up function to update all the charts in my work book? if so please kindly guide me on how to get this done.
  10. A

    Auto Filter til last row

    Need help with this code to find last used row and filter. Thank you kindly Range("A14:Q100").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=Range("AT14:AV15"), UNIQUE:=False
  11. U

    Filter Formula

    Using Filter formula in excel, message appears This function is not valid. Kindly help
  12. G

    Protect Multiple Sheet at once

    Hello Is it possible to apply a vba protect multiple sheets at once? (I have the VBA already - kindly supplied on this site) Thank you
  13. A

    Report page break

    Can we set page break in access if yes kindly guide about it Thanks in advance ?
  14. A

    Get Option Quote

    I would like to retrieve the Option Price last quote from Yahoo. Writing a vba code to retrieve this information from a website is far beyond my novice abilities, so I would like the kindly request from the VBA community if you could offer a vba code that would accomplish this task. The url...
  15. N

    Formula

    Dear Sirs Good afternoon , i m working on term loan sheet with moratorium period only the interest will be paid first and after couple of months will start paying Principal and Interest Kindly advise how can i use the excel to prepare a formula for that . Thanks & Regards Najib ABboud
  16. A

    Sumproduct calculation vba

    How can I use this formula in vba... =SUMPRODUCT(--(TEXT($D$15:$D$1001,"mmmmyyyy")=$S23&T$14),$P$15:$P$1001) Thank you kindly
  17. A

    Need to concatenate with last rows

    Hi , I need to concatenate Row C value with its last cell value one another one in a below format and paste the output in Row D. Multiple files I have, so the number of rows will increase for each workbook. For Eg: C D 001 0001 OF 0005 002 0002 OF 0005 003...
  18. r1998

    use cell value as an operator in excel 2003 formula

    Dear friends and respected seniors, In excel 2003, i have this data in cells a1 = 1 b1 = + c1 = 2 In d1 i want calculation of a1 and b1 and c1, so answer in d3 must be 3, because 1+2=3. Similarly if value in b1 is -, then d1 must become -1 because 1-2 = -1, but I am not able to do it :( I tried...
  19. D

    Extract specific part of a text

    Hi, FXD (Dept.014865) I would like to just have 014865. Please note: - I need a formula for about 15,000 rows - the only consistency is after the "." hence numbers and ) - I do not want the ) & FXD changes up to 10 letters Thank you kindly,
  20. xlhelp15

    To sum based on the condition

    Hello All, Kindly help me for the below query which I need in the way of Excel-VBA. Here column A - is the serial number and I need to sum the values of Column C (56+44.01+33.20 = 133.21) and provide the value in Column D in row 1. Likewise, it needs to sum automatically for the Serial numbers...

We've detected that you are using an adblocker.

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.
Go back
Back
Top