Search results

Thanks for your valuable inputs, I found out I can do it multiple ways with guidance you both provided. Again my sincere thanks

Thankyou very much both of you to give me a solution. I appreciate time and patience you put in for providing me solutions. Will update about results

Its not necessary to follow the same extension but any guidance on how to create it is much appreciated. Thanks

I have a file extension like this H:\Accounts\Mthly Report\FY 2017\07.2017\WESTPAC\JUL_2017 Westpac Bank Statement.xlsx Lots of file directory remains the same but few things changes For example Year 2017 Month 07 or Jul I have used following formula to determine the variables...

My sincere apologies I realized that the mistake was from my end as I was unable to put the correct code when working on offset formula. I again sincerely apologies for the inconvenience I caused and look forward for your guidance from both of you. Thanks

Appreciate your guidance in looking and telling me what is wrong in the code below Sub acc() Dim I As Integer Dim AA As Integer Dim B As Integer AA = 16 B = (Range("b16").End(xlDown).Row) For I = AA To B Range("J" & I).Value = Application.WorksheetFunction.If(Range("P" & I).Value <> 0...

Unfortunately that's not the case and hence the reason I need a variable

My sincere apologies I should have replied earlier. However I was able to test few things and it worked perfectly. Here is the code Sub Comms() Dim A As Worksheet Dim I As Integer (This was the variable in the Code) Dim AA As Integer Dim B As Integer AA = 2 (This was the counter setup I was...

I have a situation where I am writing a macro, What macro is supposed to do is (i have also written If I have done it or not) 1. Select the range from C3:G3 in a specific sheet (Achieved) 2. Copy it and take it another specific sheet (Achieved) 3.Go to the last row (Achieved) 4. Add a row and...

Many Thanks P45cal, Its exactly what I was looking for

Hi, I need help in following when you press the Display Items Button it will show you a form, I select the value in ComboBox1(Item) and I want listbox1 (Current Price) to display the value of Current Price based on vlookup value from ComboBox1(Item) selection and lastly if I want to update the...

Hi Mate, You need to show me where you encountered the problem, from there i can help

You are welcome

Hi Zeroflag, I have attached a file for you its a sample base on how to do it, What you need to to do is go in Developers Tab, Select a combo box from ActiveX Control. Once you place Combo Box in desired cell in my case it was A1, but i spread the Combo Box till Cell C1 or D1 to give it extra...

i AM QUITE SURE THIS NOT A DATA VALIDATION BUT RATHER THE COMBO BOX

Glad to be of any assistance. Do let me know if you find sone issues

You are Welcome!

Hi Mate, I looked into your file and you have Two Control requirements as I can see 1. Team can't play on same ground again 2. No Same opponent in the same Round Unfortunately as the matrix structure can't be same for both control requirement, this means you either need a VBA code or you need...

I believe in that case use a control column in which you will use text formula something like =text(A2,"mmyy"). There you have a control field and now you can setup the sumif formula. I hope this helps

My suggestion would be use Pivot Table. When you click inside Pivot Table you will see the setting how I arranged it, lastly when inside the Pivot Table just go to Row Labels Right Click on it, you will see Group Option Select Month, Your Dashboard is done, if you want it to appear single month...

This should be fairly simple. Just copy the range where your conditional Formatting Exist and paste it into new SpreadSheet as Paste Special and select Format, it should bring in all your Conditional Formatting in the new sheet, my assumption is all other factors remains same. Hope this helps

Hi Mate, Had a quick look at your excel sheet, there is a small irregularity in your data, All addresses are supposed to have a Street Number and for PO Box you can leave it the way it is, Once you fixed that, than just simply select the address column>>Data>>Text to...