+ Reply to Thread
Results 1 to 3 of 3

Insert Column with vLookup formula

  1. #1
    Registered User
    Join Date
    01-20-2013
    Location
    Denver, Colorado
    MS-Off Ver
    2011 (mac)
    Posts
    48

    Insert Column with vLookup formula

    Hi Forum,

    Once again I find myself turning to this great forum to try to find a solution to a VBA question I have. I'm wanting to insert a column onto a spreadsheet that contains a vLookup formula. Right now I have the following code, which copies select columns from one worksheet ("SiteMaster") and copies the columns to a second worksheet ("HSmSchedule"):

    Please Login or Register  to view this content.
    I want to add the following vLookup
    Please Login or Register  to view this content.
    into column B on the second worksheet ("HSmSchedule"), but I only want the formula to be copied to rows that contain values copied into column A on the second worksheet. Anybody have any ideas on how I can make this happen? Thanks!

  2. #2
    Registered User
    Join Date
    01-20-2013
    Location
    Denver, Colorado
    MS-Off Ver
    2011 (mac)
    Posts
    48

    Re: Insert Column with vLookup formula

    Never mind...I simply added the vLookup to the master worksheet ("SiteMaster") then copied the values like I did with the other columns. Sorry for the wasted thread!

  3. #3
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,147

    Re: Insert Column with vLookup formula

    No thread is wasted. It will surely help someone, somewhere.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro Insert Vlookup Formula
    By smmeader in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-18-2012, 12:18 PM
  2. [SOLVED] Formula to Insert the No 1 in column b when a number is detected in Column A
    By leinster93 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-29-2012, 11:21 AM
  3. Replies: 4
    Last Post: 01-22-2011, 07:33 AM
  4. insert text based on vlookup condition in two column
    By isabella in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-10-2010, 09:19 PM
  5. Insert value from vlookup and not formula with VBA
    By Les Stout in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-22-2005, 05:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1