Sequence of events: first i pasted all my actual data on column A ,then i
set it aside whatever has been utilised, then run the macro on remaining
(remove blanks) , place aside the other data, whatever is left i then,
place it final part of table(or array?)
the macro is run twice but can as
hi
see file i sent, it gives better result..
let me know if i paste wrong data set in col A.
I used same data for col A, b c
Cheers!!
On Thu, Jun 5, 2014 at 12:33 PM, 'Sleek' via MS EXCEL AND VBA MACROS
excel-macros@googlegroups.com wrote:
Sequence of events: first i pasted all my actual
Hi Group,
can you please let me know how can we find last sunday of the month?
excel formula or macro would do.
--
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
use formula =INT((EOMONTH(F1,0)-1)/7)*7+1
where cell f1 contains any date in that month.
Cheers!!
On Thu, Jun 5, 2014 at 12:55 PM, 'Hanumant' via MS EXCEL AND VBA MACROS
excel-macros@googlegroups.com wrote:
Hi Group,
can you please let me know how can we find last sunday of the
=TEXT(MAX((TEXT((ROW(INDIRECT(A1:EOMONTH(A1,0,DDD)=sun)*(ROW(IND
IRECT(A1:EOMONTH(A1,0),DD/MM/)
With c+S+E
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
Sent: Thursday, June 05, 2014 12:55 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
=INT((EOMONTH(A1,0)-1)/7)*7+1
Put any date of the month in question in A1 - does not matter what date.
HTH/Abhishek
On Thu, Jun 5, 2014 at 12:55 PM, 'Hanumant' via MS EXCEL AND VBA MACROS
excel-macros@googlegroups.com wrote:
Hi Group,
can you please let me know how can we find last
can yu explain for one set how it works..
On Thu, Jun 5, 2014 at 12:19 PM, Pravin Gunjal isk1...@gmail.com wrote:
Hi Friends
I want to give the same reason in those cells wherever the day is matching.
I have attached my excel file for your reference. The data is available
in sheet1 and I
NB: you used 96850 twice yet in my data appears only one, 193600 appears
nowhere in your table but i have it in my data.
Those are constants to move around.
You are so close, yet so far.
On Saturday, May 31, 2014 12:11:22 PM UTC+3, Sleek wrote:
I need a minimum or zero difference, against
ok,
what is data to be used then?
is it same for each target or different..?
On Thu, Jun 5, 2014 at 3:19 PM, 'Sleek' via MS EXCEL AND VBA MACROS
excel-macros@googlegroups.com wrote:
NB: you used 96850 twice yet in my data appears only one, 193600 appears
nowhere in your table but i have it
thanks 4 share your ideas.
On Tue, Jun 3, 2014 at 5:07 PM, Paul Schreiner schreiner_p...@att.net
wrote:
probably, but why?
the number usually isn't valuable.
if you have a set of 100 numbers, and the average is 10
another set of 500 numbers, and the average is 20
and a set of 1000 numbers
You can use the data once once only.
You have done it, but i have to juggle the targets around.
The best way is to run macro twice only then in column C of Table to place
what is data is left behind.
When data loads onto column A of table, then remove that data from Column A
of excel(not
Ok, i got that now..
So you are finding min diff between Invoices multiple payment received
allocating in a way which yields you min difference.!!
will change the code to suits your need.
Cheers!!
On Thursday, June 5, 2014 4:30:50 PM UTC+5:30, Sleek wrote:
You can use the data once once
Thanks, VABZ,
Actually making you do extra work, i don't know how to re-pay.
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
Hey
use this for jumping to line..
Sub GetMyData()
Dim ff As Integer
ff = FreeFile
Open C:\Users\a\Desktop\new.txt For Input As ff
mFile = Input(LOF(ff), #ff)
Close ff
Dim splitArr
splitArr = Split(mFile, vbCrLf)
Dim lineNum As Integer
lineNum = 1000 ' change
Please respond to gurjant.si...@damcosoft.com
*Position: SQL DBA Location: Middletown, NJDuration: 6+ Months*
Rate: $45-47/hr MAXX
Required Experience
•2 -3 years IT operation with strong understanding of database
structures, theories, principles, and practices
•3-5 years Microsoft
*Please respond to gurjant.si...@damcosoft.com
gurjant.si...@damcosoft.com*
*Position: Weblogic Admin with Unix Shell ScriptingLocation: Bothell,
WADuration: 6+ Months*
Job Description:
The ideal candidate will be performing following role and responsibilities:
• Candidate should have
also check this:
http://www.excelforum.com/excel-programming-vba-macros/652705-import-specific-line-from-multiple-text-files.html
Cheers!!
On Thu, Jun 5, 2014 at 11:51 PM, Vaibhav Joshi v...@vabs.in wrote:
Hey
use this for jumping to line..
Sub GetMyData()
Dim ff As Integer
ff =
You're the best! Thank you so much!
Chris
On Thursday, June 5, 2014 2:29:20 PM UTC-4, Vabz wrote:
also check this:
http://www.excelforum.com/excel-programming-vba-macros/652705-import-specific-line-from-multiple-text-files.html
Cheers!!
On Thu, Jun 5, 2014 at 11:51 PM, Vaibhav Joshi
Cheers!!
On Jun 6, 2014 12:49 AM, Chris christoph...@gmail.com wrote:
You're the best! Thank you so much!
Chris
On Thursday, June 5, 2014 2:29:20 PM UTC-4, Vabz wrote:
also check this:
http://www.excelforum.com/excel-programming-vba-macros/
Try this
Private Sub Worksheet_Change(ByVal Target As Range)
Dim arr, i As Long
arr = Range(a2:d Range(a65356).End(xlUp).Row - 1)
'On Error GoTo err:
Application.EnableEvents = False
If Target.Count 1 Then Application.Undo
If Target.Column = 2 Then
For i = LBound(arr) To UBound(arr)
20 matches
Mail list logo