Hi Team,
I'm facing challenges to automate attached worksheet. I've to match total
of debit and credit amount to reconcile the data, match could be possible
in single and multiple transaction entries. Please provide your valuable
inputs after you go through to the data sheet.
--
Regards,
Hi Ayush,
Rather than banning all job posts you can ban repetitive job posts, because
these job posts really help the group members to find good openings.
Regards
Deepak
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
I don't know much about VSTO, but you can read articles on Wikipedia and
MSDN..
http://en.wikipedia.org/wiki/Visual_Studio_Tools_for_Office
As we all know that there're many office applications (specially
spreadsheets, text editor presentations) available in the market today.
To retain the No#
Okay Tom..I thought in a different way... Code provided by Sam will work...
Regards
Deepak
On Sun, Nov 27, 2011 at 2:35 AM, Sam Mathai Chacko samde...@gmail.comwrote:
Tom,
Use this example
Sub NameFile()
Name C:\Text.txt As C:\Text
End Sub
Regards,
Sam
On Wed, Nov 23, 2011 at
is not
reflected .
Request you to please look in small chnages revert
Thnaks in Advance..
On Wed, Nov 16, 2011 at 11:01 AM, Deepak Pal Singh
deepaktheind...@gmail.com wrote:
Here it is I developed this code on 2007 platform..I hope it'll work
in 2003 as well...
Sorry.. I couldn't attached
Thanks Bro... It worked... :-) :-)
On Fri, Oct 21, 2011 at 1:47 AM, Sam Mathai Chacko samde...@gmail.comwrote:
Not tested. When you create the OutLook object, try using
CreateObject(Outlook.Application.12) for 2007, or .11 for 2003 (assuming
you have outlook in 2003)
Regards,
Sam
On
Just ask your vendor to publish data in your required format, he'll do it
because your organization is paying him monthly maintenance...
On Sun, Sep 25, 2011 at 4:03 PM, vickey vikasda...@gmail.com wrote:
can I get values (time) of two same values in accedning order with two
Criteria.
for
Try this one... :-)
On Sun, Sep 25, 2011 at 8:36 PM, dguillett1 dguille...@gmail.com wrote:
I sent a solution to what I thought was your request. Now, you have an
entirely different question. Please give examples and clear logic on how to
get the result.
*From:* vickey
Yeah... B'coz one year back I'd to prepare a similar kind of template.. with
BiomatriX data... :-) :-)
On Sun, Sep 25, 2011 at 9:21 PM, dguillett1 dguille...@gmail.com wrote:
It appears that you properly understood the question.
*From:* Deepak Pal Singh deepaktheind...@gmail.com
*Sent
Sure. :-)
On Sun, Sep 25, 2011 at 9:35 PM, vickey vikasda...@gmail.com wrote:
Yes, great its working can I raise more query/issues in case I face
during the operation...
--
--
Some important
Where is the code.??
On Mon, Sep 26, 2011 at 10:07 AM, aju chacko ajuvcha...@gmail.com wrote:
Dear friends,
I have created the following code to to trap
windowactivate event and execute the code from personal macro
workbook when the activate sheet name is sap vs
It won't work... Just want to confirm whether do you want to blink your text
in a label or in cells...??
Regards
Deepak
On Wed, Sep 7, 2011 at 7:30 PM, Bheema Shankar shankar.n...@gmail.comwrote:
Deepak ji
I made little changes to your code to blink my label caption on the
form:
Dim
Its better to not to use pie chart when you have many data points...
FYI...
On Sun, Sep 4, 2011 at 8:58 PM, sandhya jain sanya...@gmail.com wrote:
Hi All,
please help me to remove 0 or null value in pie chart.
file enclosed
--
Hope this will work..
On Fri, Jun 17, 2011 at 11:23 PM, airen airen1...@gmail.com wrote:
Members please Help..
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
I hope this is what you're looking..
On Sat, Jun 18, 2011 at 7:29 AM, AyaNayzgi ZeWolqait ayanay...@gmail.comwrote:
Hello,
I am trying to find out if there is a way of protecting or preventing
modification of excel cells after a predetermined deadline has
elapsed. For instance in cells
Tussi Vadde Mazakiya Ho Ji.. :-)
2011/6/15 NOORAIN ANSARI noorain.ans...@gmail.com
कविता : दास्तान-ए-VLOOKUP
आओ दोस्तों बैठो, Excel की दुकान में, करे कुछ गपसप.
खाए Logic के पकौड़े, और पिए, फोर्मुलों का Tea एक-एक कप.
हंसी मज़ाक में जान ले दास्तान-ए-V/H LOOKUP .
LOOKUP महोदय के दो बेटे
Just add the following line to your code..
Sheets(Customer
Record).Range(ABZ1).End(xlToLeft).Offset(0,1).PasteSpecial
Paste:=xlPasteValues
Regards
Deepak
On Fri, May 6, 2011 at 5:22 AM, Bob bobandrich...@comcast.net wrote:
I'm sorry , Still having trouble with copy on next available blank
Hi Bob,
I'm sorry bro, I didn't understand your problem completely...
There is a minor problem with the code that youve written.. If you copy the
complete column then you can paste it only from row no 1 of the worksheet.
So instead of copying the complete column you just need to copy those rows
End If
Next i
Range(K2) = Timer
Range(K3) = Timer - Range(K1)
End Sub
On Sun, Apr 24, 2011 at 9:13 PM, Deepak Pal Singh
deepaktheind...@gmail.com wrote:
Hi Guy's
Need your help in this code.. in the following code...
Sub Time_Test_Array2()
Range(K1) = Now
Hi Guy's
Need your help in this code.. in the following code...
Sub Time_Test_Array2()
Range(K1) = Now()
Application.ScreenUpdating = False
Range(E:E).Clear
LastRow = 0
LastRow = Range(A100).End(xlUp).Row
iVal = Range(A1:A LastRow).Value
ReDim strArray(1 To UBound(iVal))
using OLE objects but
unfortunately we cannot do it in Excel 2007 as this feature has been
taken off. Having said that you can definitely do this in earlier
versions of Excel.
On 3/27/11, Deepak Pal Singh deepaktheind...@gmail.com wrote:
Hi Ashish,
I'd attached the PPT in my last mail you
off. Having said that you can definitely do this in earlier
versions of Excel.
On 3/27/11, Deepak Pal Singh deepaktheind...@gmail.com wrote:
Hi Ashish,
I'd attached the PPT in my last mail you can find the charts source
data
in the embedded excel file. You need to right click on the chart
as well
On Sun, Mar 27, 2011 at 9:58 AM, Deepak Pal Singh
deepaktheind...@gmail.com wrote:
Hi Guy's,
I'm still waiting for your help...
-- Forwarded message --
From: Deepak Pal Singh deepaktheind...@gmail.com
Date: Sat, Mar 26, 2011 at 7:55 PM
Subject: $$Excel-Macros
Hi,
Can anyone send me some good study material to learn Advance Arrays in
VBA..??
Thanks
Deepak
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hi,
I've a workbook where two tables given on the sheet1 showing sales for 2009
and 2010. I want to present the data through Line Char. There should be a
dropdown on the top of the charts containing three values 2009, 2010 2009
Vs 2010. If I select 2009 then the chart should show only sales
Hi,
I need a help to connect excel file to a database in Access, I've a table
format in the attached file, can anyone make a macro to solve this query.
1) Macro should take inputs from a useform and saved the data in the table
in access databse. Seq# should be unique and auto generated for every
--
From: Deepak Pal Singh deepaktheind...@gmail.com
Date: Tue, Sep 7, 2010 at 10:21 AM
Subject: $$Excel-Macros$$ Urgent Help Required
To: excel-macros@googlegroups.com
Hi Guy's,
I've a worksheet containing three columns Serial No, Month and
New/CarryForward. I want to get count of New Carry Forward
Hi Guy's,
I've a worksheet containing three columns Serial No, Month and
New/CarryForward. I want to get count of New Carry Forward on Monthly
basis using an excel formula not by pivot table, I've tried to done it using
COUNTIF but couldn't get success.
Please Help
Thanks
Deepak Kumar
--
Hey Noone is interested to solve this query..!! :-(
-- Forwarded message --
From: Deepak Pal Singh deepaktheind...@gmail.com
Date: Tue, Aug 10, 2010 at 2:18 PM
Subject: Require A Macro To Compile Data From Different Files
To: excel-macros@googlegroups.com
Hi All,
I'm looking
Hi All,
I need your help to make an automation of the attached worksheet. In the
attached workbook different columns have been given . We have to searched
for duplicate entries in column Service Provider, From and To. If values
entered in these 3 columns are same then it should be displayed
Thanks Dave - it works...
On Sat, Aug 14, 2010 at 1:56 PM, Dave Bonallack
davebonall...@hotmail.comwrote:
Hi,
I hope the attached contains what you need.
Regards - Dave.
--
Date: Sat, 14 Aug 2010 10:23:42 +0530
Subject: $$Excel-Macros$$ Help Required
From:
Hi All,
I'm looking your help to develop a code where I can compile data from
different files, these files located in a same folder and can be 20 or 50 I
don't know that, but macro should search excel files in a specific folder
and start to compile data.
Thanks
--
mahes...@gmail.com wrote:
Hi Deepak
find attach sheet, hope its as per u r requirement.
Change Mypath in Module2.
On Sat, Jun 12, 2010 at 8:17 AM, Deepak Pal Singh
deepaktheind...@gmail.com wrote:
Hi All,
I've some data in sheet1, people have to work on this data, i've assigned
selectCells()
Dim i As Integer
For i = 1 To 100
Cells(i, 1).Select
End Sub
Thanks
On Sat, Jun 12, 2010 at 6:46 PM, Mahesh parab mahes...@gmail.com wrote:
Hi Deepak
find attach sheet, hope its as per u r requirement.
Change Mypath in Module2.
On Sat, Jun 12, 2010 at 8:17 AM, Deepak Pal
Hi All,
I've some data in sheet1, people have to work on this data, i've assigned
the work to the concern people, now what i want a macros should be run and
then new files should be created ion the same folder in the name of assigned
peoples and those files should contain individual works that
You can use =Today()-1
On Fri, May 28, 2010 at 10:07 PM, Surendra saxena surendr...@gmail.comwrote:
Hi All,
need you help to fix the formula in excel like below-
(-Today+End.date)
i want to fix the formula in excel which reflect always previous day value
instead on today.
--
Your's
Hi Vidyut,
This is an example workbook for you, click on button click here, and the
macro will check to first 10 rows if it's found any empty cell in column a
then the entire row mey be edited else will be restricted.
Thanks
Deepak Kumar
On Wed, May 19, 2010 at 12:53 PM, vidyut more
37 matches
Mail list logo