Re: excel macro rather difficult

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Wenom (wenomONE_at_gazeta.pl.PleaseReplaceONEwith1.ZamienONEna1)
Date: 09/12/04 

Date: Sun, 12 Sep 2004 13:42:03 +0200

Dnia Sun, 12 Sep 2004 11:14:42 +0200, Bernd Plumhoff
<bplumhoff@t-online.de> napisał:

> Does it have to be a macro? If A1, A3, A5, ... are the questions and A2,
> A4,
> A6, ... are the answers then write in B1:
> =LEFT(OFFSET($A$1,ROW()*2,0),FIND(OFFSET($A$1,ROW()*2,0),"[")-1)&":
> "&OFFSET($A$1,ROW()*2-1,0)
> and copy down.

It's not that easy. questions and answers must meet the constraints that
i've given above. I tried your code but it doesn't work.

Quantcast