Search results

Hi Tom, Please upload the file with the Macro, it should be a .xlxm file

Hi Allyson, did something similar here, have a look it might be what you are after http://chandoo.org/forum/threads/multiple-dependencies-for-a-drop-down-list.13889/#post-83051

Hi Tom, Please upload the file it would make it easier to solve the problem as I am not sure when you are working whit any particular workbook kanti

Hi Pooja, Glad it worked, if you are asking about the code I added, Set rTable = Sheets("MasterData").Range("A1").CurrentRegion Set rTable = rTable.Resize(rTable.Rows.Count - 1) Set rTable = rTable.Offset(1) rTable.Clear You will note that I have a small sub GetRange2Clear() called in...

@Arvennis, Sorry that I did not upload the file and that I missed your post. Here is the file, let me know if you need more help

Hi Pooja, thank you for the file, here is the file with a change to the macro, the macro clears the whole table before it starts with the loop. Please check and let me know if it is OK kanti

Hi Put a comma between your Headers as such: Range("Table1[aa],Table1[bb]").Select regards kanti

Hi Pooja, Can you upload the file with the macro, so that i can identify the range that needs to be cleared, before the data is copied from the other file.

Hi Pooja, try this, I have added a line after the Loop statement Loop Range("B2").select 'activates sheet of specific name Worksheets("Dashboard Project view").Activate Exit Sub kanti

Hi Johan, I am not sure that you can do it, the closest you can get is to filter the Rows, with Contains... and if you then enter Eurasia you will get only those with Eurasia

Happy to oblige

Hi AZExcel, You should convert the input area to a table, but before you that put Headers in al columns. That would force the formulas into new rows that you enter kanti

Hi Arvennis, In the attached spreadsheet is an example of finding the address for a formula in VBA, you can adapt it to suit your purpose. If you need more help with this let me know. kanti

Hi Hui, I did not start the poll, I just clicked to open the thread and that screen popped up, did I do something wrong, Hit or Click something? cheers & thanks kanti

Hi Minhaj, Here is the code to find an address and use it in a formula. Sub BuildFormula() With Sheets("Mech") Set rFound = .Columns(4).Find(What:="aaa", After:=.Cells(1, 4), _ LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, _ SearchDirection:=xlNext...

Hi Tazz, Looked at your file, is the BEFORE one set of data, and how do you differentiate between what goes where, in other words how do you decide that any particular cell will go into another cell on AFTER. You have all the colours on AFTER, how do you decide what colour any of the cells is...

is C92, input or a calculated result? If calculated what are the inputs and formula that give the resulting 9

The amounts that you are calculating the interest on, is that a transaction or is that a balance? If it is a balance then the calculations are correct. Does the interest kick-in from the day of the transaction or after it becomes overdue? So you may have incurred the debit today, but no...

That has been accounted for in my calculation, but let us have the charges as per the bank otherwise I cannot give you an answer. Have you confirmed with the bank the calculation, I also note that there are blank for certain Credit entries and not for others, so without a full picture, I cannot...

Where does this number come from, how is it calculated and PLEASE do not tell me it is a bit off, it means nothing

That does not help, we need to know what the numbers are that are not the same, anyway look at the file I posted

Hi, Please check out the attached file, you should have adapted the formula I posted earlier and applied it to your problem!

Hi Chaptzem1, I need to understand your worksheet, do you have the actual amounts charged by the bank? it would be good to know what the correct result should be.

Hi Chaptzem1, Have you checked with the bank on how they charge the interest, to my knowledge interest when charged is added to the account and this should occur at least once per year, or 12 times or 4 time etc. Once the interest is charged it is added to the capital and then interest is...

Try this formula to get 366 for leap years and 365 for others, it assumes the date is in A1 =IF(MOD((YEAR(A1)),4)>0,365,366) regards kanti