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