Hi ,
I guess you also want to merge the header cells in sheet 2 for all
entries.. Please refer to this new sheet.
Regards
Gaurav Devrani
On Mon, Feb 23, 2015 at 6:19 AM, Gaurav Devrani gauravdev1...@gmail.com
wrote:
HI Enock,
Please check the attached file and let me know if I missed
Yes Sure.. I will get back to you with that formula. No worries.
Regards
Gaurav Devrani
On Mon, Feb 23, 2015 at 7:25 AM, Enock Wangila ekwang...@gmail.com wrote:
Hi Gaurav,
Thank you for you help. Quick question, is there a way of using a formula
instead of a code to do what you have done.
Hi Guys,
I want a formula that populates values in a worksheet, on a single row
based on two values entered on a different worksheet. The formula should
then sum the populated cells and input the result in the cell adjacent to
the last cell entry. Example: I want to fill 9 cells in sheet2 with
HI Enock,
Please check the attached file and let me know if I missed something.
Regards
Gaurav Devrani
On Mon, Feb 23, 2015 at 5:08 AM, Enock Wangila ekwang...@gmail.com wrote:
Hi Guys,
I want a formula that populates values in a worksheet, on a single row
based on two values entered on a
Thank you for your reply.
I have full access of my computer, there is no restriction of IT.
I will try for it.
On Wed, Feb 18, 2015 at 6:22 PM, Paul Schreiner schreiner_p...@att.net
wrote:
Do you have admin privileges for the machine?
Windows has policies that you can assign to a machine.
Convert all date in same format:
While receiving data from different sources many time it happens that data
received is not in same format due to various reason.
One of the tedious activity is to transforming data to same format.
I will share very good technique to convert all dates to same
Try this in B5 of sheet2 and drag right.
=IF((COLUMN()-1)=Sheet1!$B$3,Sheet1!$B$2,IF((COLUMN()-1)=Sheet1!$B$3+1,SUM(OFFSET($A$5,,1,,Sheet1!$B$3)),))
On Mon, Feb 23, 2015 at 7:29 AM, Gaurav Devrani gauravdev1...@gmail.com
wrote:
Yes Sure.. I will get back to you with that formula. No worries.
Option Explicit
Sub export_range_delimit()
Dim arr As Variant
Dim fs As Object
Dim delimittxt
Dim i As Long
Dim j As Long
Dim line As String
Dim rng As Range
Dim delimittype As String
delimittype = ,
Set fs = CreateObject(Scripting.FileSystemObject)
Hi All.
I am working in excel sheets . I want to automatically delete/clear text in
a cell range. i am not expert enough to do that. Can anyone please help me.
Thanks
--
Regards,
Ahmad Mustafa
+44 7768197568
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Hello there,
I have written a macro to convert xls files to text file, however I have 2
problems here:
1. My code doesnot show xlsx format to pick up from the source folder
2. I am not sure when to add the code to have delimiter comma in my text
file.
I am not an expert, so seeking support
Do you wanna export range in comma delimit text file?.
On Mon, Feb 23, 2015 at 9:38 PM, Muneera Shabana muneera.shab...@gmail.com
wrote:
Hello there,
I have written a macro to convert xls files to text file, however I have 2
problems here:
1. My code doesnot show xlsx format to pick up from
Possible to show a toltiptext on mouse over on each items of combobox?
Note:
combobox is on a vba useform
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
*Hi Sal Sal,*
Please find the attached macro file.
Regards,
MV
On Monday, February 23, 2015 at 10:32:27 PM UTC+5:30, Sal Sal wrote:
Possible to show a toltiptext on mouse over on each items of combobox?
Note:
combobox is on a vba useform
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
Hi Ahmad,
Please follow my instructions to clear what do you want,
Steps:
1. Goto to Excel page, Press CTRL+F11
2. After that, in the left hand side shows the sheets menu, Double click
that after paste the following code.
*Private Sub Worksheet_SelectionChange(ByVal Target As Range)*
*Dim r As
Thanks Kumar.
Can you please send me in the excel file. i am trying but unable to
understand to how to do that.
On Mon, Feb 23, 2015 at 6:59 PM, Suresh Kumar B bsureshkumar2...@gmail.com
wrote:
Hi Ahmad,
Please follow my instructions to clear what do you want,
Steps:
1. Goto to Excel page,
Hi Ahmad,
Here you go!!!
By,
Suresh Kumar.B
On Tuesday, February 24, 2015 at 12:45:22 AM UTC+5:30, Ahmad Mustfa wrote:
Thanks Kumar.
Can you please send me in the excel file. i am trying but unable to
understand to how to do that.
On Mon, Feb 23, 2015 at 6:59 PM, Suresh Kumar B
Thanks kumar.
how you did that. i am still confused? how i can use in my work? can you
please have online chat with me.
On Mon, Feb 23, 2015 at 7:22 PM, Suresh Kumar B bsureshkumar2...@gmail.com
wrote:
Hi Ahmad,
Here you go!!!
By,
Suresh Kumar.B
On Tuesday, February 24, 2015 at 12:45:22
i want this in a specific column not on all sheet
On Mon, Feb 23, 2015 at 7:40 PM, Ahmad Mustfa ahmadmus...@gmail.com wrote:
Thanks kumar.
how you did that. i am still confused? how i can use in my work? can you
please have online chat with me.
On Mon, Feb 23, 2015 at 7:22 PM, Suresh Kumar
kumar i got it what you sent. it's open with alt+f11 not ctrl+f11
now i want this only one specific column not on all sheet. can you please
send formula for that
On Mon, Feb 23, 2015 at 7:43 PM, Ahmad Mustfa ahmadmus...@gmail.com wrote:
i want this in a specific column not on all sheet
On
Superb Vaibhav. Thanks for sharing this with us.
Regards
Gaurav Devrani
On Mon, Feb 23, 2015 at 11:25 PM, Chandan Bisht csb.bi...@gmail.com wrote:
Hi.
Very nice...
Thankx Rgds,
Chandra Singh Bisht
On Mon, Feb 23, 2015 at 8:36 PM, Vaibhav Joshi v...@vabs.in wrote:
Convert all date
Dear experts,
I want to some of times as given below format
2/1/2015
2/21/2015
sum in Hours
Like
11:39:49
9:42:15
9 hrs 30 Minute
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
Dear experts,
I want to SUM of time as given below format
2/1/2015
2/21/2015
sum in Hours
Like
11:39:49
9:42:15
9 hrs 30 Minute
From: Neeraj [mailto:neerajchauhan...@gmail.com]
Sent: Tuesday, February 24, 2015 10:11 AM
To: 'excel-macros@googlegroups.com'
Subject: Help
Hi.
Very nice...
Thankx Rgds,
Chandra Singh Bisht
On Mon, Feb 23, 2015 at 8:36 PM, Vaibhav Joshi v...@vabs.in wrote:
Convert all date in same format:
While receiving data from different sources many time it happens that
data received is not in same format due to various reason.
One
Hi
Try this..put this code in worksheet module for which this to be work, this
will delete content of column 3, you can set to desired column:
*Private Sub Worksheet_SelectionChange(ByVal Target As
Range)Columns(3).ClearContents 'clears content of column 3End Sub*
*Cheers!!*
*O*n Tue, Feb
Dear neeraj,
PFA,
Regards,
Ganesh N
On Tue, Feb 24, 2015 at 10:40 AM, Neeraj neerajchauhan...@gmail.com wrote:
Dear experts,
I want to SUM of time as given below format
*2/1/2015*
*2/21/2015*
*sum in Hours*
*Like*
11:39:49
9:42:15
9 hrs 30 Minute
*From:* Neeraj
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
Hi all,
I'm pulling data from an Access DB query table. When I do, it changes the
name of the active worksheet and I don't want that. How to I pull the data
but keep the tab name as it was? Here's the code I'm using:
ChDir G:\Work Program\2015
Workbooks.OpenDatabase Filename:= _
27 matches
Mail list logo