mirroring

  1. G

    [VBA EXPERTS NEEDED] Mirroring columns to two different sheets

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

    Mirroring columns to two different sheets

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

    Mirroring Cells 3x

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

    Cell Mirroring? AND Automatic-autofill

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

    Autofilling values UPWARDS

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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top