Results 1 to 2 of 2

VBA Help with Copying cells to new sheet when Column A has an X in it. (workbook attached)

Threaded View

Guest VBA Help with Copying cells... 06-18-2022, 02:22 PM
cytop Re: VBA Help with Copying... 06-19-2022, 02:40 PM
  1. #1
    jjward101
    Guest

    VBA Help with Copying cells to new sheet when Column A has an X in it. (workbook attached)

    Hi. I would like to create a catalog which will house all of the possible materials that I use in doing my job….but would like a scenario where when I place an “X” in column A, all of the materials will be copied to a new sheet, which I called “BOM” in the attached workbook. I am not looking to copy the entire row though….only certain cells. On the BOM sheet is where quantities and the math to calculate selling price will go.
    The cells I am trying to move to the new sheet (labels on both sheets correspond) are Part Number, Description, and List price. (respectively in columns C,D,E on the Catalog sheet).

    The column labeled 'config code' will be used to filter for when a certain project has the same parts needed and is a commonly quoted project.

    Once I have this working, I will be able to quickly and easily put together quotes for customers. New business due to being laid off, so I cannot afford to spend money on a larger scale solution that I know exists.

    I would be truly grateful if someone can help me with this. Trying to keep my family fed.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copying specific range (sample workbook attached as not easy to explain in title!)
    By stevoDE in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-03-2017, 05:01 PM
  2. Replies: 1
    Last Post: 01-09-2015, 04:18 AM
  3. Extracting specific text from a column and copying to another sheet or workbook
    By Noobcake in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-04-2013, 09:29 AM
  4. Copying cells from existing sheets to new row of master sheet in one workbook
    By volcaremos in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-06-2012, 03:53 PM
  5. Replies: 0
    Last Post: 09-18-2012, 09:47 AM
  6. Replies: 0
    Last Post: 09-18-2012, 08:10 AM
  7. Replies: 2
    Last Post: 07-25-2012, 08:11 AM

Tags for this Thread

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