Posts by xsmurf

    Hello,


    I use an userform to populate a sheet, and this works fine.

    I have added the option to edit / delete data from the data-sheet, and that works, however it updates the wrong rows when there are empty rows in the data-sheet.

    Every row of data has an serial number, their are no doubles.


    The code that I am using, just for updating (found on a forum and adapted to my needs)

    How can I change the code so it will ignore the empty rows (if there are any).

    Overwriting the wrong rows is not an option.


    Hope someone can help me, really appreciate all the help.

    Hi,


    I hope to get some help here with a problem that I have.


    I have a workbook that retrieves information from different workbooks, this all works well.

    The main problem I have is when there is more then 1 result.


    Please see attached file with a sample.


    Just to clarify the sample is retrieving on a different sheet within the same workbook. The solution needs to be that it needs to retrieve that information from a different workbook.


    Hope you guys can help me out, I would really appreciated it.


    Thanks


    Production Reports_WIP.zip

    Hello,


    I was wondering if something was possible.


    If I make a list on a sheet in cel B3 through the option " Data Validation", and fill it for example with the options "test;test1;test2"
    would it be possible to make userform that reads the list options in cell B3, show them in the userform and be able to add or remove an option?
    So if you want to remove the option "test2" you can do that from within the userform, same if you want to add a option.


    I know you can have a reference to a range of cells, but I want to know if it is possible?


    Thank you.

    Hello,


    I have a question, because I have a problem regarding a VBA code


    I found a code that does only partially what I want.
    I'm trying to highlight dates that are equal or lower then the current date (this date is on a different sheet, called Setup and the date is in cell "F3")
    If there is no date in the range given no formatting should take place.
    And only the range given should be highlighted, and not the rows in between the range.


    Can somebody assist me with this problem, it would be highly appreciated.


    The Code:

    Hi,


    I have a little problem with a code i'm using.


    I have 6 workbooks and one main workbook.
    The 6 workbooks are filled in by 6 different people, this is nto a problem.
    The main workbook is opened when a meeting starts, and with a click on a button all the info from the 6 other workbooks are put in the main sheet. This works pretty good, but with a few flaws.


    The cells that people fill in those 6 workbooks are merged cell ( for example G5:AA5 ), and that data is being copied to the main workbook also in merged cells ( for example G32:AA32 )
    All goes wel as long people stay within the width of the merge cells, if they go outside the width of the merge cells i get an error in the code. That happens also when they use ALT+Enter.


    I know working with merged cells is not the best option within excel, but can't yet find a different solution.


    The fix i like to have : copy the data in the main workbook, in the merged cells, without problems if the cell value is bigger then the merged cells.
    Hope somebody can help me.


    The codes I use are also found on boards, so credits goes to those people.



    The code for collecting the data:


    The code in a module to get the data from one workbook: the row giving a problem is commented


    Thanks for the assist.