LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 94
Default Identify Last Cell and autofill last column

Hi,
I have a spreadsheet for which I need to identify the last cell with data
[nos. or formula] and on the column to the right I need to autofill with row
nos. Row numbering should stop when the row with the last cell is reached. Eg
if data is to row 672 only then the row number should be "numbered" as 672.

Thanks,

Manir
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Autofill column from data (code) in column next to it Matt Excel Worksheet Functions 4 April 24th 09 06:17 PM
Automating to autofill column B based on column A entry GirlFridayCA Excel Discussion (Misc queries) 2 December 2nd 08 10:46 PM
autoFill column equal to adjacent column Paulg[_4_] Excel Programming 4 July 17th 06 01:04 PM
Identify Cell by Column Header and ID in Col A (Track Changes) Bettergains Excel Programming 1 April 4th 05 01:33 PM
Use one column to identify values in adjacent column. Ken Fickling Excel Programming 1 July 8th 03 09:26 PM


All times are GMT +1. The time now is 12:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"