Results 1 to 1 of 1

Need to modify current vlookallsheets function

Threaded View

  1. #1
    Registered User
    Join Date
    07-30-2008
    Location
    UK
    Posts
    52

    Need to modify current vlookallsheets function

    (ive attached files associated with this problem)

    hi there,
    at the moment i have 2 files, a master spreadsheet (S1) and a raw data spreadsheet with multiple tabs (S2). S1 contains a list of order numbers, and currently i have been copying over the tabs from S2 into S1, and using a modified vlookup function so it vlookup's the order numbers in S1 with the order numbers in S2, across multiple worksheets.

    The problem i have is when i want to import a new S2 spreadsheet with multiple tabs, and bring those tabs into S1 (deleting the already imported S2 data tabs). When I use Vlookup again, and copy and paste the formula down, ofcourse its going to overwrite all the data ive lookedup from previous S2 data.

    I need to find a way of modifying the function so that when I copy and paste it again, after importing new raw data tabs, it doesn't overwrite values already in there, and only puts the formula in cells containing '£0.00'.

    I hope that all makes sense.
    Would really appreciate some help on this, because at the moment the only solution ive come up with is either to copy and paste the formula manually (which would be really time consuming for over 400 records of data), or copy the S1 tab to a new spreadsheet, put the S2 raw data tabs into that, do the search, and copy and paste manually back into the original S1 any new values found....

    thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel Function Output not updating
    By aj_uk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-16-2008, 04:37 AM
  2. user defined function works in VBA but does not work inside worksheets
    By HabibValil in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-22-2008, 10:04 AM
  3. Aging Function
    By Lotus123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-29-2008, 02:20 PM
  4. User Defined Function (UDF) in a shared workbook
    By arizenn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-08-2007, 11:19 AM
  5. Function and Personal.xls
    By boylejob in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2007, 12:32 PM

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