same workbook

  1. E

    Conditional Formatting within same workbook but comparing different tabs

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

    Replace or override sub code

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

    VBA Copy Paste

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

    Linking a range of cells from one sheet to another and preserving the formatting

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

    LOOK UP and COPY to Diff Sheet Within Same Workbook (vba)

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