kindly

I have this code that creates a file with the Current Date and Current Time. (along with other info) I would like to know how can I update the file with the Current time only? Can I request of assistance. Thank you kindly. Open OPath & OFile For Output As #1 Print #1 , Date...

Morning , I have the following formula within a cell that is formatted as % =1-(AA63/T63) Until I populate the cells included in the formula I returns div error (as you would expect) I am at a loss as to how I can "if error" this formula , can someone kindly help me out ? Thanks Russ.

I have the following formula =INDEX('[Sales Report2019.xlsm]Sales by month'!$A$11:$N$11,MATCH('[Sales Report2019.xlsm]Sales by month'!B1,'[Sales Report2019.xlsm]Sales by month'!$A$1:$M$1)) I have the year in Q1 I would like to use an ampersand to combine the year in the formula with the...

Hi Very Urgent and very necessary. Please someone reply Kindly some one please help me to make month wise and customer wise report from a unsorted data with Pivot Table or Macro. sample file link attached here https://www.dropbox.com/s/cdl5r9k24f6banb/Sample.xlsx?dl=0 :confused:

Dear Team, i am new in VBA using macro by record macro only. Kindly help to correct the below mention VBA code. I want to select a cell in sheet1 based on the cell value in sheet2(cell E3). E3 contain the Cell address of required cell selection. like in below macro address is "A10". but it...

Yes I understand that the total number of possible outcome results is 6561. But how can I get there? Any formula in excel? Kindly assist. Thank u

Kindly support to guide about can save excel specific cells as image to a folder .

I have tried to set up a formula on Sheet4 to compute the Net Value in Col G (it is the value in Col E-Col F eg E2-F2) it would be appreciated if someone could kindly assist me...

Hi Please do kindly assist me, I would like to know if it is possible to use a single drill down and drill up function to update all the charts in my work book? if so please kindly guide me on how to get this done.

Need help with this code to find last used row and filter. Thank you kindly Range("A14:Q100").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=Range("AT14:AV15"), UNIQUE:=False

Using Filter formula in excel, message appears This function is not valid. Kindly help

Hello Is it possible to apply a vba protect multiple sheets at once? (I have the VBA already - kindly supplied on this site) Thank you

Can we set page break in access if yes kindly guide about it Thanks in advance ?

I would like to retrieve the Option Price last quote from Yahoo. Writing a vba code to retrieve this information from a website is far beyond my novice abilities, so I would like the kindly request from the VBA community if you could offer a vba code that would accomplish this task. The url...

Dear Sirs Good afternoon , i m working on term loan sheet with moratorium period only the interest will be paid first and after couple of months will start paying Principal and Interest Kindly advise how can i use the excel to prepare a formula for that . Thanks & Regards Najib ABboud

How can I use this formula in vba... =SUMPRODUCT(--(TEXT($D$15:$D$1001,"mmmmyyyy")=$S23&T$14),$P$15:$P$1001) Thank you kindly

Hi , I need to concatenate Row C value with its last cell value one another one in a below format and paste the output in Row D. Multiple files I have, so the number of rows will increase for each workbook. For Eg: C D 001 0001 OF 0005 002 0002 OF 0005 003...

Dear friends and respected seniors, In excel 2003, i have this data in cells a1 = 1 b1 = + c1 = 2 In d1 i want calculation of a1 and b1 and c1, so answer in d3 must be 3, because 1+2=3. Similarly if value in b1 is -, then d1 must become -1 because 1-2 = -1, but I am not able to do it :( I tried...

Hi, FXD (Dept.014865) I would like to just have 014865. Please note: - I need a formula for about 15,000 rows - the only consistency is after the "." hence numbers and ) - I do not want the ) & FXD changes up to 10 letters Thank you kindly,

Hello All, Kindly help me for the below query which I need in the way of Excel-VBA. Here column A - is the serial number and I need to sum the values of Column C (56+44.01+33.20 = 133.21) and provide the value in Column D in row 1. Likewise, it needs to sum automatically for the Serial numbers...