|
|
#2
01-05-2015, 12:01 PM
|
|||
|
|||
Enter into the AS sheet for Finish:
=VLOOKUP(AS!Axx,'Prog dump'!A:L,7,FALSE) Where xx is the row number. Copy to the rest of the sheet. The 7 in the above equation is the column index number Finish in 'Prog dump'. For the Budgeted Material Cost, it is 9. For Annual Total Cost, it is 10. Otherwise, the equations are identical. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel copy two numbers between specific column and paste in next sheet | visha_1984 | Excel | 1 | 12-26-2014 07:59 PM |
| Copy content control entries to next table next page | Mel_Herndon | Word VBA | 2 | 05-22-2014 05:07 PM |
| how can i split a column of rows in half without copy and paste.. | Lindseyfparker | Excel | 2 | 04-25-2014 12:52 AM |
| How to copy format of a column using spin button | Tyberian1988 | Excel Programming | 2 | 03-10-2014 10:09 PM |
| Copy Column setting to other spreadsheets in an excel workbook | officeboy09 | Excel | 5 | 11-05-2013 01:49 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode