+ Reply to Thread
Results 1 to 5 of 5

Create a Macro

  1. #1
    Valued Forum Contributor
    Join Date
    05-07-2014
    Location
    India
    MS-Off Ver
    MS Office 365
    Posts
    313

    Create a Macro

    Hi All,

    I am new in VBA, and I want to learn it. I want to know how I can write the VBA code to copy and paste the data from 3 workbooks in a workbook. My problem is every time when I will receive the data columns would be fixed but row number would not be fixed.

    Please help me to write a macro for the same.

    Regards
    Nisha

  2. #2
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,332

    Re: Create a Macro

    Could u please provide sample source workbook file and master workbook where u want to copy it will make easy to provide perfect macro
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    Home 2013 on Win10, Home 2007 on Win10, Work 2013 on Win7
    Posts
    7,985

    Re: Create a Macro

    Hi, Nisha,

    you would need to be more specific about what you want to do: copy to only one worksheet (summarize on that sheet) or dfifferent worksheets (add new ones if needed or fill up existing ones).

    A Google search should have brought up links like https://sites.google.com/a/madrocket...s-to-one-sheet or https://sites.google.com/a/madrocket.../wbs-to-sheets.

    Ciao,
    Holger
    Last edited by JBeaucaire; 12-26-2019 at 04:28 PM.
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  4. #4
    Valued Forum Contributor
    Join Date
    05-07-2014
    Location
    India
    MS-Off Ver
    MS Office 365
    Posts
    313

    Re: Create a Macro

    Hi,

    Please find the attached data, I have putted the 3 workbook's data in a workbook in different sheets.
    Attached Files Attached Files

  5. #5
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    Home 2013 on Win10, Home 2007 on Win10, Work 2013 on Win7
    Posts
    7,985

    Re: Create a Macro

    Hi Nisha,

    looks to me as if the first link I posted will suit your needs.

    Ciao,
    Holger

+ Reply to Thread

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