+ Reply to Thread
Results 1 to 15 of 15

Cut & paste between sheets

  1. #1
    Forum Contributor
    Join Date
    06-09-2014
    Location
    Philippines
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    143

    Cut & paste between sheets

    Hi Experts,
    I am looking for a macro that will do the things mentioned below

    macro will be placed in a macro.xlsm
    sample.xls & macro.xlsm both are loacted at different places, So the path should be hardcoded in the macro so that i can change it as per my needs
    sheet name can be anything

    If column D of sample.xls is equal to column E of sample.xls Or column D of sample.xls is equal to column F of sample.xls then do nothing else put that data into new sheet by creating a new sheet in it & remove that data from current sheet(plz see the sample file)
    Attached Files Attached Files
    Last edited by MoldyBread; 07-19-2020 at 02:44 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Cut & paste between sheets

    Should it now be a new file or a new sheet? You can use the advanced filter as a basis. Make sure that the column headings are complete.

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    06-09-2014
    Location
    Philippines
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    143

    Re: Cut & paste between sheets

    I reuploaded the sample file plz see Sir & Sorry for the same

    Please Login or Register  to view this content.

    I modified the code as per my needs
    but code is missing column I ,column J data & column K data & i need that data also plz run the macro & see

  4. #4
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Cut & paste between sheets

    See the note in # 2

    Make sure that the column headings are complete.

  5. #5
    Forum Contributor
    Join Date
    06-09-2014
    Location
    Philippines
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    143

    Re: Cut & paste between sheets

    Sir may be heading will be there or there should be chance it is not there

    So plz help me in making this macro workable

  6. #6
    Forum Contributor
    Join Date
    06-09-2014
    Location
    Philippines
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    143

    Re: Cut & paste between sheets

    http://www.eileenslounge.com/viewtopic.php?f=30&t=35000
    https://excelfox.com/forum/showthrea...4701#post14701
    I have cross posted the question, so i shared the link where i posted the question
    Last edited by MoldyBread; 07-21-2020 at 04:02 PM.

  7. #7
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Cut & paste between sheets

    What should we do with the link and what doesn't work? You are not very informative.

  8. #8
    Forum Contributor
    Join Date
    06-09-2014
    Location
    Philippines
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    143

    Re: Cut & paste between sheets

    Sorry Vraag en antwoord Sir
    But Sir i need all data along with column I ,column J data & column K data but the above macro is not pasting the data bcoz it doesn't have headers Sir
    So i am looking for the solution Sir
    It will be a Great Help if u help me in solving this Problem Sir

  9. #9
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Cut & paste between sheets

    I already gave the solution. If you don't understand it, you better not use macros.

  10. #10
    Forum Contributor
    Join Date
    06-09-2014
    Location
    Philippines
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    143

    Re: Cut & paste between sheets

    Thnx Alot Vraag en antwoord Sir for ur Great Suggestion
    give me some time

  11. #11
    Forum Contributor
    Join Date
    06-09-2014
    Location
    Philippines
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    143

    Re: Cut & paste between sheets

    Sorry Vraag en antwoord Sir
    But there will not be header in that column
    So plz modify it so that it can work on that also Sir

  12. #12
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Cut & paste between sheets

    Seems to me something you can easily solve yourself.

  13. #13
    Forum Contributor
    Join Date
    06-09-2014
    Location
    Philippines
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    143

    Re: Cut & paste between sheets

    Sir I am unable to solve this problem Sir
    I thought I can do it
    But I was unable to do so
    That's y I am looking for help Sir

  14. #14
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Cut & paste between sheets

    What doesn't work then? You can still add the column headings manually or via the macro.

  15. #15
    Forum Contributor
    Join Date
    06-09-2014
    Location
    Philippines
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    143

    Re: Cut & paste between sheets

    Sure Sir i will do it manually
    Thnx Alot Vraag en antwoord Sir for helping me in solving this Problem Sir
    Problem Solved
    Have a Awesome Day Sir

+ 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. Copy Paste between sheets
    By HAJANISHA in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 02-23-2020, 01:58 AM
  2. [SOLVED] paste between 2 sheets
    By xam99 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-10-2020, 09:32 AM
  3. Create Sheets, separate records, copy-paste cell values from master to created sheets
    By hishamezzat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2018, 05:31 PM
  4. [SOLVED] Copy Paste From Rawdata Sheets to Multiple Sheets Based on Sheet names
    By farrukh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-16-2017, 11:01 PM
  5. cut and paste and navigating betwwen sheets and deleting extra sheets
    By bmbalamurali in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-10-2014, 01:13 PM
  6. [SOLVED] copy and paste values of all sheets into new sheets
    By greatjobtoday in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-20-2012, 01:44 PM
  7. Cut and paste across sheets
    By gigz42 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-11-2011, 03:45 PM

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