Hi Kevin
I tried to look at your revised workbook but it crashed excel.
The macro using my suggested method needs to have another line to make the
generated sheet visible.
I enclose a workbook that includes the completed macro. You should be able
to copy this to yours and uncomment the call to
The code as a file text is easier to copy paste from
--
--
FORUM RULES (986+ 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 ma
Hi Rasheed,
>
You can find below the complete code. I can't send a workbook now as there
are modules and few sheets non relevant. With the new code, I have the
following modifications:
- it will create 2 new worksheets (a temporary original copy of your data
and another sheet output2) provided
Hi Pascal,
Thanks for the code.
I changed the code according to my limited knowledge..
I think I missed something probably..pardon me for my ignorance
When I run the code it gives an error...
Block If without and EndIf and highlights End Function
Can you please paste the whole code
This is the
I´ll try that also, I ended up using one of Paul´s suggestion, it "cleaned"
the code by half :) which was just perfect, but too many options are always
good options. Thank you all a million :)
2012/7/27 Sam Mathai Chacko
> Why not use this.
>
> Select Case Cells(2, j).Value
> Ca
I have a simple excel sheet (attached file) The file is sorted by date
and it shows information about deposits made in a day. Sometimes a deposit
might have more than 1 transaction, sometimes it is just one transaction.
The data is as follows: Date, Unit ID, Amount & Check number (there othe
Hi David,
Thanks for the reply.
However, your amendment to the code does not result in the required
output. If I implement your changes then I no longer get 'new' worksheets
whether there is anything in the J12-31 range.
I really need the code to make the worksheets named as per C12-c31, and
Hi
Use this .. no matter with how many number text started J
=TRIM(MID(C7,MAX(--ISNUMBER(VALUE(MID(C7,ROW(INDIRECT("1:"&LEN(C7))),1)))*RO
W(INDIRECT("1:"&LEN(C7+1,LEN(C7)-MAX(--ISNUMBER(VALUE(MID(C7,ROW(INDIREC
T("1:"&LEN(C7))),1)))*ROW(INDIRECT("1:"&LEN(C7)) with CSE
Pri
Why not use this.
Select Case Cells(2, j).Value
Case "sexta-feira"
Select Case Cells(i, 1).Value
Case *512, 513, 516*
MsgBox "Yay"
Case Else
MsgBox "Aw"
End Select
Case Else
quick fix in the function... base 0 - base 1 arrays confusion fixed.
however, the last row comes with garbage data #NA why so?
Function CopyFirstCol(rg As Range, wsB As Worksheet, NEMP As Long)
'
'This function both copies pastes columns 1 and return an array with merged
cells row numbers
'
Dim
I'm not sure I understand.
You have a folder with files.
You want to rename the files from something I don't know to something else I
don't know.
and you want ME to write macros (more than I've already done)
and send them to you?
normally, it happens the other way.
The person asking for help sen
send attached excel sheet
On 27/07/2012, Paul Schreiner wrote:
> You haven't explained how you're going to know what to change the file name
> TO.
>
> The macro I gave you will generate a list of files and place it in a sheet
> (sheet1)
> in column "A".
>
> you can then add a second column to the
Dear Rajesh,
Please check it..Hope it help to you
http://www.contextures.com/xlDataVal01.html
On Fri, Jul 27, 2012 at 7:38 PM, Rajesh Srinivasaraghavan wrote:
> Hi folks,
> I have been using Excel 2010 for a few months now. Not until recently i
> noticed something strange with Data validation.
You haven't explained how you're going to know what to change the file name TO.
The macro I gave you will generate a list of files and place it in a sheet
(sheet1)
in column "A".
you can then add a second column to the sheet and supply the new name.
You can then write a macro to go through your
Run this statement
Name OldFileName as NewFileName
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of karthikeyan sankaran
Sent: 27 July 2012 7:28
To: excel-macros@googlegroups.com
Sub
Its depend on how you are giving List values.. can you share you file..
"Value1,Value2" will give comma separated value as one element ,
"Value1","Value2" will give two element in dropdowns.
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups
Hi folks,
I have been using Excel 2010 for a few months now. Not until recently i
noticed something strange with Data validation. Thought i should check with
the group if this is a known issue or something specific to my system. When
i created Data validation with "Allow list"& input two drop down
How to rename the get file name through excel macro
On 27/07/2012, Paul Schreiner wrote:
> How much help do you need?
> Do you know anything about VBA?
> Have you tried anything on your own?
>
> This macro will generate the list of .pdf files in C:\temp
> into a list.
>
> Sub Get_Files()
> Di
How much help do you need?
Do you know anything about VBA?
Have you tried anything on your own?
This macro will generate the list of .pdf files in C:\temp
into a list.
Sub Get_Files()
Dim SourceDir, R
Dim fso, Fldr, Files, File
Dim Sht
Set fso = CreateObject("Scripting.FileSy
I might prefer a macro to get the data and avoid links but vlookup should work
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Richard
Sent: Thursday, July 26, 2012 10:32 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Budgeting Process
I have
Hi,
I have a 500 files(.pdf/.xls/.txt) in one folder.How to get .pdf files
name only in excel sheet and rename desired name what i entered in
other column in excel sheet.
ex: old namedesired name
A.pdf karthik.pdf
can any help and resolve this problem.Thanks for
The "Select Case" condition could be used to replace a "OR" condition. not
really an "AND" condition.
Kind-of.
It's really more like replacing ElseIF.
For instance, you could use:
both of these examples yield the same result:
'
Dear Praskandan,
You can use Global Vlookup
Example:
=Iferror(Vlookup for Person 1,iferror(Vlookup for person 2,"N/A"))
Hope it will help to you.
otherwise
Send sample.
On Tue, Jul 24, 2012 at 4:21 PM, Praskandan wrote:
> Hi,
>
> Need Help on Vlook Up in Excel 2007:-
>
> A Case is assigned
Dear Jorge,
Please share sample workbook.
On Wed, Jul 25, 2012 at 3:36 PM, Jorge Marques wrote:
> Hi guys, can anybody help me turning this If macro to an case macro.
>
> Sub friday()
>
> For i = 1 To 200
> For j = 1 To 200
>
> If Cells(2, j).Value = "sexta-feira" And Cells(i, 1).Value = 512 Or
Dear all Excel experts
I think create master sheet then in index I will show name with power point
effect means diffrent type of effect come (left,Right,Up,Down) anyway.I I
click any name (which click) then that name will come with power point
effect (Dashing effect) & also amazing idea if possible
Dear Gurus,
Can we create a macro or how can we send mails if my excel book is closed.
like i have data:--
Name Email IDDate Difference
Days
A a...@mail.com 12-12-2011 1
B b@*mail.com* 15-12-2
Excellent Master!!!
was looking out the answer in formula only... so working superb !!
thanks a ton to every one for your valuable efforts !!
cheers
JP
On Fri, Jul 27, 2012 at 2:24 PM, NOORAIN ANSARI
wrote:
> Dear JP,
>
> by Formula, You can use..
>
> =TRIM(RIGHT(C7,LEN(C7)-COUNT(--MID(C7,RO
Dear JP,
by Formula, You can use..
=TRIM(RIGHT(C7,LEN(C7)-COUNT(--MID(C7,ROW(INDIRECT("1:"&LEN(C7))),1)))
with ctrl+shfit+enter
See attached sheet.
On Fri, Jul 27, 2012 at 1:09 PM, NOORAIN ANSARI wrote:
> Dear JP,
> Please See attached sheet.
>
>
> On Fri, Jul 27, 2012 at 1:04 PM, NOORAIN A
Dear JP,
See the attached, hope this too will help you for extracting text.
Thanks & Regards,
*Deba Ranjan P*
On Fri, Jul 27, 2012 at 1:02 PM, NOORAIN ANSARI wrote:
> Dear JP,
>
> Formula is working fine..
> Please see attached sheet.
>
> On Fri, Jul 27, 2012 at 12:32 PM, Jayapra
Dear JP,
I got my mistake..Just i am sending you correct answers.
On Fri, Jul 27, 2012 at 1:02 PM, NOORAIN ANSARI wrote:
> Dear JP,
>
> Formula is working fine..
> Please see attached sheet.
>
> On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S <
> bhat.jayaprak...@gmail.com> wrote:
>
>> Dear Expe
Dear JP,
Formula is working fine..
Please see attached sheet.
On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S
wrote:
> Dear Experts,
>
> Good Morning.
>
> I have a case where in Data is built in with Text (1 & 2 Digits, Eg: 1
> Uttar Pradesh, 20 Jharkhan) and without text also (CSD, Nepal). I
>
Dear Noorain,
My data is in Column "C"... if i change the column in your formula
then it is giving the Text with number only...
Please relook in to it and help me.
thank you.
JP.
On Fri, Jul 27, 2012 at 12:48 PM, NOORAIN ANSARI
wrote:
> Dear JP,
>
> See attached sheet.
>
>
> On Fri, Jul 27, 2
Pls find attached sheet FYI
Regards,
Gawli Anil
On Fri, Jul 27, 2012 at 12:47 PM, NOORAIN ANSARI
wrote:
> Dear JP,
>
> Please use..
>
> *=SUBSTITUTE(UPPER(E7),CHAR(ROW(INDIRECT("48:58"))),"")*
>
>
> On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S <> wrote:
>
>> Dear Experts,
>>
>> Good Morning.
>
Dear JP,
See attached sheet.
On Fri, Jul 27, 2012 at 12:47 PM, NOORAIN ANSARI
wrote:
> Dear JP,
>
> Please use..
>
> *=SUBSTITUTE(UPPER(E7),CHAR(ROW(INDIRECT("48:58"))),"")*
>
>
> On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S <
> bhat.jayaprak...@gmail.com> wrote:
>
>> Dear Experts,
>>
>> Good
Dear JP,
Please use..
*=SUBSTITUTE(UPPER(E7),CHAR(ROW(INDIRECT("48:58"))),"")*
On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S
wrote:
> Dear Experts,
>
> Good Morning.
>
> I have a case where in Data is built in with Text (1 & 2 Digits, Eg: 1
> Uttar Pradesh, 20 Jharkhan) and without text also
Dear Bhat.
Pls find Attached Sheet FYI
Regards,
Gawli Anil
On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S <> wrote:
> Dear Experts,
>
> Good Morning.
>
> I have a case where in Data is built in with Text (1 & 2 Digits, Eg: 1
> Uttar Pradesh, 20 Jharkhan) and without text also (CSD, Nepal). I
>
Dear Experts,
Good Morning.
I have a case where in Data is built in with Text (1 & 2 Digits, Eg: 1
Uttar Pradesh, 20 Jharkhan) and without text also (CSD, Nepal). I
required help to replace Olny the Text.
enclosed sample file. Please help.
Thank you.
JP.
--
--
FORUM RULES (986+ members alr
37 matches
Mail list logo
