There are plenty of free web hosting sites, they will host a file for a
certain time. Post it there, others can see it then.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Bob Phillips" wrote in message
...
Why don't you take it as far as you can with point #1 then post a copy of
the workbook to a web share and we can look at 'improving' it and doing
point #2.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my
addy)
"tralbert" wrote in message
...
Ok, I think I can record that easily enough.
Now to my other one. My data covers 3 separate 30 day periods, and each
set
has a Turnover/Retention column (columns I, O, and U respectively). If I
put
an N in any of those columns I am wanting a macro to run that will
automatically take out any conditional formatting and grey out the
relevant
cells in that row. Removing the formatting and coloring the relevant
cells is
easy enough. I'm thinking I'm going to have to put an IF statement of
some
sort in the code of the macro to know what columns to look at.
That's the part I'm not terribly certain how to accomplish. While I know
the
general gist of how to record a macro, I've never actually gone in and
tinkered around with the VB before.
Again, I really appreciate the help here. While I've been working on this
little project I have very quickly learned that I am not only more
knowledgable than I thought at Excel, but I actually know more about
Excel
than anyone else in my company (at least that I've talked to so far).
While I
may not know how to do everything, I do know quite a bit and I at least
know
where to go for good resources when I need help. I'm thinking more and
more I
really need to start looking at a certification of some sort. lol
Thanks again!
--
Teri Albert
"JLatham" wrote:
Perhaps something as 'simple' as a macro that after you've already
inserted
the new row, then chosen a cell in the row above that has formats you
need,
does a copy current row, paste special | Formats in the next row down.
Could
be called from Tools | Macro | Macros or a button, or even a
double-click in
specific column in row with data in it (macro could test: has this cell
got
data, is next one down empty? - Yes, do the copy/paste special
operation, no
- ignore).
Just spitballing here.
"Bob Phillips" wrote:
"tralbert" wrote in message
...
--
Teri Albert
"Bob Phillips" wrote:
This would be similar to how a new line is created in an
Access
table when you input a new record. Any suggestions?
What formatting, where?
The formatting in previously entered rows. Each time I input a new
person
I
will need a new row inserted below the one I use, and would like to
keep
the
formatting used on previous entries. Does that make any kind of
sense?
Yes it does, but there is no row insert event that we can piggyback
onto, so
we need some other cue.
After you insert a new row, is there something that you always do to
the
same column in that new row that we could monitor for, something that
you
wouldn't do on a normal update of the row?
Where is the Y/N columns?
Rows I and O respectively. Anytime an "N' is input into either one
of the
columns on any person I want that person's row to be shaded dark
gray.
Thanks for your help!