|
|
#6
05-10-2015, 07:50 PM
|
|||
|
|||
After looking at this for a few hours lol. I think I'm following it. Is this the line of code that pastes in the data?
.Cells(writeRow, 1).Resize(1, 4).Value = fndNum.Offset(0, 2).Resize(1, 4).Value It looks like it grabs all of the data right of the Offset. It needs to be very specific on what is copied. There is other info in the real log to the right that doesn't go into the form. If the Transfer Number is XX00002345 then the copied data needs to be specifically C4:F4. Learning a lot. Thanks in advance 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Lookup multiple values and compare different scenarios to get a specific result | mws | Excel | 5 | 05-24-2014 04:52 AM |
| Way to insert/paste frequently used values? | leemoreau | Word | 1 | 09-19-2013 03:35 AM |
| How can match or lookup values from two separate tables? | klawk26 | Excel | 1 | 07-31-2012 09:04 PM |
| Multi-Variable Lookup help | ebolton | Excel | 8 | 05-05-2011 05:28 AM |
| Word - Calculate and paste values from Excel sheet | Augf87 | Word | 1 | 07-06-2009 10:26 AM |
Lookup / Paste Multi Values VBA
Windows 7 32bit 
Office 2010 32bit
Threaded Mode