cell text

Hello, I'm trying to create a Macro that can find all sheets in my current workbook that contain the word "Closed" in cell J8, and collectively move them all to another workbook. I've figured out how to move one sheet (the active one) at at time but am struggling to move multiple ones. From...

Hi everyone, I have a worksheet called DATA TABLE which has some 30+ columns. Located in column A is the specific site name. I have another worksheet called DATA AMEND which I am able to populate specific cells with information from DATA TABLE. I wish to then alter any of the cells in DATA...

Hi, I have this offset function working: =OFFSET(calculos.xlsx!_5260;10;5) The cell name "5260", is also entered as text in cell A1, in the current workbook (not calculos.xlsx). How do I refer excel to get the text from cell A1, instead of having to enter it manually. Thanks, Pedro

I have an excel file like the one contained in the link below: https://docs.google.com/spreadsheet/...kJEdEZDejRTbFE I want some VBA code (perhaps using the 'Replace' function) that changes the text in column A to one line rather than having new lines e.g. in cell A2 'Quick Turn 8; 10 8...

I need a chart that will allow me to use a formula as a range... or a reference cell's result as the range. I have a cell with two MATCH formulas that find an item code in column B, and then provide an ordered date range from another column and displays the following: 'Data...