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

Email:
  

Password
  





Forum Statistics
» Members: 501
» Latest member: ckp2806
» Forum threads: 753
» Forum posts: 1,862

Full Statistics

Latest Threads
Making Pivot table
Forum: Ask Excel Question
Last Post: Vivekananda Sinha
Yesterday, 12:39 PM
» Replies: 1
» Views: 6
Need help on code
Forum: Ask VBA Question
Last Post: Inderjeet Pal
15-Feb-2020, 04:23 PM
» Replies: 0
» Views: 13
Date Selection In Range
Forum: Ask Excel Question
Last Post: imexcelguru
14-Jan-2020, 02:03 PM
» Replies: 1
» Views: 85
count
Forum: Ask Excel Question
Last Post: imexcelguru
14-Jan-2020, 01:19 PM
» Replies: 3
» Views: 261
Array
Forum: Ask Excel Question
Last Post: imexcelguru
14-Jan-2020, 12:16 PM
» Replies: 4
» Views: 104
find unique values as hig...
Forum: Excel Challenges
Last Post: imexcelguru
13-Jan-2020, 10:07 PM
» Replies: 4
» Views: 914
add numbers in a cell
Forum: Excel Challenges
Last Post: imexcelguru
13-Jan-2020, 08:36 PM
» Replies: 0
» Views: 44
Copy value from cell (A1)...
Forum: Ask VBA Question
Last Post: Vivekananda Sinha
26-Dec-2019, 07:34 PM
» Replies: 1
» Views: 91
Query Cerating
Forum: Ask Access Question
Last Post: Lovedeep sharma
30-Nov-2019, 03:36 PM
» Replies: 1
» Views: 132
Sum Function
Forum: Ask Excel Question
Last Post: pushpendarchaudhary
27-Nov-2019, 06:10 PM
» Replies: 3
» Views: 201
vlookup
Forum: Ask Excel Question
Last Post: Chetan@FIH
18-Nov-2019, 04:44 PM
» Replies: 1
» Views: 353
VLOOKUP
Forum: Ask Excel Question
Last Post: Chetan@FIH
15-Nov-2019, 09:44 PM
» Replies: 3
» Views: 286
Count
Forum: Ask Excel Question
Last Post: Vikrant8595
10-Nov-2019, 10:49 PM
» Replies: 3
» Views: 169
duplicate values with con...
Forum: Ask Excel Question
Last Post: sanj_edu
03-Nov-2019, 10:44 PM
» Replies: 2
» Views: 181
Advanced filter in VBA
Forum: Ask VBA Question
Last Post: Virender
22-Oct-2019, 03:34 PM
» Replies: 1
» Views: 214

 
  Making Pivot table
Posted by: Jyoti - Yesterday, 12:11 PM - Forum: Ask Excel Question - Replies (1)

Hello all, 

I need your help for solve this query. whenever i'm going to make pivot table i'm facing error, please find attached error

 help me to  solve this.




Attached Files Thumbnail(s)
   

  Need help on code
Posted by: Inderjeet Pal - 15-Feb-2020, 04:23 PM - Forum: Ask VBA Question - No Replies

I want to copy multiple ranges and charts in the outlook body through VBA. Can nyonr hrlp with the code


  Date Selection In Range
Posted by: @m!t $@!n! - 14-Jan-2020, 01:33 PM - Forum: Ask Excel Question - Replies (1)

Hi Sir,

PFA and suggest your view.

Thanks & Regards,
Amit



Attached Files
.xlsx   Recent Live Clients Summary - Date Selection - 12.xlsx (Size: 29.06 KB / Downloads: 3)

  add numbers in a cell
Posted by: imexcelguru - 13-Jan-2020, 08:36 PM - Forum: Excel Challenges - No Replies

can u add numbers in cell where the value will be like this

2356     =     2+3+5+6
2457     =     2+4+5+7
1235687=    1+2+3+5+6+8+7


  Array
Posted by: Abhay - 11-Jan-2020, 01:11 PM - Forum: Ask Excel Question - Replies (4)

Hello All here,

Greetings,

May I request you all to please help me the way to get the result as shown in column 'E' from the column 'A' and 'C' dynamically in attached sheet.

Thanks in anticipation.



