I just created a thread but seems its gone.. so re-writing.
What I am trying to do is make a range which will be mirrored in two different sheets.
That is, they accept input which will be reflected in either of the range I specify.
For example, if I put 123123 on Range1, it will be shown the...
Hi guys.. my very first post to this site
What I am trying to do here is making a two way input range in two different sheets
That is, if I put anything in "A:A" Column(or specific range) in sheet1, it will appear on sheet2 "C:C" column(or specific range). Also, if I revise it on Sheet2 range...
So i already understand the function of mirroring cells into another sheet, but for what I need I need each cell from one sheet to be mirrored into another sheet but appear 3x in that column
so for example
Sheet 1: Sheet 2:
Apples...
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...
Hi!
Does anyone have a solution on how to fill a value upwards until a new value appears? (and then repeating the procedure after the new value)
I know this can be done downwards with "find -> blanks, entering a formula and then ctrl+enter" but I cant figure out how to make it work upwards...
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.