=OFFSET('Sample - Unedited'!$A$1,COLUMN('Sample -
Edited'!A1)+(COUNTA($A$1:$C$1)*(ROW(A1)-1)),0)
'Sample - Unedited'!$A$1 - header of source column
COLUMN('Sample - Edited'!A1) - will give us 1 , 2 , 3
(COUNTA($A$1:$C$1)*(ROW(A1)-1)) will give us 0 , 3, 6
'
0 because source data is in same col
Dear Chaya
The solution from Ashish (using offset command) has lesser effort than
using macro. I suggest to use the same for your multiple entries.
using macro is possible in 2008 . no issue. For your information. you have
to use Ctrl+ shift + A at first column of each row required.
Regards
Pra
Ashish,
That's exactly what I needed :-D
Would you mind showing me how to use it?
- Chaya
On Tuesday, August 20, 2013 12:50:23 AM UTC-4, ashish wrote:
>
> Hi try the attachment . see if it helps
>
>
>
>
> On Tue, Aug 20, 2013 at 9:46 AM, Prashant Pednekar
>
> > wrote:
>
>> Hi Chaya, Prabhu,
Hi Prashant,
I've only used macros a few times, and am having trouble a wee bit of
trouble figuring things out because I'm temporarily using a Excel 2008 for
Mac :-( (I'm normally a PC gal, with Office 2007 ;-))
Can I trouble you to explain when I should use Control + Shift + A, and how
to op
Hi try the attachment . see if it helps
On Tue, Aug 20, 2013 at 9:46 AM, Prashant Pednekar wrote:
> Hi Chaya, Prabhu,
>
> Done with a simple macro.
>
> Use Control + Shift + A at particular cell where you want to transpose.
>
> This you have to to for every entry.
>
> In case you want it for
Am just asking you to share the excel file.
On 20-Aug-2013 5:50 AM, "Chaya Cooper" wrote:
> I'm sorry, I'm not sure I understand what you're saying :-(
>
> On Monday, August 19, 2013 7:24:56 PM UTC-4, Prabhu Pinky wrote:
>>
>> hi chaya,
>>
>> hope if u share the file.. it will be so fine to work.
I'm sorry, I'm not sure I understand what you're saying :-(
On Monday, August 19, 2013 7:24:56 PM UTC-4, Prabhu Pinky wrote:
>
> hi chaya,
>
> hope if u share the file.. it will be so fine to work.
>
>
> Thanks & Regards,
> Prabhu R
>
>
> On 20 August 2013 04:35, Chaya Cooper >wrote:
>
>> Unfortun
hi chaya,
hope if u share the file.. it will be so fine to work.
Thanks & Regards,
Prabhu R
On 20 August 2013 04:35, Chaya Cooper wrote:
> Unfortunately, the data in each row is different
>
> I've attached an image with an example :-)
>
>
> On Mon, Aug 19, 2013 at 6:36 PM, Prabhu Pinky wrote
you mean same data in each row..?.. or can you share me your file with
requirement..?
like below..
[image: Inline images 1]
Thanks & Regards,
Prabhu R
On 20 August 2013 04:02, Chaya Cooper wrote:
> That's amazing :-D I'm sorry I waited this long to ask ;-)
>
> One question - is there a way
That's amazing :-D I'm sorry I waited this long to ask ;-)
One question - is there a way to split it up into several rows (for example
5 rows, with 3 columns per row)?
On Monday, August 19, 2013 6:21:59 PM UTC-4, Prabhu Pinky wrote:
>
> Hi Chaya,
>
> You no need to cut and paste the each cells.
Hi Chaya,
You no need to cut and paste the each cells. Simply u just copy the data
which u need to be in row. then right click->paste special->values (and
select transpose). Now you data will be pasted in single row.
Note the same method u can use to copy the data in single column if it is
in sin
I often have to move cells in order to have them in a row (going across)
instead of in a column (going down). Is there a way to simplify this so
that I don't have to manually cut & paste or move each cell?
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,
12 matches
Mail list logo