Hi there,

Sorry to put you through that!

It's too much for me I'm afraid. There are probably some who can but who
are in bed at this moment.

I'll be watching for progress.

Good luck
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"First Aid Computing" wrote:

The First Aid Computing is my personal side-business doing computer
repair/upgrades/advice. However, I do not make enough at this job to survive
so I work full-time in a manufacturing facility and I try to keep track of
the jobs we are doing and how long they take as well as data about the jobs.
This is what my w/s is for. As I work overnights, there is no one on the IT
side of things that I can ask, let alone anyone here as I seem to know more
about Excel and other computer related tasks than just about anyone else here.

Here is the link tot he sheet.
http://spreadsheets.google.com/ccc?k...UlIc Hc&hl=en

Sorry it took so long, but I've never used GoogleDocs before (I try to stay
away from Google due to their privacy policies) so I had to sign up, upload,
edit, change stuff, open work-based email, verify account, jump through
freaking hoops... Anyway...

When opened, select Sheet 2. As for the worksheet you will see, The 'R' and
'S' are supposed to be in wingdings as checkmarks and X boxes. I want to
keep their colors as I move the rows. Also, it apparently doesn't show my
conditional formatting.

I've tried to redesign part of the sheet to show the steps I take. Bear in
mind that rows 5 and 9 have conditional formatting across the entire section
(highlighted red). I always have to do the copy "Values Only" in order to
preserve the cf but then it won't keep the text formatting.


"Russell Dawson" wrote:

You say that "the data a2-a4 to go" - is that correct - if so what
repopulates those cells?

It may help if you were to share part of your w/s if possible. Access the
following and paste in.

http://spreadsheets.google.com/ccc?k...W1zU mc&hl=en

You call yourself First Aid Computing - are you commercial - are you getting
paid for this?
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"First Aid Computing" wrote:

Guess I'll have to try to work some more macro-meracles, then. I had
forgotten to mention that there are other sections of the sheet to keep in
place also, so deleting and shifting won't work. Gotta keep stuff on line.
Thanks anyway.

"מיכאל (מיקי) אבידן" wrote:

Well..., if selecting A2:A4 right click 'delete...' checking 'shift
cells upwards' - is for no help then I would suggest recording a Macro of the
entire procedure you have just described.
Micky


"First Aid Computing" wrote:

It deletes the entire row including data and conditional formatting. I need
to copy/paste as there is data in the first and last columns that needs to
stay put.

Say I have a 5x5 A-E,1-5 sheet. I need the data in A1 and A5 to stay, I
need the data from A2-A4 to go, I need the conditional formatting of Row A to
stay, the data from B2-E4 to go up one row (B2-4 becomes A2-4, etc.), and the
text formatting within B2-E4 to remain unchanged. As it is now, the text
formats when I copy/paste is not kept, red sometimes changes to green and so
forth depending on what was green/red in the rows above it.

"מיכאל (מיקי) אבידן" wrote:

I'm not sure I fully understood the question - but what happens if you place
the cursor above the gray label #1 (at the far left of row 1) until it
becomes a black arrow, pointing right, then right click and choose 'delete'.
Micky


"First Aid Computing" wrote:

Greetings. In Excel 2002 SP3 I have a large sheet of data I use as a
timetable. As time passes I remove the data from the first line and shift
the rest of the data upwards. For example: Data in rows 1-4, delete data in
row 1, copy/paste data from 2-4 to 1-3 (been using "Valus Only" to preserve
conditional formatting in row 1), delete row 4. Is there any way to do this
while 1) maintaining the conditional formatting in row 1 (time-based
highlighting) and 2) maintaining the font formatting from rows 2-4 as they
move to 1-3 (red X's and green check marks)? If an example file is needed, I
can certainly post one.