1. S

    Sharing Excel Spreadsheets with Macros via Microsoft Teams

    Is there any information available on if it is possible to create an Excel Macro enabled workbook via Teams to allow for multi-user collaboration and updating? I attempted to create this using O365 Forms however with the standard version, there are limits for things like drop down lists and...
  2. D

    macro from drop down list

    I have 4-6 marcos that i want to be able to choose from in a drop down list.
  3. C

    Help with Marco - how do I find and delete the whole row if value exists in both columns

    Hi, In Columns O & P I have values like below: <colgroup><col><col></colgroup><tbody> 0 R1177092 0 R1177093 0 R1177227 R1178634 R1178511 0 R1178185 0 R1178634 R1179555 0 </tbody> I need a Marco to find and delete the whole row , if the same values exists in both columns. For...
  4. C

    Help with Marco

    Hi, I want my macro to populate column 'N30:N30000' with my formula. However, for some reason it won't compile the macro due to ' Syntax error'. Any ideas how to resolve this: Sub FillDown() Dim strFormulas(1) As Variant With ThisWorkbook.Sheets("Sheet1") strFormulas(1) =...
  5. D

    Sort Data and total grouped data

    Sort data by one column then total by using sub totals in that colomnHere is my data: Description Seller Number Buyer Number Sale Price Commission Sales Tax Buyers Preimum Total Brown Riding Plush Horse 100 342 30.5 6.1 1.83 4.58 36.91 Blue Boys Mongoose bike 20" 200 200 55 9.9 Queen Purple...
  6. C

    Complete individual forms from unique list

    Hello, I'm an trying to figure out if this is possible, I believe it is. I have a form with attributes such as name, address, city.... and so on, that I want to fill out based on a data source with unique names and information. I want to input data on the data page and have the workbook pulled...
  7. J

    Do you want to build a spreadsheet?

    Do you want to build a spreadsheet? In Microsoft Excel, I think some macros are overdue, I’ve started talking to Senior managers on the Board! It get a little lonely All these empty sheets, Just waiting for a formula to appear Please, I know you’re interested, People are asking for your...
  8. C

    Excel automatically highlights row and column number when you click on a cell. How can I get excel to highlight a cell(s) in the same column and row a

    I am creating a spreadsheet for my job and it would be really helpful if somebody knew a code or any way to implement this into my spreadsheet. Thank you, Chris
  9. C

    need a cell(s) highlighted when clicking on another cell in the same row/column

    Hello, I am working a spreadsheet for my job in which I need certain cells in the same row/column to be highlighted when clicking on another cell. For example, if I click on D9, I want cells B9 (same row) and D1 (same column) to be highlighted a given color. I want this same rule to be...
  10. E

    Help with looping a recorded Marco

    I've recorded a Marco copying and pasting information from one cell to other cells and some of the copying functions paste to two cells. I just need this to loop through all information I'm copying from the the new cells. Range("I1").Select Selection.Copy Range("D1").Select...
  11. J

    Using Marcos to create financial statements from journal entries.

    I'm completely new with macros. I was wondering what you would need so that the information will automatically update itself onto a summary page. For example for entries on one worksheet to create a statement on another worksheet? Example: <tbody> Asset Type Description Date Amount OA Bonds...
  12. U

    Populate empty cells

    I have a spreadsheet that contains blank cells in a row (the entire row is not blank, just random cells). Is there a marco or formula I can use to automatically fill-in the random empty cells upon opening the workbook? I would like the blank cells to show "CANCELLED". Thank you for your help...
  13. T

    Add copy a new row

    Hi there, I'm having a little trouble and looking for some assistance. Basically on the top of my worksheet I have a button 'Add Record'. Once clicked I want the spreadsheet to copy the contents of lets say B7:Q7 (including borders and cell colours.) from one worksheet (Sheet 2) to another...
  14. C

    need marco to hide columns

    I have this spreadsheet that contains list of Events in Column D, header in Row 4. After participants responded, their initials are added to Column K onwards and in rows with different events, "x" marks the events they are interested in down the Column K. I created a filter in D3 that selects...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
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 "".
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