Our consultant said to replace our tapes after 6 months(24 backups). The HP site says they are good for 100 backups.
That is a huge diference!
Any recommendations???
Joe
I can't "paste special" when I "cut", only "copy".
I have cells with different colours that when I move contents of a cell, I only want the value to move, not the colour of the cell.
I have 18 rows of light grey row,2 rows of yellow, 18 rows of dark grey, 2 rows of...
Skip:
Nice suggestion! I never thought of it that way.
I have been compiling many workbooks into one with many sheets. Maybe I can do it in one sheet or two.
I will try it.
Thanks,
joe
Thank you TonyJollans.
That is exactly what I want.
I know it is a crude way and the workbook is not very efficient, but this will work for now.
Thanks again,
joe
Sorry, i'll try again:
As I enter data into a row in any sheet between sheet 1 and sheet 20, I want that row of data copied into sheet 21.
Yes, the ranges are fixed.
A little background:
Each sheet contains a one week schedule. As product is scheduled, it is entered in the correct week(sheet)...
Is there a way to copy 20 rows in 10 columns on 20 different sheets into 1 sheet in the same workbook without code?
(Did that make sense?)
I don't know VBA yet.
I want to highlite a cell if that cells date is equal to or less than todays date plus a week.
I am trying to use conditional formatting using TODAY()+7, but is not working.
Any help would be greatly appreciated.
Sorry, I wasn't very clear.
I have one main database where everything is entered. If column "A" says "Ken" then copy the whole row (10 columns) into a worksheet named "Ken". If column "A" says "Mike" then copy entire row into worksheet named...
Is there a way to automatically create a link when I type in a name?
ie: Everytime I type in "Ken" I want the name to become a link that when clicked on opens another worksheet?
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.