+ Reply to Thread
Results 1 to 2 of 2

updating cell references

  1. #1
    Registered User
    Join Date
    08-18-2015
    Location
    Birmimgham
    MS-Off Ver
    2015
    Posts
    78

    updating cell references

    I have a workbook with several sheets. My first sheet has over 1000 products that is updated from a suppliers excel file. On the second sheet I reference each cell and apply a formula to create a csv file for uploading to our software. Sometimes the supplier may remove or add products. When the workbook is refreshed and the supplier sheet is imported the cell references on the second sheet sometimes come up as #REF so I have to copy the formula from the first line and paste it down. How can I automatically do this?

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: updating cell references

    Do some research on Excel Tables. One of the things they do is automatically copy formulas down. You can get started with this article: http://www.utteraccess.com/wiki/inde...ables_in_Excel.

+ 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] Copying code down a column without all cell references updating.
    By RichardJSigKits in forum Excel General
    Replies: 28
    Last Post: 02-27-2014, 05:10 PM
  2. [SOLVED] Grab 3 cells to left of the cell I need to average without updating references
    By shane01101 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-13-2014, 10:33 AM
  3. Conditional Formatting - Updating Cell References
    By NahRoots in forum Excel General
    Replies: 1
    Last Post: 10-27-2011, 05:00 PM
  4. Mass updating of cell references
    By DanielHutchison in forum Excel General
    Replies: 1
    Last Post: 07-01-2008, 11:08 AM
  5. Replies: 2
    Last Post: 12-08-2007, 09:29 PM
  6. Updating cell references...
    By ChrisMattock in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-02-2007, 11:05 AM
  7. Updating references
    By LostInSpace in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-24-2006, 07:35 AM
  8. [SOLVED] Updating Name References in Sheet
    By Chaplain Doug in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-23-2005, 08:20 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