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

Email:
  

Password
  





Forum Statistics
» Members: 623
» Latest member: ajaysharma8532
» Forum threads: 760
» Forum posts: 1,872

Full Statistics

Latest Threads
Sum Function
Forum: Ask Excel Question
Last Post: Sajan
25-Nov-2021, 01:10 PM
» Replies: 4
» Views: 1,748
VBA check if
Forum: Ask VBA Question
Last Post: Vivekananda Sinha
12-Jan-2021, 08:45 PM
» Replies: 1
» Views: 1,116
Dependent Drop Down
Forum: Ask Excel Question
Last Post: Anil Kumar Pal
23-Nov-2020, 10:05 AM
» Replies: 1
» Views: 798
for and next
Forum: Ask VBA Question
Last Post: Abhay
08-Sep-2020, 03:26 PM
» Replies: 0
» Views: 854
PAN NO. FORMULA
Forum: Ask Excel Question
Last Post: dsharma789@rediffmail.com
06-Jul-2020, 11:51 AM
» Replies: 0
» Views: 893
Getting error while tryin...
Forum: Ask VBA Question
Last Post: Rinku Sharma
25-Jun-2020, 09:01 PM
» Replies: 0
» Views: 721
Hyperlink Pivot table dat...
Forum: Ask Excel Question
Last Post: sanj_edu
14-Jun-2020, 06:37 PM
» Replies: 0
» Views: 711
Calculate idle time no mo...
Forum: Ask VBA Question
Last Post: Inderjeet Pal
28-Apr-2020, 11:59 AM
» Replies: 0
» Views: 823
Making Pivot table
Forum: Ask Excel Question
Last Post: Vivekananda Sinha
17-Feb-2020, 12:39 PM
» Replies: 1
» Views: 1,162
Need help on code
Forum: Ask VBA Question
Last Post: Inderjeet Pal
15-Feb-2020, 04:23 PM
» Replies: 0
» Views: 871
Date Selection In Range
Forum: Ask Excel Question
Last Post: imexcelguru
14-Jan-2020, 02:03 PM
» Replies: 1
» Views: 1,100
count
Forum: Ask Excel Question
Last Post: imexcelguru
14-Jan-2020, 01:19 PM
» Replies: 3
» Views: 1,866
Array
Forum: Ask Excel Question
Last Post: imexcelguru
14-Jan-2020, 12:16 PM
» Replies: 4
» Views: 1,793
find unique values as hig...
Forum: Excel Challenges
Last Post: imexcelguru
13-Jan-2020, 10:07 PM
» Replies: 4
» Views: 2,662
add numbers in a cell
Forum: Excel Challenges
Last Post: imexcelguru
13-Jan-2020, 08:36 PM
» Replies: 0
» Views: 788

 
  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: 9)

  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: 2)
.xlsx   POS_formula.xlsx (Size: 8.62 KB / Downloads: 1)

  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 (4)

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: 16)

  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: 12)

  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: 12)

  count
Posted by: Mahi Singh - 02-Nov-2019, 09:32 AM - Forum: Ask Excel Question - Replies (3)

Dear All,

Please Resolve The Question Attached Sheet.



Attached Files
.xlsx   count.xlsx (Size: 10.6 KB / Downloads: 11)

  duplicate values with conditions
Posted by: sanj_edu - 02-Nov-2019, 04:10 AM - Forum: Ask Excel Question - Replies (2)

   


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

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: 10)