|
|
#3
06-06-2017, 04:57 PM
|
|||
|
|||
I could be wrong, but I don't think you can do this without VBA.
There's probably a better way, but this is what I ended up with for entering line items in my invoicing workbook: Range("K" & (ActiveCell.Row)).Select ActiveCell = "=VLOOKUP(D" & ActiveCell.Row & ",'Service Items'!A: D,4,False)" ActiveCell.Value = ActiveCell.Value Column K is the item price on my line items sheet. 'Service Items'!A: D is my lookup range, where D holds the unit price. After looking it up, "ActiveCell.Value = ActiveCell.Value" takes the resulting value of the lookup and pastes it in place of the lookup formula. Last edited by Coronos; 06-06-2017 at 05:00 PM. Reason: A: D (without the space) was interpreted as a big grin 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 alphabetize a list (manual index) with entries and sub-entries
|
shmu | Word | 5 | 08-01-2016 11:15 PM |
|
[Project 2013] More accuracy with resource, unit %, and cost?
|
cag8f | Project | 18 | 01-02-2016 01:51 PM |
|
Cost resource not taken in real cost
|
pascalbidouille | Project | 1 | 08-21-2015 01:25 PM |
| Using Fill In Fields to Autopopulate Multiple Areas in the Document | rogelinepaula | Word | 1 | 08-13-2015 11:15 PM |
| Autopopulate | schiesa | Word | 1 | 11-06-2012 02:31 AM |
Windows 10 
Office 2010 64bit
Threaded Mode