Search results

I am not getting the output please do the needful.

All, I have the following 5 sheets in a file WksOutput,WksData,WksBangalore,WksDelhi,WksMumbai. I want to copy data from WksBangalore,WksDelhi,WksMumbai to WksData sheet continuously. I am using the following data Sub Combine() Dim J As Integer On Error Resume Next Sheets(3).Activate...

Hi , Sorry for the late reply. Thanks it worked perfectly. I will be updating the data every week, so VBA will be very useful automatically it updates inlieu of offset formula.

All, I have a data on one sheet and required to copy the data in the desired format in another sheet. I wrote the code for date and rate to copy but it's not working properly. Please do the needful. I am learning VBA from 2 months.

Thank you very much khalid.

Ramesh, Thanks for the help. It worked properly. If anyone helps on second part, it would be great help.

Hi, In the attached file , the formula in cell "EY22" is not working properly . It's taking the value of particular column only . Also, help me with formula with minimum quantity( >0) and respective vendor name.

Khalid & asheesh It saves my lot of time, thanks lot for your support . excel is ocean .... I need to learn lot....

find attached the excel file.

I have text in merged cell a2:a4 ( Details of payment,q4 order summary report-completed wt & dimension CA14-3345 - Completed engraving : Acme - Progress Tenon scienc & technologies - Completed SBC @ 0.5% pay tax - Pending Service tax 12.36% to 14% - Progress ) I required formula to count...

all, I am using the formula IF(C33>B33,$H$32,$G$32)&TEXT(((B33-C33)/B33),"#%"), but i am getting the result as ▲51% .... but i need in 2 decimal places...like 51.38% G32 ▲ H32 ▼ B(33) C (33) 8368219.99 12668219.99

Misra and BBD The formula worked perfectly . Thanks very much for your precious time in solving the query.

Hi , find attached the file for more clear explanation

The result i required is 4204 difference of( 27862-23658) 4245 ( difference of (27866-23658)

All , I am having 1000 + rows like below mentioned here , I want the difference mat In Column A there are 3 numbers separated by forward slash The first number is beam number the second number is node number The third number is load case number I required difference of Fx matching the node...

Luke , its working perfectly. Thanks for explaining in detail and sparing your precious time in resolving the query. Thank you very much.

Hi , I required help in creating Slicer as per the attached file. I Had done one slicer of Project Type and i required another slicer as Package and chart updating it.

Misra , Yeah it;s 1.57M , Thank you very much it worked perfectly

Dear All, I want to format the -ve number like -1,557,896 to (INR 15.57M) Please do the needful

Dear Misra Thank you very much for your time and support.

In the attached the sheet the total sum for the Travels in the month of Aug-14 it should be 329627, but formula shows only 2385.

Dear Misra , If 2 or 3 payments made on the same month , formula is considering the first payment transaction only, not the summation of all transaction in the month for that particular heading.

Ok.. Thank you very much .

Dear Misra, In formula , what ("zzzzzz" indicates? IFERROR(INDEX(Sheet7!$G$4:$G$44,MATCH(1,(LOOKUP("zzzzzz",$C$2:$C7)=Sheet7!$D$4:$D$20)*(Sheet4!G$1=Sheet7!$I$4:$I$20),0)),"")