+ Reply to Thread
Results 1 to 5 of 5

A code that will copy a cell and put i in a workbook

  1. #1
    Registered User
    Join Date
    05-30-2012
    Location
    Houston,Texas
    MS-Off Ver
    Excel 2007
    Posts
    24

    A code that will copy a cell and put i in a workbook

    Hi everyone,

    This is Excelmanineedhelp and i need help with making a code. So I have a macro already but what need help with is making a code that will first open then print the stored values in a workbook called Results. So this marco that i am using is being used in more than one workbook so when the stored value is printed in the workbook called Results, in column A it should have the name of the workbook that the stored value came from and in column C it should have the actual stored value. Here is my macro that Tigeravatar help me with. The bolded and underlined part of the macro is need to be printed in the Result workbook but i still want the macro to do everything the same i just want the value to also to be printed in the Results workbook


    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: A code that will copy a cell and put i in a workbook

    Do you have a sample file that you use along with this code?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    05-30-2012
    Location
    Houston,Texas
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: A code that will copy a cell and put i in a workbook

    Here is an example workbook
    Last edited by Excelmanineedhelp; 06-15-2012 at 11:11 AM.

  4. #4
    Forum Guru tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: A code that will copy a cell and put i in a workbook

    Excelmanineedhelp,

    Updated code, be sure to change the path and file name to what it actually is:
    Please Login or Register  to view this content.
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  5. #5
    Registered User
    Join Date
    05-30-2012
    Location
    Houston,Texas
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: A code that will copy a cell and put i in a workbook

    Thank you Tigeravatar for all you help. It would have took me months to do what you did in a couple of minutes.

+ 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