Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting and the "go to" command
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting and the "go to" command
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting and the "go to" command
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" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting and the "go to" command
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 wrote: 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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|