| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alternative to Copy and paste values in VBA
Here are some of the formulas, ranging from the most simple to complex:
=O10+P10 =U10+V10+W10 =MATCH($BG$2&Amounts!$G10&Amounts!$I10,'Ultimate Selections'!FactorTypeOutput&'Ultimate Selections'!CoverageOutput&'Ultimate Selections'!SegmentOutput,0) =(INDEX('Ultimate Selections'!$E$6:$BL$101,Amounts!$BD10-1,Amounts!$BG10,1)-INDEX('Ultimate Selections'!$E$6:$BL$101,Amounts!$BD10-1,Amounts!$BG10+45,1))*($BC10/(INDEX('Ultimate Selections'!$AX$5:$BL$100,$BD10,$BG10)+(INDEX('Ult imate Selections'!$AX$5:$BL$100,$BE10,$BG10)+(INDEX('Ult imate Selections'!$AX$5:$BL$100,$BF10,$BG10)))))*(1/(INDEX('Ultimate Selections'!$E$6:$BL$101,Amounts!$BD10-1,Amounts!$BG10,1)/INDEX('Ultimate Selections'!$E$6:$BL$101,Amounts!$BD10-1,Amounts!$BG10+45,1)))+(INDEX('Ultimate Selections'!$E$6:$BL$101,Amounts!$BD10-1,Amounts!$BG10,1)-INDEX('Ultimate Selections'!$E$6:$BL$101,Amounts!$BD10-1,Amounts!$BG10+45,1))*($M10/INDEX('Ultimate Selections'!$AI$5:$AW$100,$BD10,$BG10))*(1-1/(INDEX('Ultimate Selections'!$E$6:$BL$101,Amounts!$BD10-1,Amounts!$BG10,1)/INDEX('Ultimate Selections'!$E$6:$BL$101,Amounts!$BD10-1,Amounts!$BG10+45,1))) The formulas work fine 10, 20, 30 at a time, but I need to apply them to 30,000 rows. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy-Paste Alternative Needed... | Excel Discussion (Misc queries) | |||
| Copy and paste up to values in last row | Excel Discussion (Misc queries) | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| is there a better alternative to Copy/Paste? | Excel Programming | |||
| How do i compare values from two sheet and copy & paste if values match? | Excel Programming | |||
![thisguy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
