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

Re: Macro to paste from clipboard

From	isabelle <i@v.invalid>
Newsgroups	microsoft.public.excel.programming
Subject	Re: Macro to paste from clipboard
Date	2015-07-31 23:32 -0400
Organization	Aioe.org NNTP Server
Message-ID	<mpheka$5m5$1@speranza.aioe.org> (permalink)
References	<t7-dnW0Rv_aewibInZ2dnUU78audnZ2d@brightview.co.uk>

Show all headers | View raw

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

Back to microsoft.public.excel.programming | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

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

csiph-web