Search results

Little changes -

Hi shadedlight, What is Bi-weekly, is this first day of every month? Please see attached file if this is ok, have create dropdown in B1 you can change months, if you need current month only then just remove dropdown and paste formula =text(today(),'MMMM')

Hi shadedlight, Can you please populate your desire output, this will help

Hey fixthis, Please see if this is OK. There is another way to do this using array formula (without using helper column)

No, there is no way to get information from closed sheet with dynamic range. There is only one formula which reconstruct range or you can say convert text to range INDIRECT but in Excel does not reference closed workbooks. I would suggest , either you define sheet name on top somewhere and...

Sure!. will wait :)

above formula works only on number values

Hi Justin, If workbook is closed (PTWK) then you should use SUMPRODUCT formula as SUMPRODUCT is only one formula who can fetch data from closed workbook. =SUMPRODUCT(1*'C:\Users\urname\Desktop\[PTWK.xlsx]Sheet1'!A1)

Hey Manny, See if this is OK- Steps- -Create Name range of batch no based on WPS number and create name for wpsnumbers - create dropdown for wpsnumbers - create dropdown with indirect formula

Hi Glenda Johnson, You can simply use vlookup to get State. sample sheet attached for your reference.

Hey Shanmugam please refer below code - Have added two input box to get user information Sub Scenario15() Dim i As Double Dim UserIputCnt As Integer Dim UserIputFolder As String UserIputCnt = VBA.InputBox("Please enter the number of workbooks you want") UserIputFolder =...

Hi ShawnExcel, I have changed smaller part rest is same. I have used two do loop (until to check last cell and while to check duplicate) Sub DeleteCST() Dim CaseNumberDelete As String 'Dim DateDelete As Date 'Dim IntranetIDDelete As String 'Dim FindRowNumber As Long 'Set This Woorkbook as...

So, whats the issue here? you can just remove Sub refresh() and last end sub and paste rest code in Private Sub CommandButton4_Click() rest code here. End Sub or please explain your query little more

Hey Ratish, Yes, please take reference from enclosed file.. Use- Change gmail details (username (h2) and password (h3)) and add to (h6) and type missing in A1 cell * referenced from http://www.rondebruin.nl/win/s1/cdo.htm

Wonderful... thanks to all :awesome:

Dear Masters, Can anyone please help to sharing the VBA code to convert excel table to html table

Firstly welcome to Chandoo. Please use below formula F2 = =IF(COUNTIF($D$2:D2,D2)=1,VLOOKUP(D2,'to be vlookup from this sheet'!$A$2:$B$161,2,0),0) and drag

Hey Pinoy, It would be great if you can share with us your solution :)

Please refer enclosed sample sheet.

Tried but no success, please guide me on this trick

Yes, please upload or share on my email xlstime{at}gmail{dot}{com}

As per my knowledge there is only one way to ignore/bypass Total/GrandTotal but for this you have to change your formula with subtotal or AGGREGATE. Than you can use AGGREGATE function AGGREGATE(function_num, options, array, [k]) function_num = number of function for sum = 9 options = 3 to...

Why can't you use Google Spreadsheet for data storage and Form or Google Scripting for building dynamic forms. You can use this on any platform like Android / IOS / Window.

Hi Rajaniesh, It is little complicate do this, have used 2 helper column to do this, please take reference from uploaded file.

Please refer enclosed, have merged both sheets. you can modify little formula for split workbook (multiple) =VLOOKUP($B4,INDIRECT("'C:\Users\xyz\Downloads\[Data sheet.xlsx]"&$B$2&"'!$B$4:$H$12"),2,0) Just change highlighted one with your file location