Posts by Mumps

    Try:

    Try:

    Could you attach a copy of your file? It would be easier to see how your data is organized and to test possible solutions. Include a detailed explanation

    of what you want to do using a few examples from your data and referring to specific cells, rows, columns and sheets. De-sensitize the data if necessary.

    There would be a couple of issues if you simply copied the rows from market data to template data. First, there are more columns of data in market data than in template data and second, there are some column headers in market data that do not exist in template data. Please clarify in detail. It would be helpful if you could manually create another sheet that shows your desired result including how you want the cells formatted and then attach an updated file.

    Try:

    Please note that you have misspelled the sheet name "Not Awarded" in your file.

    Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your Bids sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make a selection in column I.

    Try:

    Try:

    I can't promise a solution but it would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

    It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific

    cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

    Try:

    Try this macro. Change the sheet array to suit your needs.