+ Reply to Thread
Results 1 to 9 of 9

Move data to constant row

  1. 08-03-2018, 03:52 AM #1
    chandy123987
    chandy123987 is offline
    Forum Contributor
    Join Date
    12-22-2017
    Location
    INDIA
    MS-Off Ver
    EXCEL 2007
    Posts
    106

    Move data to constant row

    Need to move Chennai to 7th row and Bangalore to 17th row of existing data
    Attached Files Attached Files
    Last edited by chandy123987; 08-06-2018 at 01:41 AM.
    Reply With QuoteRegister To Reply
  2. 08-03-2018, 06:08 AM #2
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Move data to constant row

    Is it a one shot or do you need to do it regularly ?
    - Battle without fear gives no glory - Just try
    Reply With QuoteRegister To Reply
  3. 08-03-2018, 06:25 AM #3
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Move data to constant row

    Perhaps next code
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 08-03-2018, 06:27 AM #4
    chandy123987
    chandy123987 is offline
    Forum Contributor
    Join Date
    12-22-2017
    Location
    INDIA
    MS-Off Ver
    EXCEL 2007
    Posts
    106

    Re: Move data to constant row

    Regularly on monthly basis
    Reply With QuoteRegister To Reply
  5. 08-03-2018, 06:33 AM #5
    chandy123987
    chandy123987 is offline
    Forum Contributor
    Join Date
    12-22-2017
    Location
    INDIA
    MS-Off Ver
    EXCEL 2007
    Posts
    106

    Re: Move data to constant row

    It works well but i need this for multiple sheets.
    Reply With QuoteRegister To Reply
  6. 08-03-2018, 07:23 AM #6
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Move data to constant row

    i need this for multiple sheets.
    Is there a list or is it for all sheets ??
    Reply With QuoteRegister To Reply
  7. 08-03-2018, 10:26 AM #7
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Move data to constant row

    Perhaps next code it works for all unhidden sheets
    Please Login or Register  to view this content.
    Last edited by PCI; 08-03-2018 at 11:32 AM.
    Reply With QuoteRegister To Reply
  8. 08-06-2018, 01:41 AM #8
    chandy123987
    chandy123987 is offline
    Forum Contributor
    Join Date
    12-22-2017
    Location
    INDIA
    MS-Off Ver
    EXCEL 2007
    Posts
    106

    Re: Move data to constant row

    it works on all sheets. Thanks
    Reply With QuoteRegister To Reply
  9. 08-06-2018, 04:21 AM #9
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Move data to constant row

    You are welcome.
    itwas good to have a sample file ...!
    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)

Similar Threads

  1. Generate N random numbers whose sum is constant K and constant L by dividing J
    By Eldaoud in forum Excel General
    Replies: 0
    Last Post: 11-11-2015, 04:26 AM
  2. Constant data refresh
    By John19 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2015, 03:36 PM
  3. How to have a data constant that merges upon copying data into the cell from another WB?
    By jonobonz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-19-2015, 11:27 AM
  4. Autofill non-random or consecutive data (constant and multiple values data)
    By etgriffiths in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-22-2013, 09:16 PM
  5. Need to move data that matches criteria in cell and move to new worksheet
    By panagle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2013, 09:23 AM
  6. data source remain constant
    By maryj in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-28-2005, 08:05 AM
  7. [SOLVED] Add a constant to data
    By PaulHardersen in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-26-2005, 05:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1