| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to paste from clipboard
On Friday, July 31, 2015 at 6:42:05 AM UTC-5, F wrote:
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? -- F www.vulcantothesky.org - 2015, the last year to see a Vulcan fly I need help!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can't paste from clipboard in my macro | Excel Discussion (Misc queries) | |||
| Macro to Paste Picture in email body from Clipboard | Excel Programming | |||
| Paste from clipboard only | Excel Worksheet Functions | |||
| Transfer clipboard from Task pane clipboard(office?) content to Excel (windows?) clipboard? | Excel Programming | |||
| Store clipboard before "vba do cut&paste" then recover stored information to clipboard? | Excel Programming | |||
Hybrid Mode
