Search results

Hi All Can someone in the community pls kindly help me with the requirements (in red) in the sample workbook?

any help on this will be much appreciated as i have tried a few if statements and it doesn't seem to give me the answer i need?

Thanks Rahul but it did not work i basically need a formulae in cell CB7 that looks at the data in columns R:BY and if they are within the date range of 5 Yrs (cells R1:BY) and they have a value in cell R7 or any other cell between R7 and BY7 then the result in CB7 should show yes.

Hi Team, I am looking to see that if any number is present in the data table and fall within the date range specified then can it return yes. your help is much appreciated workbook sample attached. Thanks!

Thanks @Chihiro that has worked!

i have 2016 and PQ but the individuals i am sending this report to to dont have PQ and are not trained to use PQ. any chance the formulae you had @Chihiro can be tweaked to include the criteria i gave in sheet 1 pls?

agree @peco but at the moment the individuals dont have power query available hence using excel

Hi - sheet attached the formulae in e7 works and if that can be tweaked for the criteria in the data sheet filtered or in B4-F4 (sheet 1) that would be much appreciated. pls note the data is only a snapshot there is over 350k lines of data and the dates are more than what i have attached but if...

Thanks team - but is there a way i can incorporate cells b4,c4,d4,e4,f4 & g4 in the criteria as the data set needs to be summed for that criteria only?

Hi I am looking for some assistance pls. I am trying to get the cumulative total for 12 months every time i select the date in Sheet 1 cell D1 i.e. e.g. if i select 2019-02 it should pick all the data with 2018 03 to 2019 02 tags therefore always picking 12 months running total. I have tried...

Thanks Vletm , that seems to be working for now.

Thanks Vletm. that works for now however one small tweak is there any chance to have the cell in column c66:c80 for the non staff section please?

so the ranges should be the same i.e. from Ex1 E11:R20 will be in pasted in Master E11:R20. the example tab is the desired result and yes all other tabs will be feeding into the master tab(not example tab). thanks in advance.

Hi, I was wondering if someone could help with a code for a template that i have. I have 95 tabs in the workbook and the desired result is to take ranges (E11:R20,E39:R48 & E66:R80) in e.g. tab Ex1 and copy those ranges in the master spreadsheet in the line below each of the ranges suggested...

I have a large data set that i have setup with the following formulae: SUMPRODUCT(--('2015'!$B$25:$B$13771&'2015'!$D$25:$D$13771=Master!$A30&Master!$B30),INDEX('2015'!$F$25:$Q$13771,,MATCH(Master!J$4,'2015'!$F$22:$Q$22,0))). The sheet is become very slow and i was wondering if i can embed the...

I got nothing. does it matter if i am using excel 2010?

Thanks Vletm, but i cant see the code in the workbook?

I will be the only one accessing and the drop down.

this is cell C3 on the cash tab

there would not be a same name worksheet because the drop down list in C3 will have unique names. hope this makes sense?

requirement is in tab (colored green). Thanks for the help!

Hi, Would really appreciate if the community can help with this query? Thanks in advance for all your help.

Sub Copyrenameworksheet() 'Updateby MR Dim ws As Worksheet Set wh = Worksheets(ActiveSheet.Name) ActiveSheet.Copy After:=Worksheets(Sheets.Count) If wh.Range("C3").Value <> "" Then ActiveSheet.Name = wh.Range("C3").Value End If wh.Activate End Sub Hi - I currently...

Column I does not have formulas in this sheet but would like to use paste formulas rather than values. In essence every week I run the macro I want the formulas in column I to be later in to col J and e.g. in the week after take the range in col J and paste in col k. Hope this makes sense...

Hi I would like to have a VBA Please, it needs to copy the data in column I and paste in column J and when i run it every week i want the macro to automatically take the formula in column I and paste it in Column J and so on... I have the code below but would appreciate if someone can help...