Posted to microsoft.public.excel.programming
|
|
Macro to paste from clipboard
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?
|