+ Reply to Thread
Results 1 to 7 of 7

Updating Cells

Hybrid View

  1. 09-09-2009, 06:57 PM #1
    garry240868
    garry240868 is offline
    Registered User
    Join Date
    09-06-2009
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Updating Cells

    Thanks Stan: A1 should be the part number,B1 Description, C1 Qty, D1 Price. Thanks again Garry
    Reply With QuoteRegister To Reply
  2. 09-09-2009, 08:32 PM #2
    stanleydgromjr
    stanleydgromjr is offline
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Updating Cells

    garry240868,

    See the attached workbook "Source Data(1).xlsx".

    There are VLOOKUP formulae in cells B1, C1, and D1.

    Manually enter/change cell A1.
    Attached Files Attached Files
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
    Reply With QuoteRegister To Reply
  3. 09-10-2009, 03:52 PM #3
    garry240868
    garry240868 is offline
    Registered User
    Join Date
    09-06-2009
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Updating Cells

    brilliant thanks again
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1