sheetb

  1. J

    MsgBox when a certain percentage is reached

    Hello there, SheetA is where a user can input a type of animal and labelit 1 or 0. The sheet is interactive and is in a list form where the user can continuouslyadd animals and labels. <tbody> Bird 1 Dog 0 Cat 1 </tbody>...
  2. J

    Refer current cell in other sheet

    I have two sheets, "SheetA" and "SheetB" Is it possible in SheetB to refer to the same cell in SheetA with the same code no matter which cell in SheetB you use the code? What I mean is in cell C4 SheetB not refer to C4 in SheetA by using =SheetA!C4 but rather by using something like...
  3. S

    Let PowerQueries don't have time to finish with VBA

    Hi I have a VBA script that is supposed to remove the protection of the sheets, update two PowerQueries and then re-protect the sheets. When I run my macro, the queries do not finish, which causes me to get errors in the result. I would like script to pause until the first query is finished...
  4. N

    Help to compare two sheets

    Hi all I have two sheet(A) and sheets(B), now I want to compare with three conditions and color row(j) in sheet(B) if wrong Conditions that: 1. Mid(sheet(A).row(i) = Mid(sheet(B).row(j)= "201808-5600" 2. Sheet(A).row(i,2) = "1011" 3. Sheet(A).row(i,3).value/1000 = Sheet(B).row(j,2).value How...
  5. G

    Multiply if

    Hi all, I have tried to check for solutions but in vain. Hopefully someone can help :) I have a 2 different sheet ("sheetA", "sheetB"). SheetA <tbody> ITALY 100 FRANCE 200 UK 300 ITALY 20 FRANCE 30 UK 60 </tbody> SheetB <tbody> IRELAND 2 UK 5 ITALY 4 FRANCE 8 NORWAY 3...
  6. C

    Possible IF formula help, trying to link data across worksheet

    I work in a medical office and am trying to track patient visits. I have One worksheet (SheetA) that has all the patient Names and demographic info in a table, and also includes how many visits that patient has been authorized to receive and a column with the number of visits remaining. In...
  7. L

    Merging 2 files in Excel

    Hi I wonder if it is possible to merge 2 excel files. Lets say I have a file called ABC.xlsx which has Sheet1 and Sheet1 and another file which is XYZ.xlsx which has SheetA and SheetB. Can I merge them to a new file called ALL-Files.xlsx which has Sheet1, Sheet2, SheetA, SheetB Thank you.
  8. 1

    Compare 2 spreadsheets and highlight differences

    I did a search for compare threads and there are numerous posts but I didn't manage to find one of the more simpler tasks covered - I'm sure they are hiding in there somewhere! If you can point me towards one that meets my needs or if you can suggest a solution via Reply post I'd be very...

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