Posts by Mumps

    Try:

    This macro assumes you have a sheet named "Shee2" with these headers in row 1.

    id name value


    Try:

    Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your Sheet2 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 A3, then make a selection in B3 and lastly, make a selection in C3. It is very important that the selection in C3 is made last because that selection triggers the macro.

    Before testing it on all the sheets, try this code in the code module for the "Temp" sheet and see how it works.

    Could you attach copies of your two files? 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.

    It is hard to work with a picture. 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.

    In the code you posted, you refer to G4 as the target cell and H5 as the reference cell. Looking at your FARES file, those cells are blank in all the sheets and are formatted as "General". In which specific sheets do you want to format the cells and what is the target cell and reference cell? I used E7 on Sheet1 as the target cell because that cell contains the currency codes. Please clarify in detail.

    Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your 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 E7.

    Try: