Home |
Search |
Today's Posts |
#1
|
|||
|
|||
move data from multiple cells in one row to another
I have a large file and would like a function that would, in effect, be
something like IF B2 is empty then move the data E2:L2 to E1:L1 the formula would be copied throughout the length of column D. is this possible? |
#2
|
|||
|
|||
And what happens when B2 is NOT empty?
******************* ~Anne Troy www.OfficeArticles.com "KUMPFfrog" wrote in message ... I have a large file and would like a function that would, in effect, be something like IF B2 is empty then move the data E2:L2 to E1:L1 the formula would be copied throughout the length of column D. is this possible? |
#3
|
|||
|
|||
Formulas can only return values.
They cannot "move" data. You would need VBA code to achieve the actual "moving". Gord Dibben Excel MVP On Tue, 19 Jul 2005 12:55:03 -0700, KUMPFfrog wrote: I have a large file and would like a function that would, in effect, be something like IF B2 is empty then move the data E2:L2 to E1:L1 the formula would be copied throughout the length of column D. is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Putting data from multiple worksheets into one | Excel Discussion (Misc queries) | |||
Entering same data into multiple cells | Excel Discussion (Misc queries) | |||
How do I center data across multiple cells in excel without mergi. | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Automatic copying data excluding blank cells | Excel Worksheet Functions |