On Saturday, May 31, 2014 12:11:22 PM UTC+3, Sleek wrote:
>
>
> I need a minimum or zero difference, against the target totals i have set.
> i have 3 columns, juggle around with figures.there is no barrier to how
> many you can put in column but use only the figures i give you. I think
> maybe
Hi Expert,
Any have know about it that any kind of book available in Web Scripting by
excel vba.
Regards
Pramod
VBA Developer.
--
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
Hi Expert,
In excel can we take average of average. This Is right method to do such a
like work.
Regards
Pramod
VBA Developer.
--
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
did this helped??
On Mon, Jun 2, 2014 at 12:15 PM, Vaibhav Joshi wrote:
> hey sleek..
>
> I was wondering that this can be done in much faster than time taken by
> Scenario & finally i could make VBA macro.
>
> If you wanna do in less than sec then try this code..
>
> Hit macro, select your tar
Hi,
Since you are declaring your variable as integer you are getting this
error..
check this line.. *Dim i As Integer, j As Integer, k As Integer, s As
String*
since integer can hold max value upto 32,767, post which you will get
overflow error & your macro will get stopped..
Instead of integ
It was set to focus on row 1, so if you have additional data in column
except row 1 then data is not copied.
I have change code to reach out to all used columns.
PFA
HTH//Cheers!!
On Tue, Jun 3, 2014 at 2:09 AM, Bill Q wrote:
> I spoke too soon. There is an issue
>
> It picks up and copy
Hi,
Please find macro below.
Thanks.
Sub Button1_Click()
Dim i As Integer, j As Integer, k As Integer, s As String
i = 1
j = 1
Do
s = Cells(i, 4).Value
If s = "" Then Exit Do
Worksheets("DATA").Select
Cells(j, 1) = Worksheets("URL").Cells(i, 1).Value
Cells(j, 2) = Worksheets("URL").C
I spoke too soon. There is an issue
It picks up and copying all the data from column "A" to column "D"
inclusively. It is not picking up and copying data, if from column "E"
onwards for some reason.
Quick fix ?
On Saturday, May 31, 2014 12:35:17 PM UTC-4, Bill Q wrote:
> Perfect. T
I'm having some difficulty following what you're trying to do.
Your description implies that there are multiple records (1,2,3) for a given
name.
and, it seems that there should be multiple occurences of the id/name
combination
which you wish to make unique by adding A-D to the ID's.
But you
Can you share the macro?
whenever I see an error involving something "around" 33,000
I immediately look to integer variables.
do you have a line/loop counter? varible perhaps?
something like:
Dim rCount
or
Dim rCount as integer
??
integers are in the range -32768 to 32768
LONG integers:
I'm trying to create a macro to evaluate the data in a specific column each
row at a a time. The field/column name might be different each time.
I wish at the same time to be able to compile/amend data based upon the
number of same occurrences. In the example below each set can contain a
maxim
Thanks Vaibhav. Will check and revert back to you.
On 2 June 2014 13:50, Vaibhav Joshi wrote:
> Hey
>
> Chek this..
>
> Modified mine earlier posted template to suits you.
>
> Mail will be send using outlook..
>
> Cheers!!
>
>
>
>
> On Mon, Jun 2, 2014 at 12:54 PM, Sandeep Chhajer > wrote:
>
>
Thanks mate.
Function Join(source As Range, Optional delimiter As String) As String
Dim sResult As String
Dim oCell As Range
For Each oCell In source.Cells
If Len(oCell.Value) > 0 Then
sResult = sResult + CStr(oCell.Value) + delimiter
End If
Next
ok..
send me code..
Cheers!!
On Mon, Jun 2, 2014 at 1:38 PM, AndyB wrote:
> Hi,
>
> Thanks so very much for taking the time.
>
> [You are a genius] I have a quick question...looks like the A0 needs to be
> manually entered.
>
> As this is part of a Macro function and I have worked out the fir
Hi,
Thanks so very much for taking the time.
[You are a genius] I have a quick question...looks like the A0 needs to be
manually entered.
As this is part of a Macro function and I have worked out the first part of
the macro [i.e. concatenation] is there a way to insert this very lovely
thing
hi
Can you share me whole excel sheet ..
This will help..
Cheers!!
On Sun, Jun 1, 2014 at 12:59 AM, Nasir Khan
wrote:
> Hello,
> Please see the screenshot in yellow.
> This is how my folders are set up. The destination does not show the
> files in the sub folder after Bkup\\
>
> Circled in
Hi,
Thanks so very much for taking the time. [You are a genius] but I have a
quick question, does A0 needs to be manually entered in this case?
Thanks very much again,
Andy
On Wednesday, 28 May 2014 15:59:48 UTC+1, Vabz wrote:
>
> Hi
>
> PFA,
>
> HTH//Cheers!@
>
>
>
>
> On Wed, May 28, 2014
can you share your file?
On Sat, May 31, 2014 at 2:57 AM, Bill Q wrote:
> Hi,
>
> I am using Excel 2010. I have a macro web query that downloads various
> information. It works fine. No issue there. The only issue that I have is
> that it will stop if it encounters more than 33 or 34 thousand r
Dear Excel Gurus,
I want to make emailing procedure to my client automated.
I have a excel sheet as below
Name of the CompanyConcerned person PAN email ID
ABC LTDMurli JoshiAKJCC0305D
mu...@abc.com
XYZ P LTD
19 matches
Mail list logo
