Hi Gurus,
Good day!
I just want to consult if there's a VBA way to combine the data (get the sum) of specific accounts?
For example I have long list of data but need to combine the total data for Math & Science. Note that there are negative numbers sometimes and Reference 01 is the main...
I know this has been asked a thousand times, but my case is a little different. I have a workbook with a master sheet and then a sheet where people make updates to the data provided from the master sheet. Sometimes they add rows and some times they remove rows, change data in row cells etc. the...
Hello,
Is it possible to auto fill a chosen cell between cells in a row and prevent it to be duplicated from the previous/after cell, based on change of status?
I want $I$7 to interact $C$7, therefore after filling $K$14, it will auto transfer from $I$7, and $I$7 will be blank & so on...
Hello! I have a mega forecast that people update and I'd like to make it simple to see which cells have been updated (could be added as a new line or info deleted or changed in a cell).
The model already has lots of conditional formatting indicating various things so it needs to work on-top of...
Hi there!
I am trying to do this way (https://www.excel-easy.com/examples/compare-two-lists.html) to compare in VBA but I can not get the same result as when I try it manually.
Hi all,
I have an Excel spread sheet setup to display departmental compliance with certain criteria, and at the moment I have conditional formatting to show the cell as red when it contains "n" and green when it displays "y".
What I would like to do is show also when a cell has been changed...
All,
Good morning, obviously looking for a bit of help here so I will try and be descriptive as possible.
I have One Spreadsheet bringing in data from two different locations.
In each of the linked spreadsheets There is a unique number in both documents ( a Construction Drawing number...
Hello All,
I'm not an Excel genius by any means, and I know enough VBA to get me by. I have a quick question for you all and I hope it's an easy solution. I work for a marketing agency where technical savvy-ness is really limited. We analyze a lot of web page elements. I have a program that...
Hi,
I am running a macro to make some changes to certain cells in a spreadsheet (formula changes)
Is there a code I can include within the macro so that all cells that change are also highlighted in yellow?
I am completely new to VBA. I have 2 worksheets of the same size (about 4000 rows), cells containing either text, time or date data. I need to compare the new worksheet with the old and highlight anything that has changed on the new with a different colour. I currently do the exercise in...
Version Excel 2007
We distribute a report to many users. The users edit some of the cells and return the report.
Question: How can we have the modified cells automatically highlight when edits are made?
We want to be able to view all edited cells at a glance.
Thank you for your help....!
I'm trying to find code (I can't write my own yet) that will highlight any cells that have been changed with fill color and bold font. I've searched around the forum and come up with the code below so far. It's not working - when I make a change to a cell and hit enter, it highlights and bolds...
I am trying to use the track changes option. I have a multi sheet workbook and want to track changes in different cells on each sheet. However I cannot figure out how to enter these references into the Where: option of highlight changes. I can select one sheets cells, as soon as I enter a second...
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.