ins

  1. N

    Keyboard shortcut for com add ins

    Hello everyone, does anyone know the shortcut keys to access the com add ins? I know the shortcut to access add ins in Alt+T+I but is there one for com add ins? I toggle between add ins frequently as some clash with others and need to be disabled so it would be great if there was a fast way to...
  2. V

    Delete Rows not <> to

    Hello all I hope you can help me on this please I want to change this code so that it delete all row NOT equal to "INS" instead of deleting "INS" Any ideas please arrWords = Array("INS") xlCalc = Application.Calculation Set rng = Range("c1:c2000") For rw =...
  3. Y

    Dropdown selection to unhide worksheets

    Hi everyone, I need some help and hopefully I can explain it clearly. I have an excel workbook that consists of 57 worksheets. I want to hide all worksheets but use a listbox to selected worksheets visible. HOWEVER....The listbox names are not exactly the same names as the worksheets. Due to...
  4. R

    Conditional format- is it possible to...

    Hi All, I have a fairly complex spreadsheet and I use a lot of conditional formatting. The issue that I have is that I don't always know why the condition is true indicated by a hi-lighted cell. I would like to hover over a cell and see a message explaining the condition. Are there plug ins that...
  5. P

    Auto Insert Rows based on Value - Mismatch 13 Error

    Hi - I'm trying to run the below code so I can auto insert rows based on the value of column B. The data looks like: <tbody> String<o:p></o:p> Rows Needed<o:p></o:p> 1003<o:p></o:p> 0<o:p></o:p> 1004<o:p></o:p> 0<o:p></o:p>...
  6. sleek12

    Approximate match in columns to merge along with amount

    <tbody> Debtor Amount $ X Insurance ltd 5800 X Ins. Ltd -480 X Insurance Brokers Ltd 4700 X Ins. Brokers ltd -950 Y Enterprises 8900 Y Ent Ltd 950 </tbody> Objective: I have fuzzy logic in my excel but it compares 2 columns , but i have inexact data in debtors...
  7. A

    Power Pivot

    I have office 365 Home & Student 2016. In my Excel I couldn't find power pivot add ins. How can I activate it or use power pivot in Office 365.
  8. E

    add ins

    I hope to provide with more useful add-ins to Excel thanks in advance
  9. A

    Excel Power Pivot for office 365

    I am unable to get add ins for power pivot in Excel 2016 office 365. I tried my level best but couldnot fix the problem. Please tell me how should i get power pivot? Its not available in the add ins.
  10. R

    Lines with data need to become multiple lines with only 1 entry pr line for import in ERP system

    So... i have a sheet with a lot of lines and for each line I have between 0 and 5 information's (one in its own column) i need to spread out so only 1 column. Eksample: <tbody> Order part1 part2 par3 Numbers S001 X x 24 S009 x 10 S011 x x x 15 S115 10 </tbody> This i need to...
    • Rygaard
    • Thread
    • autofill cellsn from multiple rows to 1 ins macro
    • Replies: 8
    • Forum: Excel Questions

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