Attached Files
.xlsx   Test FIH.xlsx (Size: 10.37 KB / Downloads: 2)

  Copy value from cell (A1) and paste another workbook on cell(E2)
Posted by: Amit5210 - 26-Dec-2019, 06:21 PM - Forum: Ask VBA Question - Replies (1)

Hello Experts,

Please help me on this.

I want to copy cell (A1) from POS_formula sheet which is saved on my desktop and paste on another workbook (pos_1) in cell(E2).
I tried to fix but not successful.

Please see below the code and suggest.


Sub open_workbook()
' Keyboard Shortcut: Ctrl+j
'Dim x As Workbook
'Dim y As Workbook

    Cells.Select
    Selection.Copy
    Sheets.Add
    ActiveSheet.Paste
    Rows("1:7").Select
    Selection.Delete
    Selection.Columns.AutoFit
    Range("B:B,D:D,E:E,G:G,H:H").Select
    Selection.Delete
    Range("C1").Select
    ActiveCell.FormulaR1C1 = "Loc"
    Range("D1").Select
    ActiveCell.FormulaR1C1 = "Count"
    Columns("A:D").Select
    Selection.AutoFilter
    ActiveSheet.Range("$A$1:$D$8000").AutoFilter Field:=2, Criteria1:="<>"
    Selection.End(xlToLeft).Select
    Range(Selection, Selection.End(xlToRight)).Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.Copy
    Sheets.Add
    ActiveSheet.Paste
    Selection.Columns.AutoFit
    Selection.End(xlToLeft).Select
    
 '## Open both workbooks first:
'Set x = Workbooks.Open("C:\Users\mis\Desktop\POS formula.xlsx")
'Set y = Workbooks.Open("C:\Users\mis\Desktop\pos 1.xls")
'Now, copy what you want from x:
'x.Sheets("Pos formula.xlsx").Range("A1").Copy

'Now, paste to y worksheet:
'y.Sheets("Pos 1").Range("E2").PasteSpecial

'Close x:
'x.Close
   
    
    
 Workbooks.Open "C:\Users\mis\Desktop\POS_formula.xlsx"
 'Workbooks(POS_formula).Worksheets("Sheet1").Range("A1").Copy
    'Workbooks(pos_1).Worksheets("Sheet3").Range ("e2")
 
 Range("A1").Select
 Selection.Copy
 Windows("pos_1.xlsx").Activate
 Selection.Range("E2").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone
 
 'Range("A1").Copy Destination:=Sheets(pos1).Range("E2")
 'Workbooks("pos1").Select
 'Range("e2").Select
 'ActiveSheet.Paste
 
    
End Sub



Attached Files
.xls   pos_1.xls (Size: 24 KB / Downloads: 1)
.xlsx   POS_formula.xlsx (Size: 8.62 KB / Downloads: 0)

  Query Cerating
Posted by: Abhay - 29-Nov-2019, 04:18 AM - Forum: Ask Access Question - Replies (1)

Hello all!

Greetings,

I need  to select dates between two dates in MS Access Query. I am using MS Office 2007.

I write function like this in criteria column              >=["Start Date"] And <= ["End Date"]

but this is not working...

Request please help.

Regard,


  Sum Function
Posted by: pushpendarchaudhary - 26-Nov-2019, 12:22 PM - Forum: Ask Excel Question - Replies (3)

Hi All,

please check excel sheet  one series in column "A" i want sum only number of "1" in column "B".


regards
PC



Attached Files
.xlsx   Querry sheet.xlsx (Size: 8.12 KB / Downloads: 12)

  Count
Posted by: Vikrant8595 - 10-Nov-2019, 03:17 PM - Forum: Ask Excel Question - Replies (3)

Hi Sir,

I need your help. 

Thanks
Vikrant



Attached Files
.xlsx   QUES.xlsx (Size: 9.62 KB / Downloads: 11)

  VLOOKUP
Posted by: sukhwantsingh23 - 06-Nov-2019, 12:57 PM - Forum: Ask Excel Question - Replies (3)

Hello everyone I have question about VLOOKUP a made a table of states and their capital's the formula is working if I'm just copying the state name and pasting it getting the result but when I'm  type the state name not getting the capital? please help attaching the file below.



Attached Files
.xlsx   Book1.xlsx (Size: 11.13 KB / Downloads: 9)