Search results

Dear all, I'm looking for a way to seperate the last name of a total name in a colum. I'm already familiar with the text to column option but thing is that then i get the name like this: First name; between verb; last name And I only want the last name. It is list with Dutch names with...

Thanks Hui, you're the man!

Dear all, I build a dashboard. Not sometimes this dashboard gives me a little hassle because the point of reference does not contain a value or contains #REF! Does anybody no a way in which I do not get a #HREF error when the reference point does not contain a value but for example a 0. Dear...

Sweet! Thanks Hui!

Dear all, I'm looking for a macro with which I can select a certain part of a sheet, then press a short key and then for the selecter area for a certain format (for example times new roman 12). Anybody some input on a script I can use for this? Dear regards, Marc

Dear all, I'm looking for a way for combine a IF THEN and VLOOKUP function. I need to perform a VLOOKUP and if the value is not in the VLOOKUP list, it has to show the value "NOT" (in stead of "N/A". Anybody some input on how i can do this? Dear regards, Marc

Dear all, Im working on a macro to type in certain information in a sheet by input boxes (see code below). Thing is that a want the macro to fill in the data below the last record. So the first it should insert info in a1, b1, c1 and next time in a2, b2, c2 etc… Can anybody tell me how I can...

Just data like 1 - 12

@Luke M: thanks for your reply but that does not work. Your solution does not quite work out though. Example of what I’m looking for. If have several case numbers in column D of the year 2012. In column E i have the month values. Based on the month I put in cell E2. So dependent on the values...

Dear all, I want to perform a countif based on criteria. So if one value is the same as the one I type in on my management dashboard the amount of policies issued of that month. So i'm basically looking for the sumif functionality range; criteria; sumrange) but then in stead of sum if has...

Hi all, I use several sheets where I have drop down lists and, based on the factor I select, certain information pops up on my screen. I'm getting tired however of having to use my mouse everytime to open the datavalidation list. Does anybody know a keyboard shortcut with which I can use a...

Dear all, I have a small problem. I want to use the concatenate function to merge a word (average) and a sum of a column. I works fine, only thing is that it show 8 digits behind the comma (and I can't adjust that using format cells. Anybody any help on this? Dear Regards, Marc

Thanks for the solution, this works!

Dear all, I'm working with a sheet now in which I have to use a vlookup functions for a whole row. because the rowsize of the table change everytime I just created a macro which performs a vlookup from row 1-100. But now I get N/A for all value which are not filled in. Does anybody know a...

Thanks!

Hui, it worked out really well for a while. But now it only updates on of all the records... So I got different Brokers which have to be transfered to another sheet but it only takes the last one. You know what might be the problem??

Thanks Hui!

Dear all, I working on a sheet in which i would like to seperate certain records from one page on the next tabs in the file. On the main page I have an overview of agents; brokers and other customers with their adresses and I would like to create an overview in the next tabs with one page...