okay I read that wrong - is there a "quicker" way to make the data contiguous than copy and pasting?
okay I read that wrong - is there a "quicker" way to make the data contiguous than copy and pasting?
The simplest way is to create references to the required cells by using the INDIRECT function. See attached
Last edited by Andy Pope; 11-25-2008 at 06:06 AM.
wonderful!! thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks