LinkBack URL
About LinkBacks
Is there a way to copy cells in a row with only non blank values?
thx
E
Is there a way to copy cells in a row with only non blank values?
thx
E
Last edited by enhydra; 12-15-2009 at 12:37 AM.
1) Highlight the row of values
2) Press F5, click on Special
3) Select Constants if the row is full of flat values
Select Formulas if the row is full of formulas
...and leave all the subcategories checked
4) Click OK
5) Press CTRL-C to copy
6) Click on your target and press ENTER
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Cool, thanks JB. I learn something new everyday. Sometimes I feel like a chicken, everyday is the first day of my life.
thx
E
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks