+ Reply to Thread
Results 1 to 4 of 4

copy and paste student master data

  1. #1
    Registered User
    Join Date
    02-21-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    64

    copy and paste student master data

    Attached the screen shot the excel sheet
    Student Master Data.png
    Last edited by Excel_Pa; 03-09-2016 at 09:38 AM. Reason: excel screen shot

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,907

    Re: copy and paste student master data

    Your pictures are very nice, but they don't really tell us anything. Please explain in simple English what you are hoping to accomplish.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    02-21-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    64

    Re: copy and paste student master data

    Sorry Alan,

    please find the below details,
    I am currently copying student personal data from excel and past into the intranet webpage manually. I need VBA code where it copy, paste and this information in webpage.
    Current Process:

    1. Copy data from attached screen excel sheet i.e., A4 to G4
    2. Open the intranet Web page………
    3. Press F5/F6 keys as appropriate.
    4. Paste the values in the field allocated in the Web page.
    Note:
    The format used in the web page same as excel format
    All students name already appeared in the web page. No missed student’s name or are ignored.
    F5 & F6 are the function keys giving in the web page. If I press F5 webpage opens Students personal data screen. If I enter F6 webpage open Students academic details.
    5. Save the record in web page
    6. Return to Excel sheet for subsequent record i.e., A5 to G5. This process goes till last record in the excel sheet.

    Please let me know if you need further information.

    Thanks & Regards

  4. #4
    Registered User
    Join Date
    02-21-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    64

    Re: copy and paste student master data

    Could you suggest on below...

    I am currently copying student personal data from excel and past into the intranet webpage manually. I need VBA code where it copy, paste and this information in webpage.
    Current Process:

    1. Copy data from attached screen excel sheet i.e., A4 to G4
    2. Open the intranet Web page………
    3. Press F5/F6 keys as appropriate.
    4. Paste the values in the field allocated in the Web page.
    Note:
    The format used in the web page same as excel format
    All students name already appeared in the web page. No missed student’s name or are ignored.
    F5 & F6 are the function keys giving in the web page. If I press F5 webpage opens Students personal data screen. If I enter F6 webpage open Students academic details.
    5. Save the record in web page
    6. Return to Excel sheet for subsequent record i.e., A5 to G5. This process goes till last record in the excel sheet.

    Please let me know if you need further information.

    Thanks & Regards

+ 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 and paste different workbook data on master sheet
    By irfanparbatani in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-09-2015, 12:03 PM
  2. Copy and Paste data automatically from master sheet to other sheets
    By wschleis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2014, 04:29 PM
  3. [SOLVED] Copy Data all WS from each WB in folder then paste to Master WB
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-06-2014, 11:39 AM
  4. [SOLVED] Macro to copy/paste data into master tab
    By jw01 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-07-2014, 03:04 PM
  5. Copy paste data from a Master file to Multiple Reports
    By spiwere in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 07-21-2013, 01:22 PM
  6. Copy/paste data from different work sheets to master sheet
    By Guckmall in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-03-2013, 08:23 AM
  7. [SOLVED] Stock market data find symbol from csv data file, copy and paste to Master workbook
    By wkurukul in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-21-2012, 10:14 AM

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