Results 1 to 5 of 5

macro or vba code for copying and pasting data from one worksheet to another

Threaded View

jruiz13 macro or vba code for copying... 10-03-2011, 06:50 AM
arlu1201 Re: macro or vba code for... 10-03-2011, 07:43 AM
royUK Re: macro or vba code for... 10-03-2011, 08:00 AM
jruiz13 Re: macro or vba code for... 10-03-2011, 09:06 AM
arlu1201 Re: macro or vba code for... 10-03-2011, 10:05 AM
  1. #1
    Registered User
    Join Date
    10-03-2011
    Location
    abu dhabi
    MS-Off Ver
    Excel 2003
    Posts
    2

    macro or vba code for copying and pasting data from one worksheet to another

    hi there,

    need some help guys on getting a macro or vba code for copying data from one worksheet to another. on the attached file, i have mentioned on dark grey filled with bold text the constant parameters i need to copy or transfer every day on the dBase sheet next to it. can you please help me setting up a code that will work for this situation? i find it really hard to construct a vba code that will pull up the date, description, vessel type, etc. etc and paste it on the next sheet.i would like to have it on a single button that after clicking it auto populates the data i need on the other sheet on the corresponding headings. also, i want to protect the data into it to make sure that nobody can mess around with it . would appreciate any assistance. thank you very much for helping out.
    Attached Files Attached Files

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