Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pfa
 
Posts: n/a
Default How to copy text box from one worksheet to cell

I have a fairly lengthy piece of text that I wrote as a conclusion for an
audit finding on one worksheet, for which I had to create a text box. How do
I copy that automatically into another worksheet that keeps track of all
conclusions for each of the 84 other worksheets (each corresponding to an
audit step)? This is one of two conclusions that is very large. All others
are short comments that (obviously) fit well into the cells since they are
within the 1024 character limitation. Surely the text will not fit in
worksheet "database" (the one that is programmed to keep track of all
conclusions written on the other 84 worksheets), again because of the
character limitation. Is there a workaround?

I am not very proficient at Excel, so responses requiring code might be a
little problematic for me. But any help is greatly appreciated because I
anticipate running into more of this type of situation as more and more work
comes my way.

Thanks!
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
copy data in a cell from worksheet A to worksheet B rajesh Excel Discussion (Misc queries) 1 February 21st 06 07:40 AM
Copy a string text to cell if another cell not empty Pasmatos Excel Discussion (Misc queries) 0 November 25th 05 03:54 PM
how to count the number of text frequencies and copy to other cell DG Excel Worksheet Functions 1 October 6th 05 07:11 PM
copy a cell to another worksheet? mo Excel Worksheet Functions 1 February 26th 05 01:31 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 03:05 PM.

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"