Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #107916 > unrolled thread

Re: Macro to paste from clipboard

Back to article view | Back to microsoft.public.excel.programming

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.

Contents

  Re: Macro to paste from clipboard isabelle <i@v.invalid> - 2015-07-31 23:32 -0400
    Re: Macro to paste from clipboard isabelle <i@v.invalid> - 2015-07-31 23:41 -0400
      Re: Macro to paste from clipboard F <news@nowhere> - 2015-08-01 09:34 +0100
    Re: Macro to paste from clipboard F <news@nowhere> - 2015-08-01 09:33 +0100

#107916 — Re: Macro to paste from clipboard

hi,

how have you nominated the tabs of each month?

isabelle

Le 2015-07-31 07:40, F a écrit :
> I have a worksheet in Excel 2010 into which, each day, I paste two columns from
> a temporary sheet into columns K and L.
>
> Values from K and L are then extracted into C2, D2, E2 and F2 using
>
>
> =IF(INDEX($K$8:$K$151,MATCH(MAX($L$8:$L$151),$L$8:$L$151,0))<>"00:10",INDEX($K$8:$K$151,MATCH(MAX($L$8:$L$151),$L$8:$L$151,0)),"No
> output")
>
> =MAX($L$8:$L$151)
>
> {=INDEX(K8:K80,MATCH(TRUE,L8:L80<>0,0))}
>
> {=INDEX(K81:K151,MATCH(TRUE,L81:L151=0,0))}
>
> respectively.
>
> I then copy the contents of C2:F2 and paste them into C4:F4 and then, the next
> day, into C5:F5 and so on until the end of the month. The next month is on a
> separate sheet.
>
> I've struggled, and failed, to write a macro to automate this. Can anyone help?
>

[toc] | [next] | [standalone]

#107917

does the tabs of each month must be created successively?

isabelle

Le 2015-07-31 23:32, isabelle a écrit :
> hi,
>
> how have you nominated the tabs of each month?
>
> isabelle
>

[toc] | [prev] | [next] | [standalone]

#107922

Hi

No, each tab is already created. I treat them separately rather than as 
being 'connected'.

-- 
F

www.vulcantothesky.org - 2015, the last year to see a Vulcan fly


On 01/08/2015 04:41, isabelle wrote:
> does the tabs of each month must be created successively?
>
> isabelle
>
> Le 2015-07-31 23:32, isabelle a écrit :
>> hi,
>>
>> how have you nominated the tabs of each month?
>>
>> isabelle
>>

[toc] | [prev] | [next] | [standalone]

#107921

Hi

The tab for each month is named after the month: January, February, 
March etc.

-- 
F

www.vulcantothesky.org - 2015, the last year to see a Vulcan fly


On 01/08/2015 04:32, isabelle wrote:
> hi,
>
> how have you nominated the tabs of each month?
>
> isabelle
>
> Le 2015-07-31 07:40, F a écrit :
>> I have a worksheet in Excel 2010 into which, each day, I paste two
>> columns from
>> a temporary sheet into columns K and L.
>>
>> Values from K and L are then extracted into C2, D2, E2 and F2 using
>>
>>
>> =IF(INDEX($K$8:$K$151,MATCH(MAX($L$8:$L$151),$L$8:$L$151,0))<>"00:10",INDEX($K$8:$K$151,MATCH(MAX($L$8:$L$151),$L$8:$L$151,0)),"No
>>
>> output")
>>
>> =MAX($L$8:$L$151)
>>
>> {=INDEX(K8:K80,MATCH(TRUE,L8:L80<>0,0))}
>>
>> {=INDEX(K81:K151,MATCH(TRUE,L81:L151=0,0))}
>>
>> respectively.
>>
>> I then copy the contents of C2:F2 and paste them into C4:F4 and then,
>> the next
>> day, into C5:F5 and so on until the end of the month. The next month
>> is on a
>> separate sheet.
>>
>> I've struggled, and failed, to write a macro to automate this. Can
>> anyone help?
>>

[toc] | [prev] | [standalone]

Back to top | Article view | microsoft.public.excel.programming

csiph-web