Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Millard
 
Posts: n/a
Default in excel can one repeat the text from a the last used column cell.

In excel 2003 can a formula be constructed that will copy a cell into a new
spreadsheet if there is text in the original spreadsheet cell but will also
repeat the last used cell within a column if the original spreadsheet is
empty?
  #2   Report Post  
 
Posts: n/a
Default

hi,
formulas return values. they cannot perform actions like
copy and pasted. sorry
this could possible be done with a macro.

-----Original Message-----
In excel 2003 can a formula be constructed that will copy

a cell into a new
spreadsheet if there is text in the original spreadsheet

cell but will also
repeat the last used cell within a column if the original

spreadsheet is
empty?
.

Reply
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
How to convert Excel imported numbers from text to numbers? Alden Excel Discussion (Misc queries) 9 April 1st 05 09:51 PM
How do I fix text wrapping in Excel? Ducky88 Excel Discussion (Misc queries) 1 February 18th 05 01:37 AM
how do I enable "import text file" excel 2002? jw_schmid Excel Discussion (Misc queries) 2 February 9th 05 10:39 PM
Stop Excel from converting text labels in CSV files to Values Just Want a Label! Excel Discussion (Misc queries) 1 January 11th 05 04:51 PM
numbers and text in Excel to read as text keeping the leading zer. Ralph Excel Discussion (Misc queries) 2 December 10th 04 07:05 PM


All times are GMT +1. The time now is 10:39 AM.

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

About Us

"It's about Microsoft Excel"