+ Reply to Thread
Results 1 to 18 of 18

Partnumber updates to the generated document in the excel

  1. 10-14-2014, 11:07 AM #1
    laxmanann
    laxmanann is offline
    Forum Contributor
    Join Date
    02-19-2014
    Location
    NJ
    MS-Off Ver
    Excel 2010
    Posts
    308

    Partnumber updates to the generated document in the excel

    Hi,

    Please see the attachment. Containing system generated report.
    But I need the part numbers in each sheet Column D. and Column E as quantity.
    To be pasted in new created sheet name Master. Looks as shown in the Partnumber_format sheet.
    I have to copy all the part number are in columd D in each sheet and generate result in new sheet name as master.


    Thanks,
    lax
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-15-2014, 03:15 AM #2
    noboffinme
    noboffinme is offline
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,071

    Re: Partnumber updates to the generated document in the excel

    Hi laxmanann,

    Do you want to collect the data in Column 'D' & 'E' of the 'Test123' file & paste it into Column 'B' of the 'Partnumber ...' file?

    For example, you have the value '1915329' in Cell 'D17' on 'Sheet1' of the 'Test123' file.

    Can you explain, as clearly as I've done here, exactly what's to come from where & go to where & what value is common bewteen the data?

    Thanks
    Remember you are unique, like everyone else
    Reply With QuoteRegister To Reply
  3. 10-15-2014, 03:33 AM #3
    laxmanann
    laxmanann is offline
    Forum Contributor
    Join Date
    02-19-2014
    Location
    NJ
    MS-Off Ver
    Excel 2010
    Posts
    308

    Re: Partnumber updates to the generated document in the excel

    Dear Nob,

    Thanks for the interest and thanks for the rsponse..
    Please see the attachment. Containing system generated report. But I need the part numbers in each sheet Column D. and Column E as quantity. To be pasted in new created sheet name Master. Looks as shown in below.That new master sheet may be the last Should we name it as Master sheet..

    I have attached the sample snapshot here..of the result Master sheet of the workbook

    Let me know for the questions if any.


    Thanks again
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  4. 10-15-2014, 03:56 AM #4
    laxmanann
    laxmanann is offline
    Forum Contributor
    Join Date
    02-19-2014
    Location
    NJ
    MS-Off Ver
    Excel 2010
    Posts
    308

    Re: Partnumber updates to the generated document in the excel

    Attaching the 2 Attachements with highlights for more to understand.

    Thanks,
    lax
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  5. 10-15-2014, 04:38 AM #5
    noboffinme
    noboffinme is offline
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,071

    Re: Partnumber updates to the generated document in the excel

    Your attachments won't open.
    Reply With QuoteRegister To Reply
  6. 10-15-2014, 04:45 AM #6
    laxmanann
    laxmanann is offline
    Forum Contributor
    Join Date
    02-19-2014
    Location
    NJ
    MS-Off Ver
    Excel 2010
    Posts
    308

    Re: Partnumber updates to the generated document in the excel

    123456.jpgRe attaching the Workbook and snapshot
    Reply With QuoteRegister To Reply
  7. 10-15-2014, 04:48 AM #7
    laxmanann
    laxmanann is offline
    Forum Contributor
    Join Date
    02-19-2014
    Location
    NJ
    MS-Off Ver
    Excel 2010
    Posts
    308

    Re: Partnumber updates to the generated document in the excel

    Attaching file in ZIP format
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 10-15-2014, 04:50 AM #8
    laxmanann
    laxmanann is offline
    Forum Contributor
    Join Date
    02-19-2014
    Location
    NJ
    MS-Off Ver
    Excel 2010
    Posts
    308

    Re: Partnumber updates to the generated document in the excel

    Dear Nob,please confirm whether attachements are open else i wl try to attache in some other way..Please tell me if you have any idea to attach the files to view.
    Reply With QuoteRegister To Reply
  9. 10-15-2014, 06:22 AM #9
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Partnumber updates to the generated document in the excel

    Hi laxmanann ,
    the part number are in merged cell from D to F
    and the quantity are in merged cell from g to h

    The requirement is to generate the master sheet with all the parts in various sheet & sum the respective qty. in all sheet ?

    Am i correct
    Reply With QuoteRegister To Reply
  10. 10-15-2014, 06:29 AM #10
    laxmanann
    laxmanann is offline
    Forum Contributor
    Join Date
    02-19-2014
    Location
    NJ
    MS-Off Ver
    Excel 2010
    Posts
    308

    Re: Partnumber updates to the generated document in the excel

    Dear Punnam ,

    Exactly...i want to paste the partnumber and Quantity in a new generated master sheet.Please refer the attached ZIp files present it the post #7 which has all the information with Clear Snapshot..Kindly let me know if you need more info on that.

    Thanks in advance,
    lax
    Reply With QuoteRegister To Reply
  11. 10-15-2014, 06:34 AM #11
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Partnumber updates to the generated document in the excel

    do u get the data in merged D to F & G to H ?

    Punnam
    Reply With QuoteRegister To Reply
  12. 10-15-2014, 06:43 AM #12
    Naveed Raza
    Naveed Raza is offline
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Partnumber updates to the generated document in the excel

    Laxmanann

    you want all partnumbers & quantity from all available worksheets in new master workbook is it ?
    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.
    Reply With QuoteRegister To Reply
  13. 10-15-2014, 06:45 AM #13
    laxmanann
    laxmanann is offline
    Forum Contributor
    Join Date
    02-19-2014
    Location
    NJ
    MS-Off Ver
    Excel 2010
    Posts
    308

    Re: Partnumber updates to the generated document in the excel

    Dear Punnam,

    Actually the Values of part number present in the Merged Cells of (D-F) and the Quantity values present right side of the partnumber(G-H).
    When i Run macro these two values should locate the final Sheet("master sheet").The sample of the output format has been attached in the pOst#1 <<Sheet name is Partnumber-Sample format.xlsx‎>>

    Merged cells not a pbm..We have to take the Values alone from that system Generated report.

    Thanks,
    lax
    Reply With QuoteRegister To Reply
  14. 10-15-2014, 06:46 AM #14
    laxmanann
    laxmanann is offline
    Forum Contributor
    Join Date
    02-19-2014
    Location
    NJ
    MS-Off Ver
    Excel 2010
    Posts
    308

    Re: Partnumber updates to the generated document in the excel

    Dear Naveed,

    Yes Exactly brother..Thanks
    Reply With QuoteRegister To Reply
  15. 10-15-2014, 07:29 AM #15
    Naveed Raza
    Naveed Raza is offline
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Partnumber updates to the generated document in the excel

    Quote Originally Posted by laxmanann View Post
    Dear Naveed,

    Yes Exactly brother..Thanks
    Laxmanann

    please find the enclosed Master Macro File and follow the steps.
    1. Open the Macro File & click on button
    2. It will ask you to open system generated file and open it
    3. Output will display at Macro File

    Note: I prepared macro based on provide Excel File which is in ZIP.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  16. 10-15-2014, 08:00 AM #16
    laxmanann
    laxmanann is offline
    Forum Contributor
    Join Date
    02-19-2014
    Location
    NJ
    MS-Off Ver
    Excel 2010
    Posts
    308

    Re: Partnumber updates to the generated document in the excel

    Dear Naveed,

    This is expected man..it is working like a charm..Thanks for your expensive time.Added reputation also

    lax
    Reply With QuoteRegister To Reply
  17. 10-15-2014, 08:27 AM #17
    Naveed Raza
    Naveed Raza is offline
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Partnumber updates to the generated document in the excel

    Quote Originally Posted by laxmanann View Post
    Dear Naveed,

    This is expected man..it is working like a charm..Thanks for your expensive time.Added reputation also

    lax
    Glad to help bro and thanks for reputation and please mark this thread as SOLVED
    Reply With QuoteRegister To Reply
  18. 10-15-2014, 12:36 PM #18
    HaHoBe
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Partnumber updates to the generated document in the excel

    Hi, Naveed Raza,

    please have a good and thorough read at Forum Rule #12 - do not quote full posts.

    Ciao,
    Holger
    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
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Pre-generated document, no access to macros, help?
    By baconrhae in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-26-2012, 09:59 AM
  2. Create another excel document that updates when original updates
    By SandyF in forum Excel General
    Replies: 3
    Last Post: 03-04-2011, 06:01 AM
  3. Formula only updates cell when document saved or...
    By john_london in forum Excel General
    Replies: 2
    Last Post: 09-21-2010, 04:41 PM
  4. Benefits of using template in generated word document?
    By ChrisMattock in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2006, 10:41 AM
  5. FILTER PARTNUMBER Where it match all 3 Regions
    By Juan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2005, 07:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1