Search results

Hi chirayu, Khalid and Badale, Thank you very much for the offered solutions. They sure meet my requirement and the offered solutions are very inspirational on approaching and solving Excel challenges! Thanks again. Brems

Hi, I have a file with some hard-coded conditional formatting. I attached an example. The conditions for formatting the cells are hard-coded in the conditional formatting itself but I want to have the possibility to have the conditions refer to the cells C2, C3 and C4. I know this is possible...

Hi Jon, Thank you very much for the link. I'll try this later this day and I'll keep you posted. Have a nice day! Wim

Hello, I may be posting it in the wrong place but I don't know if it can be done without a macro. I have an excel sheet (input) where the user has to complete some fields. On the sheet there is a button to transmit the entered data to another sheet. Let's call this sheet MainSheet. The...

I have an additional question. I'm trying to understand the used formula but at the moment it's still to abstract. Can you point me to some recommended reading? Especially the use of ROW isn't very clear. Thanks!

Hi Debraj, Unfortunately I can one click 'like' once. ;)) Fortunately this is EXACTLY what I was looking for. Thank you very much!! Wim

Hi, I'm trying to find a solution for a simple challenge (aka problem). In a chart I'm displaying 8 quarters of data. (2014 en 2015) As soon as the first quarter of 2016 starts the oldest value (2014 Q1) must be omitted and the new value (2016 Q1) must be added. Each start of a new quarter...

Hi Sajan and shrivallabha, Thanks a lot for sharing this solution. Works perfect! :) I learned again...

Hi all, It may already be treated on the forum but I didn't find it. Nor did I find an applicable solution for this problem on the internet. I want to find the 7 most recent dates in a table but each date is listed more then once. I already succeeded in filtering unique dates but these are...

Hi r1c1, Works EXCELLENT! It's just great.:) Thank you very much. Wim

Hi dan_I, Can you explain your question a bit more please?

sorry, password is: vakpla damn, and it ain't monday... o_O I'm not at all expecting a complete solution. Just a hint to get me started again would be great. :)

Allright... I think it's ready. :) sheet 'db afdelingen' is the dashboard. Some results don't display correct anymore due to the changes. sheet 'db AM' is the sheet where you can specify the 6 criteria and the date range. I want to create a similar dashboard like the sheet 'db afdelingen'...

I'll do that Smallman. Thanks!

Hello, I'm writing a bit more of the explanation because I don't (yet) have an example to add. And my boss wouldn't be very happy when throwing the original data on the internet. ;) I have an excel sheet with a table in and I made a dashboard where the user can define 3 criteria by means of a...

Hi Narayan, Looks fine to me! I tried the code below with the two workbooks open but I got an error message 1004. ActiveWorkbook.ChangeLink Name:="I:\Kader\Rapporteringen\Coachingsdocumenten\coachingcijfers db.xlsx", _ NewName:="I:\Kader\Rapporteringen\Coachingsdocumenten\test.xlsx"...

Hi, I'm using the following code to merge all worksheets of the two workbooks to one new workbook. The formulas in the new document still link to the previous (unmerged) documents. Is there a way this can be solved by adding some code? The formula links must link to the data in the new...

Hi Narayan, This solution works excellent! It seemed that I was complicating things to much... :)) Thank you again for your assistance. Much appreciated. Regards Wim

Hi bobhc, Excellent idea! I posted a sample file on the following link. https://docs.google.com/spreadsheet/ccc?key=0Av-NhSp9ULywdEtzWkN3YzJNX2RFd3ZoUHlOLUN4ZkE&usp=sharing I've seen with the upload in google docs that some formulas stopped working. The begin cell for the range is on...

Hello to all, I want to count a certain value on different tabs. Therefor I started to determine to the range within the formula needs to look. Starting point was determined with the formulas MATCH and ADDRESS. This resulted in cel B6 as the starting point of my range. Then I worked the same...

Hi SirJB7, Luke and Narayan, Thanks for your assistance. The trick with the single and the double quotes worked perfect. This is the result and it permitted me to fetch a lot of data in a very quick way from all the different tabs in my workbook...

How did you work around? Just being curious and sure we can learn from it... Thanks for sharing.

Hi Narayan, That's correct. Like I wrote in my previous post, I wasn't able to apply Luke's solution. Somehow, with all the variations with the quotes I tried, Excel returned an error message. Since my first reference (tab) isn't text I wasn't able to apply those quotes. Probably, I'm...

Hi, I would solve it this way: type in cell b1 in sheet 2 assuming your values on each sheet are in column A: =IF(A1=LOOKUP(A1;sheet1!$A$1:$A$6);"Present";"Not Present") Hope this works regards Wim

Hi Luke, Thanks for your quick response to my question. I added an example file which you can find with the link below. The strange thins is, that when I uploaded in Google Docs my formule worked perfectly but when I view it in Excel 2010 I get the #ref-error. I didn't manage to apply your...