Hi Frineds,
Please find the attached file for your reference. I need to concatinate /
Consolidate based on condition.
FORMULA or by MACRO
Thanks
N.Sundarvelan
9600160150
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Amazing..!!
Kaяan
http://www.facebook.com/singhkarann http://twitter.com/#%21/karan1237
https://plus.google.com/43524614789164919/posts
http://www.myspace.com/singhkaran http://www.linkedin.com/in/singhkarann
http://karanxel.blogspot.com/ http://karanxel.wordpress.com/
On Tue, Nov 1,
check if it helps
On Tue, Nov 1, 2011 at 12:03 PM, Sundarvelan N nsund...@gmail.com wrote:
Hi Frineds,
Please find the attached file for your reference. I need to concatinate /
Consolidate based on condition.
FORMULA or by MACRO
Thanks
N.Sundarvelan
9600160150
--
FORUM RULES (925+
Asish Thankyou so much!
Very Very Thanks
Thanks
N.Sundarvelan
9600160150
On Tue, Nov 1, 2011 at 12:37 PM, ashish koul koul.ash...@gmail.com wrote:
check if it helps
On Tue, Nov 1, 2011 at 12:03 PM, Sundarvelan N nsund...@gmail.com wrote:
Hi Frineds,
Please find the
I have a spreadsheet containing about 7K Business Names. It is
considered a Master List of vendors. I have another with about 300
names, and I need to know if any of these are contained in the first
one. The problem is the smaller one may list the company name as The
Acme Company, while the
Hi,
I need help with the following task. Thanks in advance
I am using MS Excel 2010.
I have two folders: A B. I want to do the folllowing tasks
1, Every month I want to copy all files that are 1 month old (these
are all .PDF files) from folder A to folder B.
2, Then I want to verify if the
--here we write out the macro to highlight active stocks in
yellow
v.line_out = 'Sub Color_Active_Yellow()'
v.line_out = 'Dim CellVal As Variant'
v.line_out = 'Selection.CurrentRegion.Select'
v.line_out = 'iRows = Selection.Rows.Count'
Hi Darryl
can you share the sample file also check the attachment see if it helps
On Tue, Nov 1, 2011 at 2:15 AM, Darryl d...@dgoebel.com wrote:
I have a spreadsheet containing about 7K Business Names. It is
considered a Master List of vendors. I have another with about 300
names, and I
Hi Fin,
Yes, it's definitely possible!
As Sam suggested, if you could post a sample workbook, it would help get you
an exact solution.
I know nothing about REXX script. And your other logic about the stocks,
and where the information is coming from isn't clear to me.
Here, though, is
Here's one that takes care of both the unique list and the concatenation
Regards,
Sam Mathai Chacko
On Tue, Nov 1, 2011 at 9:11 AM, Sundarvelan N nsund...@gmail.com wrote:
Asish Thankyou so much!
Very Very Thanks
Thanks
N.Sundarvelan
9600160150
On Tue, Nov 1, 2011 at
Dear Members,
I have two sheets in my excel file. In sheets1 i have data but sheets2 is
blank.
I want when i select a value of sheet1 it copy and paste in sheets2
automatically
this will repeat again and again for each value.
Thanking you in Advance
Regards,
Sanjib
--
--
FORUM RULES (925+
Sub CopyFromSheetToAnotherSheet()
Selection.Copy Sheets(2).Range(Selection.Cells(1).Address)
End Sub
Regards,
Sam Mathai Chacko (GL)
On Tue, Nov 1, 2011 at 10:42 AM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear Members,
I have two sheets in my excel file. In sheets1 i
Dear Sam,
how to execute that.
Thanking you
Regards,
Sanjib
On Tue, Nov 1, 2011 at 2:20 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Sub CopyFromSheetToAnotherSheet()
Selection.Copy Sheets(2).Range(Selection.Cells(1).Address)
End Sub
Regards,
Sam Mathai Chacko (GL)
On Tue,
Dear All,
I've around 8k cell which has data showing below, I need your help to
extract specific text from the string. I need to extract text after first
comma ( *,* ) before left paranthesis as showing below.
Kindly help.
Govt College of Engineering, Wayanand, P O Nallurnad, Mananthavady
PFA
Best Regards
Momin Siraj Ahmad
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of karan 1237
Sent: 01 November 2011 01:39 PM
To: excel-macros@googlegroups.com
Subject: [bulk] $$Excel-Macros$$ Extract Text
Importance: Low
Dear All,
I've
Group the sheets
http://spreadsheetpage.com/index.php/tip/making_an_exact_copy_of_a_range_of_formulas/
or add sam's macro to any module and then select any cell sheet 1 and run
the macro
On Tue, Nov 1, 2011 at 3:02 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear Sam,
how to
I think you forgot to assign macro to the button.
On Tue, Nov 1, 2011 at 11:38 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Group,
Pls find attached Animated Chart.
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
Its working..! Great!
Thanks a lot Momin..!
Kaяan
http://www.facebook.com/singhkarann http://twitter.com/#%21/karan1237
https://plus.google.com/43524614789164919/posts
http://www.myspace.com/singhkaran http://www.linkedin.com/in/singhkarann
http://karanxel.blogspot.com/
thank you sam and thank you Ashish
regards
sanjib
On Tue, Nov 1, 2011 at 2:12 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear Members,
I have two sheets in my excel file. In sheets1 i have data but sheets2 is
blank.
I want when i select a value of sheet1 it copy and
Dear Umar.
PFA
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Tue, Nov 1, 2011 at 3:52 PM, Umar Abeer umarab...@googlemail.com wrote:
I think you forgot
Or, a macro to look for darryl or acme
Sub findem()
Dim c As Range
On Error Resume Next
For Each c In Range(b2:b3)
Set myfind = Columns(A).Find(What:=acme, LookIn:=xlValues, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext)
If Not myfind Is Nothing Then MsgBox c found at row
Nice creativity... :)
On Tue, Nov 1, 2011 at 12:16 PM, sudhir kumar
sudhir.ku...@lazerindia.comwrote:
** **
** **
*From:* Sukhvir Verma [mailto:sve...@eigen-tech.com]
*Sent:* Tuesday, October 25, 2011 11:51 AM
*To:* sudhir.ku...@lazerindia.com
*Subject:* Village
*Importance:* Low
Good morning
I am having some issues in achieving a solution to the following
problem:
I have multiple worksheets which provide me with different views of
essentially the same data. I would like to be able to select from a
number of different parameters through drop down lists on each
individual
Dear Aamir,
Can u tell me where will be addins folder?
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Sam Mathai Chacko
Sent: 01 November 2011 12:41
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Convert amount to Million
Aamir,
Please
Thanks Ashish,
But the program is not working , when I pick the source directory I
get an error saying Permission Denied and when you click on the
debugger the following line is highlighted in the code.
fso.Copyfile fil.Path, Sheets(1).Range(b1).Value
What I want from the program is as follows.
IF??? you trust that excel WILL copy then you could simply use NAME. Example
from HELP
Dim OldName, NewName
OldName = OLDFILE: NewName = NEWFILE' Define file names.
Name OldName As NewName' Rename file.
OldName = C:\MYDIR\OLDFILE: NewName = C:\YOURDIR\NEWFILE
Name OldName As NewName
Dear Reto,
Can you share any Sample sheet with Group.
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Tue, Nov 1, 2011 at 5:09 PM, Reto
For Excel 2007/2010
Rootdrive\Documents and Settings\User\Application Data\Microsoft\Addins.
Regards,
Sam
On Tue, Nov 1, 2011 at 9:31 AM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
Dear Aamir,
** **
Can u tell me where will be addins folder?
** **
*From:*
Do you REALLY want it to run in two separate steps?
(Copy all old files, then remove all old files)
Or can it copy/check/remove in one loop?
Option Explicit
Sub Archive_Files()
Dim fso, fldr, flc, f, fName, Fil, fDate
Dim OldDate
Dim Folder_From, Folder_To
Dim msg, msg2
Be sure to save your file as .xlsM
Option Explicit
Sub lineemupSAS()
Dim i As Long
For i = Cells(Rows.Count, 3).End(xlUp).Row To 1 Step -1
If Cells(i + 1, c) = Cells(i, c) And _
Cells(i + 1, d) = Cells(i, d) Then
Cells(i, e) = Cells(i, e) , Cells(i + 1, e)
Rows(i + 1).Delete
End If
Your first task is to standardize the lists.
I would suggest first taking both lists and make a copy.
then, in the copy, remove all punctuation, and common terms like
inc, company, the, lastly: double-spaces.
Then, I would build a dictionary of terms by loading the master list
into a Dictionary
Oops.. I noticed that I forgot to change my N:\ drive to the P:\ drive that
was originally requested...
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the
Paul,
The script you wote is great. I just did not know that you could do
all the actions in one step.
I ran the script and here is what its doing.
In the From directory I have files that were created between
9/1/2011 9/30/2011 your program moved them all correctly.
Than there were files that
What did the message box say about the number of days?
Modify the msg variable to say:
msg = Old Files: OldDate
which should give the date 10/1/2011.
we may want to change the display of the DateDiff to .00
to see if perhaps it's including the time
The olddate would be counted as
I checked.
It seems that the DateAdd is including the current TIME when calculating
OldDate.
Instead, I used
OldDate = DateAdd(m, -1, DateValue(Now()))
and it removes the TIME of Day.
Try it with this change.
Paul
-
“Do all the good you can,
By all
BTW...
Instead of .copyfile and .deletefile
you CAN use .movefile
if the file is successfully moved, it deletes the original.
However, using .copyfile.. you COULD rename the file to include the current
date
in the filename...
Just as an option...
Paul
Sure you can make the little tweak needed in Paul's macro. Anyway, did you
check my post? I thought it also does what you just mentioned below.
Sam
On Tue, Nov 1, 2011 at 9:02 PM, Dave davidstev...@gmail.com wrote:
Paul,
The script you wote is great. I just did not know that you could do
Guys
I have some serious and need some help.
I have an excel file with these field
Debt : Equity Ratio
*Insert Debt to Equity Ratio: * *3.00* Up to 2 3 Above 2 to 3 1 Above 3
to 4 0 Above 4 -3 Score 1
The score is derived through a formula. The cell shall be protected and no
Here is how I have your script with all the mods you suggested. Its
still not copying the files from October 2011. Move command will not
work as it screws with permissions etc.
When I run the script the Window says Old Files: 10/1/2011 and then it
lists all the files created in September 2011.
Sam,
I just ran your script and its doing the same thing as Paul. Copies
files for September but leaves October files alone.
On Nov 1, 9:22 am, Sam Mathai Chacko samde...@gmail.com wrote:
I was modifying it while Paul had already posted. This is on similar lines,
but used Ashish's template
It's ok then?
The original post said:
1, Every month I want to copy all files that are 1 month old (these
are all .PDF files) from folder A to folder B.
So, we determine the date from (1) month ago:
OldDate = DateAdd(m, -1, DateValue(Now()))
and move any file older than that date.
So, today
Here's how you do it Mahreen.
Create a named range using the formula you already have. And in validation,
use List, and type NA,=NmRnge
where NmRnge is your named range
Check attached.
Sam
On Tue, Nov 1, 2011 at 9:53 PM, Mahreen Ellahi mahreen.acc...@gmail.comwrote:
Guys
I have some
Paul Sam,
Thanks you were both correct . Your program works as I requested.
Copies everthing a month old. I was not getting it untill Paul showed
me where to look at.
Thanks for everone for your help.
On Nov 1, 12:04 pm, Paul Schreiner schreiner_p...@att.net wrote:
It's ok then?
The original
Haseeb,
Can you help me to modify this slightly? I still need to use the date
range as specified in A2 and A4, but instead of doing the whole
substitution, I would like for it to either return the actual line to
the C column if it contains a remark+date in valid range, or a blank
line if it
Dave,
How I couldn't agree more with Paul.
Let me put it this way. October is NOT more than a month old. Any file in
September IS a month old. If you want to move something that is from the
previous month, then change DateSerial(Year(Date), Month(Date) - 1,
Day(Date)) to DateSerial(Year(Date),
Hey thanks, but one more prob, wen i sum up all such scores with few
numbers and text NA, i cant derive the total score. Ofcourse its a text
thatsy but is there any possibility i can show the result ignoring the NA
On Tue, Nov 1, 2011 at 10:23 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Ah! You have already posted while I was typing. Good that we all are on the
same page :D. Happy posting
Sam
On Tue, Nov 1, 2011 at 11:02 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Dave,
How I couldn't agree more with Paul.
Let me put it this way. October is NOT more than a month old.
Why don't you use something like this
=SUMIF(A1:A10,NA)
Regards,
Sam
On Tue, Nov 1, 2011 at 10:58 PM, Mahreen Ellahi mahreen.acc...@gmail.comwrote:
Hey thanks, but one more prob, wen i sum up all such scores with few
numbers and text NA, i cant derive the total score. Ofcourse its a text
I gotta type FAST if I'm going to compete with the Most Helpful Member..
oh wait...
I wonder if it score the total number of RESPONSES, or the total number of
unique individuals?
If it's responses... then one could just respond with a lot of BAD ideas to run
up the tally!..
Of course, that
For the actual text, rather than SUBSTITUTE, one way is, C7 copy down.
=IF(ISNA(remark
LOOKUP(2,MATCH(*TEXT(ROW(CurrPeriod),mm/dd/)*,A7,0),ROW(CurrPeriod))),,A7)
Haseeb
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
Hello Sam;
A nice solution with Validation.
Hello Mahreen;
If you use 3, 2, 1 (number inside ) this will return the number as
text. When you do calculation excel is considering these as text. Use it
without or you can simplify the formula to;
Congratulations Sam
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post
We can save the add in file into any other location, just give the path
from excel, am I right SAM?.
SAM please brief the procedure of this add in, why you created Module
Class Module in this add in. So that I can capable to create some more add
in.
Thanks again for this wonderful solution.
Dear Noorain, Dear Haseeb,
Thank you. Noorain, you've already been there. Have learned things
from you. Haseeb, you are a gem of a formula champion. thanks for all
the learning. Noorain, thank you for posting at the domain page also.
For all well wishers, thank you for regarding my time. Just to
Hi All,
I need your help regarding a macro issue. Suppose I have 5 folder in
different in my
computer desktop and each folder contains a excel file (same name).
Now I want a macro which will open each folder and then open the file and
will copy the
first cell then paste it in my current file
Hi All,
I need your help regarding a macro issue. Suppose I have 5 folder in
different in my
computer desktop and each folder contains a excel file (same name).
Now I want a macro which will open each folder and then open the file and
will copy the
first cell then paste it in my current file
If you only have that many why not just do thru a formula where the file
does not have to be open. Notice the placement of the '
You could even use indirect to put in the file name, etc
='C:\aa\[3.xls]Sheet24'!A3
*For Internal Use of Employer (Please don't delete or modify while
replying to this email)* Monster Resume ID: 14813996 Personal Folder
ID: 10545077 *
*
We have an urgent opening with one of the leading UK based telecom company
for the position of Associate-MIS/Operations
Experience
58 matches
Mail list logo