advance

I have an advanced filter that runs on my Excel VBA application which is suppose to filter dates in the data base, I created the advance filter on the worksheet and it works fine except for when it comes to filtering dates this is the formula I'm using: =IF(C5="",">1","<=" &C5) start date...

Hi all, I've been working on trying to set up a spreadsheet that others will be able to easily use. I've created a spreadsheet that automatically pulls the data from another worksheet but I can't figure out how to have the different column rows to combine. <tbody> Name Segment Code Date...

Hi, I need a formula to cell K3 to equal n3 from sheet with name 60001 cell k4 to equal n3 from sheet with name 60002 cell K5 to equal n3 from sheet with name 60003 and so on. or in another words if i drag down the formula it will change the sheet number and increase it by 1, without changing...

Instead of a number returned as expected the field has a '?'. Typical reasons why? Thanks in advance, Pikeboy

In example below I need to add quotes around the last cell reference and to same formula across columns. I didn't add quotes because autofill doesn't work with quotes. Thank you in advance =SUMPRODUCT(SUMIF(INDIRECT("'"&SheetList&"'!"&"$B$35:$B$1000"),$A2,INDIRECT("'"&SheetList&"'!"&M$35:M$1000)))

Using Excel 2000 Hi, I need VBA to get coloured 0 as shown in the example below <colgroup><col></colgroup><tbody> 0 | 0 | 0 | 1 | 1 | 1 | 1 0 | 0 | 1 | 1 | 1 | 0 | 1 0 | 0 | 1 | 1 | 1 | 1 | 0 0 | 0 | 1 | 0 | 1 | 1 | 0 0 | 0 | 1 | 1 | 1 | 1 | 0 0 | 0 | 1 | 1 | 1 | 0 | 1 0 | 0 | 1...

Hi! I've been searching but had no luck to find if there is any possible way to make a chart like this automatic in Excel, do you think it is possible? If yes... how so? Hope you can help, thanks in advance!

Hello,</SPAN></SPAN> I need to sum column "C" depending on as per column "D" blocks (blocks consist with 0's or largest to lowest number ended with 1)</SPAN></SPAN> Here is a small example... </SPAN></SPAN>...

Workbook has two worksheets, "Contractor Names and ID code" and list of all contracts with requirements i.e. type of contracts = "A, B, C or Blank", schedule dates and other items on second worksheet label "Contracts". On the first worksheet need to have the number of type contracts each...

<tbody> job task charge codes prices N34 cable mod plate 125 cable 40 N35 cable socket mod connect 10 N38 socket connect mod plate 15 N44 cable plate socket socket 25 mod 70 </tbody> hi i new to advance formulas and i need a formula to look at the...

Hi, I managed to set up an advance filter to extract what i need, but it is quite tedious to keep doing advanced filter based on the criteria i need. is there any way to have the filtered list to refresh whenever i cell B2? my data is in a table in the sheet called engagement log, and it is an...

Hello Everyone, I have the following table <tbody> Column A Column B No. of Days Value </tbody> I am looking for a formula in "Column B" which would return the value as per below condition. <tbody> Count Of Days Value 1 0 2 0 3 0 4 1 5 1 6 1 7 1 8 2 9 2 10 2 11...

Hi all I just want to copy a cell (A1) value down to A2. Only if B2 has a value. And so forth, copy A2 to A3 if B3 has a value. Thanks in advance, ColdGeorge

Hi, I have a report and in that the format of the number are coming in 2 different ways. Is there a way to correct this. 1. 340.35 = this is normal format, i don't have any issue with this. 2. 28.390,26 = If you could see there is "." instead of "," and "," instead of "." and also have to...

I expect this is a more logical way to achieve what I want but I cannot conceive it The following does not work. IF B4 is less or greater than C4 by a value of 2 or more I want to return a false. =IF(OR(B4<(C4-2)),(B4>(C4+2)),false,true) Thanks in advance Lunar

Hi I am very new to VBA basically copying bits from other workbooks so please bear with me! My query is as follows: I would like to reformat my output of <colgroup><col width="268" style="width: 201pt; mso-width-source: userset; mso-width-alt: 11434;"> <tbody> 12.9000299280694 -...

Hi everyone, I want to protect sheet, cannot unhide sheet or set password for unhide sheet (only specific sheet) anyone who can know code in VBA Thank you in advance for your respond :)

Hi guys, Just writing a script for testing "J" columns value. If it's >= 200, then "AV" column show "passed" But seems like below doesn't work. Thanks for your help in advance. Sub a() Dim i As Long For i = 1 To Rows.Count If Cells(i, "J").Value >= 200 Then Cells(i, "AV").Value =...

Hi, A user is having issues trying to open a file with the below macro code. I don't believe this is an issue for anyone else. The code and error are both below. Does anyone have an idea of what this relates to? Thanks in advance Ryan Private Sub Workbook_Open()...

I have an advance filter which works perfectly if I use this formula =AND(J16>=0.607,J16<=0.627) I does not work if I us this formula =AND(J16>=O6,J16<=P6) O6 and P6 are not in the List or Criteria range. O6 contains a formula that return 0.607 and P6 contains a formula that returns 0.627. So...