|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
I'd like to use the "go to" command where the cursor goes to the last row
with data. When I use the "Special" command and select "last" it goes to the
last formatted cell, not the last cell with data in it.
Can I go to the last cell with data entered in it without going to the last
formatted cell (that may be empty?)
If not, how do I delete formatting? I formatted rows and columns with
borders for ease of reading, and if I go in and change to show "no borders",
it still seems to be reading that as formatted because it still goes to the
last cell that I highlighted to get no borders. ???
Thanks for any info.
KK
|
|
KK,
A lot depends on the structure of your sheet, and where you actually want to go:
End then down arrow, or End then right arrow, unless you have intermediate blanks, in which case
you can use Special / Current region, then Shift-Tab. That will work unless you have completely
blank rows or columns interspersed.
HTH,
Bernie
MS Excel MVP
"kleivakat" <kleivakat[ at ]discussions.microsoft.com> wrote in message
news:CC62C134-5D86-4C80-97EC-9E05E3B4488F[ at ]microsoft.com...
[Quoted Text] > I'd like to use the "go to" command where the cursor goes to the last row
> with data. When I use the "Special" command and select "last" it goes to the
> last formatted cell, not the last cell with data in it.
>
> Can I go to the last cell with data entered in it without going to the last
> formatted cell (that may be empty?)
>
> If not, how do I delete formatting? I formatted rows and columns with
> borders for ease of reading, and if I go in and change to show "no borders",
> it still seems to be reading that as formatted because it still goes to the
> last cell that I highlighted to get no borders. ???
>
> Thanks for any info.
>
> KK
|
|
Here's what I'm trying to do... let me know if there is an easier way.
I have about 25 workbooks in a folder that are status reports for various
projects. The second sheet in all the workbooks is called "Notes", and
includes columns for date, status and initials. Anyone working on the
project can go to that workbook and check on the current status, or add
something as needed.They are all text fields.
We review them during our weekly project meetings, and it's getting
cumbersome to open and print off 25 sheets in separate workbooks, and I was
hoping I could put together a summary report that simply has the name of the
project, and pulls the information off the last line of the "Notes" column.
For the summary report, all I would need is the project name, and the info on
the last line. But since the last line may change location when something
new is added, I want the macro to always find the last line of text.
I can create a summary report that finds the cell, but how do I make it
re-run every time I want to update the report so that it goes to all 25
workbooks, and refreshes the report with the "new" last line?
Any thoughts are greatly appreciated!
KK
"Bernie Deitrick" wrote:
[Quoted Text] > KK,
>
> A lot depends on the structure of your sheet, and where you actually want to go:
>
> End then down arrow, or End then right arrow, unless you have intermediate blanks, in which case
> you can use Special / Current region, then Shift-Tab. That will work unless you have completely
> blank rows or columns interspersed.
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "kleivakat" <kleivakat[ at ]discussions.microsoft.com> wrote in message
> news:CC62C134-5D86-4C80-97EC-9E05E3B4488F[ at ]microsoft.com...
> > I'd like to use the "go to" command where the cursor goes to the last row
> > with data. When I use the "Special" command and select "last" it goes to the
> > last formatted cell, not the last cell with data in it.
> >
> > Can I go to the last cell with data entered in it without going to the last
> > formatted cell (that may be empty?)
> >
> > If not, how do I delete formatting? I formatted rows and columns with
> > borders for ease of reading, and if I go in and change to show "no borders",
> > it still seems to be reading that as formatted because it still goes to the
> > last cell that I highlighted to get no borders. ???
> >
> > Thanks for any info.
> >
> > KK
>
>
>
|
|
See Ron de Bruin's site for some code help.
http://www.rondebruin.nl/tips.htm
Scroll down to the copy/paste/merge examples.
Choose what you think is closest to your needs.
Or a combination of routines.
Gord Dibben MS Excel MVP
On Mon, 25 Sep 2006 12:46:01 -0700, kleivakat
<kleivakat[ at ]discussions.microsoft.com> wrote:
[Quoted Text] >Here's what I'm trying to do... let me know if there is an easier way.
>
>I have about 25 workbooks in a folder that are status reports for various
>projects. The second sheet in all the workbooks is called "Notes", and
>includes columns for date, status and initials. Anyone working on the
>project can go to that workbook and check on the current status, or add
>something as needed.They are all text fields.
>
>We review them during our weekly project meetings, and it's getting
>cumbersome to open and print off 25 sheets in separate workbooks, and I was
>hoping I could put together a summary report that simply has the name of the
>project, and pulls the information off the last line of the "Notes" column.
>For the summary report, all I would need is the project name, and the info on
>the last line. But since the last line may change location when something
>new is added, I want the macro to always find the last line of text.
>
>I can create a summary report that finds the cell, but how do I make it
>re-run every time I want to update the report so that it goes to all 25
>workbooks, and refreshes the report with the "new" last line?
>
>Any thoughts are greatly appreciated!
>
>KK
>
>
>
>"Bernie Deitrick" wrote:
>
>> KK,
>>
>> A lot depends on the structure of your sheet, and where you actually want to go:
>>
>> End then down arrow, or End then right arrow, unless you have intermediate blanks, in which case
>> you can use Special / Current region, then Shift-Tab. That will work unless you have completely
>> blank rows or columns interspersed.
>>
>> HTH,
>> Bernie
>> MS Excel MVP
>>
>>
>> "kleivakat" <kleivakat[ at ]discussions.microsoft.com> wrote in message
>> news:CC62C134-5D86-4C80-97EC-9E05E3B4488F[ at ]microsoft.com...
>> > I'd like to use the "go to" command where the cursor goes to the last row
>> > with data. When I use the "Special" command and select "last" it goes to the
>> > last formatted cell, not the last cell with data in it.
>> >
>> > Can I go to the last cell with data entered in it without going to the last
>> > formatted cell (that may be empty?)
>> >
>> > If not, how do I delete formatting? I formatted rows and columns with
>> > borders for ease of reading, and if I go in and change to show "no borders",
>> > it still seems to be reading that as formatted because it still goes to the
>> > last cell that I highlighted to get no borders. ???
>> >
>> > Thanks for any info.
>> >
>> > KK
>>
>>
>>
Gord Dibben MS Excel MVP
|
|
|