marcos

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

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

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

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) =...

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

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

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

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

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

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

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

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

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

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