mirror

I have a problem, want to mirror a drop down list on 2 sheets so that when one or other is changed they both change to that same value I have created the first drop down list using DATA VALIDATION from a table on another sheet. I have then gone on to my second sheet where I want the mirrored...

I have two separate workbooks. I'm wanting to use an Array Formula to search through the external workbook, find the column header header "Si" and populate all external column data into my local workbook. Can I use Index/Match or Xlookup for this?

Hi, I am trying to find a way to automatically do some formulas that I currently do manually. I think the only way will be through VBA which I kind of understand but not enough to do this. This is what I have. A B C D BOX 174a 100 mirror 174b 62 mirror 175a 51 51 A B 175b 33 84 B C...

Im using the mirror formula to consolidate data (=“sheet1”!A1). If theres no value from “sheet1” it will display as “0” on “sheet2”. If there a way just to leave it blank? ive tried vlookup and indmatch thanks in advance

My spreadsheet is designed to track whether our freelancers have accepted work. I want to track which work they have turned down. Each row represents a work offer, and I want to have a column which tracks which freelancers have turned it down. Is there a way to mirror this data on a separate...

Little bit of background: I have set up an excel chart that allows me to track projects that I'm working on and update the status as phases are completed. It is not really being used to calculate values just track data that I need to monitor and update as tasks are completed. This chart contains...

Hi, I have the following problem with my sheet: when I type in a cell I see a mirror image of another sheet in rows 1-14. This is very annoying as this comes every time I type in new data. However, the data is stored correctly, so it is only the mirror image which is the problem. The picture in...

to convert suits into mirrors as per table table= 0 1 2 3 4 5 6 7 8 9 example 75 the macro will see by the table 5 vale = 7 vale 2 and 5 vale 0 therefore = the pair mirror = 20 has to be guided by the table. if you have 9 it's mirror 4 and the other way around if you have 4 the mirror is 9

Hello! - My co-worker and I are stumped and could use a little help in solving our issue regarding mirroring a portion of a table to be poured into another sheet. Example: Sheet 1 contains the following columns which will need to be identical for many other sheets in the future. For now, I...

Hi all, I am building a taskboard on excel. I have built it so that the user can click/ tap to cycle through colors red, green, yellow in order to signify completeness of the task. this is on the master Sheet. I'm doing this by running the following macro...

Is it possible to make a cell in a sheet be exactly the same as another cell in another sheet without using =sheet!2A1, I need all the cells in a column to show whats on another sheet without having to input the function down to the 1000000th row. Then I need this sheet to automatically...

I am making a net worth TEMPLATE page that has about 9 tables in it which are refered to as headers using the conditional formating that looks like this: "header" value % invest Ameritrade jpc 50 mo 50 Edward Jones mwa 50...

I have data coming in that looks like: <table border="0" cellpadding="0" cellspacing="0" width="147"><colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:694;width:14pt" width="19"> <col style="width:48pt" width="64"> </colgroup><tbody><tr...