sheeta

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’m hoping someone could help me with the tasks below; I know it’s a lot but Any help would be much appreciated. (#1-8 order matters) 1) in column AA SheetA any “0” change to blank cell 2) column AC SheetA some cells say “Fired - xxxx” , I’d like to change anything that doesn’t start with...

I have account numbers in E2 of SheetA . I would like to compare account numbers in SheetA to column E SheetB, column E SheetC, and E in SheetD. Then delete any rows in SheetA that matches accounts in SheetB, SheetC, and SheetD. Can someone help me with a code for this?

Thanks in advance for any suggestions and I will provide feedback. I would like to check if "SheetA" exists and if so archive it to where "SheetA" will be come "SheetA.01" and if both "SheetA" and "SheetA.01" exists make it "SheetA.02", etc. Sheet A will be located between "Start.SheetA" and...

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

Hi, i'm newbie on vba excel I would like to copy some range on selected sheet to another sheet, and defined the range with value from another sheet i'll give the illustration below : SheetA <tbody> A B C D E 1 100 400 700 1000 1300 2 200 500 800 1100 1400 3 300 600 900 1200 1500...

Hello, I have two sheets sheetA and sheetB with two names ranges rngA and rngB respectively. rngA in sheetA has one column and contains cell addresses (like, $F$6, $H$2, $G$3, ...) rngB in sheetB is say $F$3:$H$9 I need to delete cell addresses in rngA that are not in rngB. For example, $H$2...

1. I am wondering if Conditional Formatting by formula can be copied like a formula can to multiple cells. The reason I ask is... 2. I have conditional formatting to strikethrough a cell in SheetA when it equals another value in SheetA I also have a master list of all possible options 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.

Hi! I have a group of cells on sheetA which contain SUMFIS formulas connected to sheetB. Amounts are posted on sheetB and then the sums are calculated on sheetA. I have conditional formats set on the sums on sheetA to go red once the sums exceed a maximum amount. However, I also want to add a...

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