Welcome, Guest
You have to register before you can post on our site.

Email:
  

Password
  





Forum Statistics
» Members: 481
» Latest member: rkdagar
» Forum threads: 741
» Forum posts: 1,825

Full Statistics

Latest Threads
Advanced filter in VBA
Forum: Ask VBA Question
Last Post: Amitg9595
08-Oct-2019, 08:03 PM
» Replies: 0
» Views: 26
IF Formula
Forum: Ask Excel Question
Last Post: Vivekananda Sinha
27-Sep-2019, 08:40 PM
» Replies: 1
» Views: 83
Paste Image or text in ou...
Forum: Ask VBA Question
Last Post: Vivekananda Sinha
27-Sep-2019, 08:38 PM
» Replies: 1
» Views: 48
Pivot Table Query
Forum: Ask Excel Question
Last Post: Anil Kumar Pal
24-Sep-2019, 06:01 PM
» Replies: 2
» Views: 256
Extract Email ID
Forum: Ask Excel Question
Last Post: sourabh sharma
12-Sep-2019, 12:13 AM
» Replies: 1
» Views: 154
Inventory Sheet Query
Forum: Ask VBA Question
Last Post: Anil Kumar Pal
09-Sep-2019, 03:27 PM
» Replies: 2
» Views: 141
Criteria Wise Rank
Forum: Ask Excel Question
Last Post: Vikrant8595
02-Aug-2019, 07:46 AM
» Replies: 0
» Views: 102
VBA not recognizing userf...
Forum: Ask VBA Question
Last Post: Vivekananda Sinha
15-Jul-2019, 05:49 AM
» Replies: 1
» Views: 232
POWER BI
Forum: Ask Excel Question
Last Post: Lovedeep sharma
09-Jul-2019, 03:28 PM
» Replies: 1
» Views: 166
vlookup
Forum: Ask Excel Question
Last Post: virendra
04-Jul-2019, 10:50 PM
» Replies: 0
» Views: 139
InfoGraphic Charts
Forum: Ask Excel Question
Last Post: prashantbverma7@gmail.com
01-Jul-2019, 12:29 PM
» Replies: 0
» Views: 137
How to sum the total sale...
Forum: Ask Excel Question
Last Post: rawat7838
27-Jun-2019, 04:48 PM
» Replies: 1
» Views: 276
Stack Ranking
Forum: Ask Excel Question
Last Post: rawat7838
22-Jun-2019, 12:52 PM
» Replies: 0
» Views: 149
File is not opening
Forum: Ask VBA Question
Last Post: Chandan kumar
18-Jun-2019, 11:19 PM
» Replies: 2
» Views: 281
Count of Students with cr...
Forum: Ask Excel Question
Last Post: Neeraj Kumar Maurya
18-Jun-2019, 12:20 PM
» Replies: 5
» Views: 311

 
  Advanced filter in VBA
Posted by: Amitg9595 - 08-Oct-2019, 08:03 PM - Forum: Ask VBA Question - No Replies

Hi Frnds,

I am using Advanced filter in VBA code generally with Advanced filter we can filtered the data on some given criteria range but i wish to see data of that particular criteria range unchecked means does not equals to that range. 

Except that range data should be filtered there only for those criteria data will not show in raw dump.

Please find the attached sheet and suggest the correct way to resolved it.

Thanks,
Amit Sharma



Attached Files
.xlsb   Advanced filter NOT criteria.xlsb (Size: 498.94 KB / Downloads: 2)

  Paste Image or text in outlook
Posted by: Vikrant8595 - 26-Sep-2019, 06:16 PM - Forum: Ask VBA Question - Replies (1)

Hi All,

I hope you all are doing well. Today's my concern how to paste figure from excel to outlook (from vba coding). Please help me to rid of this problem.

Vivek Sir: kindly help me. 

Thanks
Vikrant Singh


  IF Formula
Posted by: Aman Kumar - 08-Sep-2019, 10:04 AM - Forum: Ask Excel Question - Replies (1)

Dear sir,

Please refer highlighted portion in the enclosed worksheet and please advise why the formula is not working even after conditions results are true.

With regards,
Aman



Attached Files
.xlsx   Book1.xlsx (Size: 9.47 KB / Downloads: 8)

  Inventory Sheet Query
Posted by: Anil Kumar Pal - 28-Aug-2019, 12:47 PM - Forum: Ask VBA Question - Replies (2)

Dear All,

Please refer to the attached sheet in this right now i have shared only 2 tabs but in daily routine i need to work on at least 20-25 tabs in one workbook. in this i need your help please let me know how clear all the below to right side after 1st date given.

Please suggest how to mention the range and worksheet so that i can implement further.

Thanks
Anil Kumar Pal



Attached Files
.xlsx   Inventory Query.xlsx (Size: 56.71 KB / Downloads: 8)

  Criteria Wise Rank
Posted by: Vikrant8595 - 02-Aug-2019, 07:46 AM - Forum: Ask Excel Question - No Replies

Dear all,

Please help me to solve this query.

Thanks
Vikrant Singh



Attached Files
.xlsx   Book1.xlsx (Size: 14.04 KB / Downloads: 14)

  VBA not recognizing userform
Posted by: Rinku Sharma - 14-Jul-2019, 01:00 PM - Forum: Ask VBA Question - Replies (1)

Hello Sir,

I have designed a user form form and am trying to hide excel and show excel but its not giving m file not found error. Attached is the screenshot.

Please help.

Thanks and regards,
Rinku Sharma



Attached Files Thumbnail(s)
   

  Pivot Table Query
Posted by: Lovedeep sharma - 12-Jul-2019, 05:20 PM - Forum: Ask Excel Question - Replies (2)

Vivek sir please help



Attached Files
.xlsx   Pivot Table Query.xlsx (Size: 169.5 KB / Downloads: 20)

  POWER BI
Posted by: Inderjeet Pal - 08-Jul-2019, 01:01 PM - Forum: Ask Excel Question - Replies (1)

Attached is the excel sheet which has a data and chart with that... I want to build same kind of chart with this data...but no luck. If i modulate the data tension also doesbt work..



Attached Files
.xlsx   PowerBI_Chat Issue.xlsx (Size: 17.3 KB / Downloads: 6)

Special-offer vlookup
Posted by: virendra - 04-Jul-2019, 10:50 PM - Forum: Ask Excel Question - No Replies

hello friends please solve these 2 query



Attached Files
.xlsx   query virendra.xlsx (Size: 13.32 KB / Downloads: 16)

  InfoGraphic Charts
Posted by: prashantbverma7@gmail.com - 01-Jul-2019, 12:29 PM - Forum: Ask Excel Question - No Replies

Hi,

I am working on a infographic chart where, bar is acting weird as it crosses 89%.

Kindly check and let me know where I am lacking.


Hi,

I found the solution.

I accidently didn't syncronised the axis for secondary value axis, which was the reason I was getting issues..



Attached Files
.xlsx   infograph Chart with symbols.xlsx (Size: 70.71 KB / Downloads: 4)