Results 1 to 5 of 5

The data in the remarks column is exchanged with the data in a certain area

Threaded View

  1. 03-07-2023, 12:02 PM #1
    Sakurayuki
    Sakurayuki is offline
    Registered User
    Join Date
    08-31-2020
    Location
    Japan
    MS-Off Ver
    2016
    Posts
    94

    The data in the remarks column is exchanged with the data in a certain area

    Can the data in the remarks column be exchanged with the data in a certain area and keep the original format unchanged?

    Cell M1 is a switch between NEW and OLD, if it is NEW, the I6:I36 data will not change from the original format

    If cell M1 is OLD, the data in the remark column of I6:I36 will be switched to I6:I36, and the original data of I6:I36 will be switched to the remark column, exchanged with each other and keep the original format unchanged

    When CELL M1 selecting NEW to change to the original appearance

    Any help is greatly appreciated
    Attached Files Attached Files
    Last edited by Sakurayuki; 03-08-2023 at 10:33 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] The input data in the area is automatically sorted, plus the serial number and remarks
    By Sakurayuki in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-29-2022, 12:55 AM
  2. Remove duplicates which is exchanged in 2 column cells
    By Sekars in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-01-2018, 04:32 AM
  3. VBA Print area Last Row and Last Column - With Blanks in Data
    By Declamatory in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-02-2016, 01:02 PM
  4. Save remarks/comments to Pivot table and chart data
    By Popopinsel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-23-2013, 05:25 AM
  5. Sorting data from a column to corresponding area
    By alex.ransome in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-30-2013, 06:59 AM
  6. [SOLVED] In Remarks Column the Remarks should be as described as the attached excel file
    By robin.das077 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-30-2013, 03:38 AM
  7. My column filter now includes statistical data outside the main data area
    By Metrobus425 in forum Excel General
    Replies: 4
    Last Post: 06-11-2012, 01:22 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1