Results 1 to 6 of 6

I have to move data from one row to antoher row, but in different position (cell)

Threaded View

  1. #1
    Registered User
    Join Date
    08-14-2020
    Location
    Frankfurt,Germany
    MS-Off Ver
    Office365
    Posts
    2

    I have to move data from one row to antoher row, but in different position (cell)

    HI to Forum!

    Thank you Admin for tips and message, hope now is better :-)

    So, I have Excel files and some data are in wrong place - 2 cells left and one row down.
    Excel is from Office365.


    I have to do a following task:

    Complete row 129,131,133,135 etc... (start with cell B129,C129,D129 etc.) have to be moved on row 128,130,132,134 etc. start with cell D128,D130,D132,D134...

    That mean B129 to D128, C129 to E128 etc...

    In this case, all contents from other cells (B129,C129,D129...) fit correctly in rest of table - B129 is actually D128, C129 is E129 etc.

    So I have actually move content of complete row 129,131,133 etc... 2 cells on the right and one row up.

    I can do this manually, copy one by one, but this is not an option, file is about 35MB and I have to do this every week.

    In attachment you can find a part of file, first two rows are correct and the others have to have same look as the first two rows.
    Also there's another pattern start at row 76 (emtpy row and then pattern as I described)

    Any help/advice are welcome:-)

    Best regards to all:-)
    Attached Files Attached Files
    Last edited by Hooper100; 08-14-2020 at 02:41 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. IF function advice needed
    By mairead100 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-12-2014, 06:59 AM
  2. VB/ Formula advice needed
    By DanUK86 in forum Excel General
    Replies: 4
    Last Post: 09-10-2009, 07:57 AM
  3. help advice needed
    By stevencarroll19 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-30-2006, 12:00 PM
  4. Formula Advice Needed
    By Brad_A in forum Excel General
    Replies: 1
    Last Post: 03-03-2005, 03:06 PM
  5. advice needed
    By Duncan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-27-2005, 07:06 PM
  6. Advice needed...
    By Duncan in forum Excel General
    Replies: 3
    Last Post: 01-27-2005, 05:06 PM
  7. advice needed
    By Duncan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2005, 04: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1