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...
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...
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 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...
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...