move data from multiple cells in one row to another

K

KUMPFfrog

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?
 
G

Gord Dibben

Formulas can only return values.

They cannot "move" data.

You would need VBA code to achieve the actual "moving".


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Need a proper guru! My head hurts ;( 1
Returning Multiple Results with Vlookup 1
Vlookup a subtotal 2
Very strange behaviour of VLOOKUP in Excel 2010 4
Key Card Software (Auric) 7
Copying & Filling in data from One file into another. 0
move a row of data from one work sheet to another using a formula 1

Top