|
|
|
|
#1
03-25-2016, 03:46 PM
|
|||
|
|||
Hi Phil,
Thanks for the tip, things are starting to become clearer now lol. The code worked well until i added another two columns into sheet 2 so, I had a bit play with the offset but can only get the values to go into columns D & E instead of B & E. I tried what you suggested above but it didnt give the result unfortunately  Carl 
|
|
| Tags |
| vba |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| On Click do a search of its contents on sheet2 | mike12 | Excel | 11 | 10-16-2014 04:32 PM |
| Transferring info from 1column on sheet2 to sheet1 | rogcar75 | Excel | 22 | 08-26-2014 05:07 PM |
| split text files to worksheets (sheet1,sheet2,sheet3 soon sheet 25) | gsrikanth | Excel Programming | 1 | 03-22-2012 11:04 PM |
 How to merge two cells from sheet1 to one cell in sheet2 in next sheet
|
KIM SOLIS | Excel | 6 | 10-30-2011 11:14 PM |
|
Checking ref # status based on sheet2 ref #.
|
aligahk06 | Excel | 1 | 04-26-2010 11:22 PM |
Windows XP 
Office 2010 64bit
Hybrid Mode