Search results for query: *

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.

Thanks Jonsi. The solution was easier than I thought. Just not thinking about it the right way. Thanks again. joe

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.

Thanks MisterC for the tip. You gave me a few things to think about also. This should keep me busy writing the code. j

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

If A2="Mike" then copy entire row into this workbook. Is this possible? thanks

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