h10

  1. E

    Code needed for MAC Excel (latest version)

    This is what I want to do. Can someone help with code please. Not sure of the correct MAC syntax for the path, used to Drive letters in Windows 10 Select RangeA2 to I44 Use the filename that’s in Cell H10 Save as PDF to Path DATA1\DATA\DROPBOX\\BUSINESS\PDFINVOICE (Filename as in Cell H10)...
  2. C

    Loan Draw - Dyanamic Formula

    Hi All, I am wondering if I can enlist this forum's help. Can someone help me create a dynamic loan draw formula (highlighted row 10 in HTML table below) with the following constraints: - The loan cannot be overdrawn (i.e. cannot draw more from the loan than what is available). The ending...
  3. muhammad susanto

    VBA : Insert Pictures in Multiple Worksheet At Once

    hi expert.... this code work properly only for 3 pictures to inserted into 3 cells, but i want to modify how this code below work in n pictures (multiple pictures) then inserted only in cell H10 for each sheet.. Sub InsertPic() Dim I As Long Dim xPath As String Dim xShape As...
  4. H

    AND in formula in conditional formatting not working

    Good Evening everyone, I have two cells, lets say G10 and H10, with a formula (say =G4-(SUM(G6:G9) ) and the second cell is exactly the same formula but referencing the next column. Then in cell F10 I have a formula generating text based on the results of G10 and H10. All these formula are...
  5. T

    macro to put a cell value into the right place in a column

    Hi Everyone, thought this would be easy but I'm stuck for some reason. all it is is I have a sheet called "Invoices" In Cell G15 I have an Invoice Number in Cell H10 I have a ref number now in another sheet called "Records" I have a list of the Ref Numbers (Down column D), so I just want a...
  6. A

    Sum values across multiple spreadsheets

    Generic example of what I want to do: <tbody> 6640 X X 9360 X X 2712 X X 3214 X X 9512 X X X 8439 X X </tbody> When B1:B6 = "X", sum cell H10 from all tabs where value A1 = cell B8 on all tabs. So for this example, Sheet2 has cell value of B8 = 6640, so return cell...

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