Excel Forum

Thank you for always help!

thank you for your nice solution.i come up with a formula =IF( OR( MONTH(DATEVALUE(G$2&" 1")) < MONTH($B3), MONTH(DATEVALUE(G$2&" 1")) > MONTH($C3) ), "-",IF(MONTH(DATEVALUE(G$2&" 1")) = MONTH($C3), ROUND($E3 - SUM($F3:F3), 2), ROUND($E3/$D3, 2) ) )

Thx,will take a look

Hi Dear! I have data in B2:H4 i need to generate allocation of prepaid expense base on amount from start date to end date.I need to generate even amount but only two dicimal so the last amount may be a bit different to adjust sum of the allocation equals to the base amount. Previously ,I used this f...

thank you so much

Possible solution with Lookup (char(255),A$10:A10)?

Thanks it works

Can it be done with excel 365 dynamic array?

I want to copy previous data base on month in S2.if S2 is Sep-23 I like to copy column Aug-23 as formula to column Sep-23 .it means if S2 matches header F5:Q5 it will copy left column of it as formula and column on the left itself as values.....

I need to copy previous month data to current month data base on S2 ,,,,,,,,,,, Sub CopyData() Dim month As Date Dim colHeader As Range, currMonthCol As Range, prevMonthCol As Range, formulaCol As Range, valuesCol As Range ' Get the month selected in S2 month = Range("S2").Value ' Look for...

here is attached

Hi there ,
i need your help how to show ID base on number of values in column a.for example if column a listed 1 to 12 it has to show ID from the above of column a and paste it column c

thanks

Sorry for not clarifying of the problem.the code you gave it copied formula from I502 I291.I502 formula is deduct one cell from another.i want to refer I502 to I291 meant that I291=-I502 .hope it is clear.thanks

The code works but this line .Range("I502").Copy Destination:=.Range("I291")
.Range("I999").Copy Destination:=.Range("I788")
I mean cell I291=-I502
I788=-I999

Hi there! i need your help with vba macro to copy values from closed workbook named Book1.my code did not work properly. Sub CopyData() Dim wb As Workbook Set wb = Workbooks.Open("C:\Users\Desktop\Book1.xlsx") With ThisWorkbook.Sheets("HO_TB") ' Copy data from "Sheet HO_ TB&...

thanks

i try when run code it shows nothing

I run code it happens nothing .i want to pupulate if col A has the word " Total " populate value in column L to active cell and down ward for all col A has the word "Total".

here it is

I change but it still not working
strWorkbookName = "FA Depreciation as of Jul-23.xlsx"
strSheetName = "After"