+ Reply to Thread
Results 1 to 5 of 5

PLEASE HELP ME- I need to freeze columns H,F,G+I SO THEY ALWAYS MATCH VALUE IN COLUMN A

  1. #1
    Registered User
    Join Date
    11-09-2016
    Location
    Derby
    MS-Off Ver
    Excel
    Posts
    16

    PLEASE HELP ME- I need to freeze columns H,F,G+I SO THEY ALWAYS MATCH VALUE IN COLUMN A

    Good Morning everyone,

    I need to change Column A to add in more products, but im scared the other columns (See attached picture) will move up and down and my spreadsheet will be illustrating false values as these values are only specific to each product.

    Basicailly- If I insert additional products in column A, the spreadsheet may become misformatted when I filter/sort it A-Z therefore giving false values.

    Is there a way/formula to make sure the highlighted columns(See attached) always stay with the correct products in A?

    Your help will be greatly appreciated.

    Kind Regards.
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    452

    Re: PLEASE HELP ME- I need to freeze columns H,F,G+I SO THEY ALWAYS MATCH VALUE IN COLUMN

    Hi

    instead of =A1 use =INDIRECT("a1") OR =INDIRECT("a"&ROW())

  3. #3
    Registered User
    Join Date
    11-09-2016
    Location
    Derby
    MS-Off Ver
    Excel
    Posts
    16

    Re: PLEASE HELP ME- I need to freeze columns H,F,G+I SO THEY ALWAYS MATCH VALUE IN COLUMN

    Hi Sadath31,

    Thanks for your reply.

    Im not too sure where to insert the previously aforementioned formula.

    I've created a spreadsheet for you to work this formula on.

    Please can you enter the formula you think is correct then send it back with steps as to how you accomplished this query?

    Thanks so much.

    Chris.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    452

    Re: PLEASE HELP ME- I need to freeze columns H,F,G+I SO THEY ALWAYS MATCH VALUE IN COLUMN

    Hi

    if you want to insert a product in column A. then you should first insert a blank row (right click>insert then entire row). This will not disturb other values for the corresponding product in Col A.

  5. #5
    Registered User
    Join Date
    11-09-2016
    Location
    Derby
    MS-Off Ver
    Excel
    Posts
    16

    Re: PLEASE HELP ME- I need to freeze columns H,F,G+I SO THEY ALWAYS MATCH VALUE IN COLUMN

    Hi Sadath,

    it will when im pasting in lots of new products in then sorting it A-Z.

    Kind Regards

+ 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. Match columns A & C and partial Match B & D and get column E data
    By Excelbanksters in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-26-2016, 04:05 PM
  2. [SOLVED] If cells match then freeze (copy paste values) in each column in the workbook.
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-16-2015, 06:12 AM
  3. Replies: 20
    Last Post: 04-15-2013, 01:06 PM
  4. Replies: 6
    Last Post: 12-10-2012, 06:26 PM
  5. [SOLVED] Can I freeze column A and scroll down the other columns in Excel?
    By jlhudson in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-11-2011, 09:25 PM
  6. Replies: 3
    Last Post: 11-27-2006, 05:24 PM
  7. [SOLVED] Freeze Panes-can you freeze more than one column
    By rexmann in forum Excel General
    Replies: 4
    Last Post: 06-09-2005, 11:05 AM

Tags for this Thread

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