Hi All,
I need to compare two workbooks for a quarter over quarter analysis that are identical in size/formatting however some of the numbers may change. What I'd like to have is 1 workbook and have a 1Q21 tab and a 2Q21 tab side by side and apply a conditional formatting to 2Q21 which will...
Hi! so I'm very new with Vba in excel. i have a code that sends specific data (from excel files) to an access database. i wrote a code that loops through several hundred files and sends this information. The problem is to manually update these files, it is sent with a button. I need to override...
I really need some assistance if someone could help...likely really easy for you guys.
I have been searching for examples I could use for 2 days...
I am trying to use VBA to copy data from multiple worksheets within a workbook to a worksheet called "Data" within the workbook.
- copy multiple...
Hi
I have linked a range of cells on one worksheet in the same work book to another sheet in the same workbook but I have lost all the formatting. Is there a way to preserve the formatting? I am using Excel 2007 and conditional formatting.
Trying to put together vba to compare the "parts" sheet to the "orders" sheet (both in same workbook).
Specifically compare COL B of "parts" sheet starting at ROW 8 to COL P of the "orders" sheet starting with ROW 5.
If match IS found, do the following copies from "parts" sheet to "orders"...
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.