Results 1 to 26 of 26

Macro to copy/paste info in different sheets and to delete last entry

Threaded View

barcas84 Macro to copy/paste info in... 01-17-2012, 05:14 PM
JBeaucaire Re: Macro to copy/paste info... 01-17-2012, 08:50 PM
barcas84 Re: Macro to copy/paste info... 01-19-2012, 10:48 AM
JBeaucaire Re: Macro to copy/paste info... 01-19-2012, 11:15 AM
barcas84 Re: Macro to copy/paste info... 01-31-2012, 12:21 PM
barcas84 Re: Macro to copy/paste info... 01-19-2012, 12:13 PM
JBeaucaire Re: Macro to copy/paste info... 01-19-2012, 04:00 PM
barcas84 Re: Macro to copy/paste info... 01-19-2012, 04:14 PM
barcas84 Re: Macro to copy/paste info... 01-24-2012, 12:21 PM
barcas84 Re: Macro to copy/paste info... 01-24-2012, 12:23 PM
JBeaucaire Re: Macro to copy/paste info... 01-31-2012, 12:43 PM
barcas84 Re: Macro to copy/paste info... 01-31-2012, 01:36 PM
JBeaucaire Re: Macro to copy/paste info... 01-31-2012, 01:50 PM
barcas84 Re: Macro to copy/paste info... 01-31-2012, 02:07 PM
JBeaucaire Re: Macro to copy/paste info... 01-31-2012, 07:57 PM
barcas84 Re: Macro to copy/paste info... 02-01-2012, 09:50 AM
JBeaucaire Re: Macro to copy/paste info... 02-01-2012, 11:07 AM
JBeaucaire Re: Macro to copy/paste info... 02-01-2012, 11:17 AM
barcas84 Re: Macro to copy/paste info... 02-01-2012, 11:40 AM
JBeaucaire Re: Macro to copy/paste info... 02-01-2012, 03:04 PM
barcas84 Re: Macro to copy/paste info... 02-01-2012, 05:42 PM
barcas84 Re: Macro to copy/paste info... 02-01-2012, 04:57 PM
JBeaucaire Re: Macro to copy/paste info... 02-02-2012, 11:13 AM
barcas84 Re: Macro to copy/paste info... 02-02-2012, 11:59 AM
JBeaucaire Re: Macro to copy/paste info... 02-02-2012, 02:17 PM
barcas84 Re: Macro to copy/paste info... 02-02-2012, 02:30 PM
  1. #1
    Registered User
    Join Date
    04-26-2011
    Location
    NY
    MS-Off Ver
    Excel 2010
    Posts
    40

    Macro to copy/paste info in different sheets and to delete last entry

    Hello, I need a macro that will do the following:

    Copy from Sheet "DataEntry" C22 and paste it in Sheet "Calculations1" (E29)
    Copy from Sheet "DataEntry" E22 and paste it in Sheet "Calculations1" (G29)
    Copy from Sheet "DataEntry" C25 and paste it in Sheet "Calculations1" (E33)
    Copy from Sheet "DataEntry" E25 and paste it in Sheet "Calculations1" (G33)
    Copy from Sheet "DataEntry" G24 and paste it in Sheet "Calculations1" (E31)

    Every time the macro is executed I will do the same operation but to the next sheet called: "Calculations2", then "Calculations3"...and like that until "Calculations50" once it reaches Calculations50, if the macro is executed again it will display a window message like: "You can't enter more data"

    Also I will need a macro to delete the last entry of the previous macro, so that every time you execute it it will delete the last entry...and you can do it as many times as you want until you've deleted all of them.

    Thank you!
    Last edited by barcas84; 02-01-2012 at 09:50 AM.

Thread Information

Users Browsing this Thread

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

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