sheetb

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

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

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

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

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

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

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.

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