Hi CG,
PFA.
Regards,
Anoop
On Thu, Dec 6, 2012 at 12:59 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:
Hi ,
I need to extract a relevant portion from Excel cell.
Attached example file.
Many Regards,
C.G.Kumar
--
Join official Facebook page of this forum @
HERE IS THE SOLUTION
--- On Thu, 12/6/12, C.G.Kumar kumar.bemlmum...@gmail.com wrote:
From: C.G.Kumar kumar.bemlmum...@gmail.com
Subject: $$Excel-Macros$$ Extracting Text from Cell
To: excel-macros@googlegroups.com
Date: Thursday, December 6, 2012, 12:59 PM
Hi ,
I need to extract a relevant
Hi,
Another way to do this with lesser formulas
Regards,
Nishant
On Thu, Dec 6, 2012 at 3:36 PM, ravinder negi ravi_colw...@yahoo.comwrote:
HERE IS THE SOLUTION
--- On *Thu, 12/6/12, C.G.Kumar kumar.bemlmum...@gmail.com* wrote:
From: C.G.Kumar kumar.bemlmum...@gmail.com
Subject:
Dear Anoop,
Thanks.
But the formula in sector gives errorenous result when the last text are
like HYD/DXB/AMS/DXB/HYD
Sample attached.
Can you advise.
On Thu, Dec 6, 2012 at 2:16 PM, Anoop K Sharma aks.sharm...@gmail.comwrote:
Hi CG,
PFA.
Regards,
Anoop
On Thu, Dec 6,
Hi group ,
Actually I am new here , And I am asking for you support
Attached file has table for lease , I am searching for the possibility to
get alarm from excel before the due date by certain period (i.e one week
before , two weeks ,)
Thanks for all
--
Join official Facebook page of
hi Ahmed,If you want this through conditional formatting then you can paste
this =INDIRECT(gROW())=TODAY()+14 in conditional formatting formula thanks
--- On Thu, 12/6/12, Ahmed Ab abab19800...@gmail.com wrote:
From: Ahmed Ab abab19800...@gmail.com
Subject: $$Excel-Macros$$ Lease date alarm
Thanks prince but I get a debug error on the
Strtname =sheets(1).range(a1 rows.count).end(xlup)
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Prince prince141...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 6 Dec 2012 03:51:53
To:
That's not really my question(s).
I can write a function that checks sheet3, then sheet2, then sheet1.
But that's not very efficient if tomorrow you have to check 4 sheets, then 5 on
the next day.
also, a function could work for 20-30 rows, but if you get into a larger
spreadsheet,
the
Hello,
I have a set of 51 unique names.
I want to extract rows that contain any one of the 51 names.
Please help.
Thank you,
Sharath
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles,
I have a couple of questions for you:
1) How do you obtain the string?
If that's not important for this exercise (you'll supply the string), I can
use StrValue as the variable and your can set this value however you may.
2) I believe you're saying that you want the user to enter the number of
use advance search option
http://office.microsoft.com/en-001/excel-help/filter-by-using-advanced-criteria-HP005200178.aspx
On Thu, Dec 6, 2012 at 7:36 PM, sharath chandra
sharath.c.sambr...@gmail.com wrote:
Hello,
I have a set of 51 unique names.
I want to extract rows that contain any
LOTS of ways to do this.
Some are much better than others (faster, more efficient)
We need more to work with.
- Are the rows filled with sentences, or multiple columns of values?
- Will the name match the entire cell value, or a portion of a larger string?
- Do you wish a case sensitive match?
try these links see if it helps
http://www.dailydoseofexcel.com/archives/2006/11/29/html-tables/
http://www.tushar-mehta.com/publish_train/xl_vba_cases/vba_web_pages_services/index.htm
On Thu, Dec 6, 2012 at 5:46 PM, Rakesh Joshi rakesh.ri...@gmail.com wrote:
how update value in text box in
try this
=RIGHT(G4,LEN(G4)-FIND(~,SUBSTITUTE(G4,
,~,LEN(G4)-LEN(SUBSTITUTE(G4, ,)
On Thu, Dec 6, 2012 at 4:07 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:
Dear Anoop,
Thanks.
But the formula in sector gives errorenous result when the last text are
like HYD/DXB/AMS/DXB/HYD
Hi experts
I have been able to amend the code to pick any new sheet name that Ȋ̝̊̅§
created.
What I kindly request Ȋ̝̊̅§ the format from the first sheet to the new sheet.
See ♍Ɣ new code below.
Sub copydata()
Dim ws1 as worksheet
Dim ws2 as worksheet
Dim strtname as string
strName =
Dear Expert,
I'm keen to learn many things on excel but I don't have proper guide line like
assignment or example to work out.
Can you please provide if you have anything's. So that I can improve my excel
skill
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONMENT
Here's a test file based on some of the assumptions below.
It's in Excel 2010 format.
If you need Excel97/2003 let me know.
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
Do you have the password?
Is it asking for the password when you open the file? or when you try to
select the range?
(need to figure out if you are dealing with a protected file or sheet)
if your password is easypwd then:
If the workbook is password protected, you can use:
Hi Team,
can you please help me with a formula to calculate the number of weeks from
today to a future date.
--
Regards,
Vinay. T
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles,
Used Macro recording to achieved ♍Ɣ purpose thanks
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: resp...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 6 Dec 2012 13:16:02
To: excel-macros@googlegroups.com
Reply-To:
Becky,
This looks like FUN (I know, sick AND twisted!)
---
There's a few things I need to help you out.
First of all, do you recieve this data already in an Excel file?
or is it a flat text file?
If it's a text file, it would almost be easier to use VBA to read the
WEEKS is easy.
Keep in mind that Excel dates are simply numbers.
The number of days since 1/1/1900.
You can use =TODAY() to get today's date:
So today (12/6/2013) is: 41249
a future date, for say, 11/8/2014 is 41951
The difference is: 41951 - 41249 = 702
divide that by 7 to get the number of
http://www.exceltip.com/st/Calculating_Number_of_Days,_Weeks,_Months_and_Years_between_Dates/915.html
On Thu, Dec 6, 2012 at 8:48 PM, t vinay vinaytu...@gmail.com wrote:
Hi Team,
can you please help me with a formula to calculate the number of weeks
from today to a future date.
--
Hi Hilary,
Your first query solution is:
Ws1.range(a1:ak132).copy
Ws2.range(a1:ak132).pastespecial xlall
application.cutcopymode=false
for Query 2: do you want set ws2 name should be strName ?
regards
prince
On Thursday, December 6, 2012 8:52:37 PM UTC+5:30, hilary lomotey wrote:
Used
Yes that Ȋ̝̊̅§ what I did.
The effect of that being 3 different macros
One to create a new sheet and name the sheet by the name item
Second to copy data from a particular sheet and paste it in the sheet created
above
The last one Ȋ̝̊̅§ to copy the format in that particular sheet and paste it
Hi vinay,
Use this formula it will give you no of weeks between two dates:
let suppose : A1 contain Todays Date and C1 contain futures date then:
in A4:* = trunc((C1-A1)/7)*
*
*
*
*
*Regards*
*Prince*
*
*
On Thursday, December 6, 2012 8:48:34 PM UTC+5:30, t vinay wrote:
Hi Team,
can
Hi Sharath,
Can you pls provide ur workbook so that we can give you exact solution.
regards
prince
On Thursday, December 6, 2012 7:36:09 PM UTC+5:30, sharath chandra wrote:
Hello,
I have a set of 51 unique names.
I want to extract rows that contain any one of the 51 names.
Please
Paul,
I'm very excited to find someone who thinks this will be fun! Once I know
more, I'm sure I'll think it's fun, too. :) I'm currently training other
staff members, but I will answer your questions as soon as possible later
today. I believe we do have the option of exporting as a text file.
Hi Expert
I want to convert many excel file in text format. So is this possible
to convert file without open a file or save as options. becouse i have
to consolidated many excel file in one excel so is this any suggestion
so please help
Thanks
Manoj
--
Join official Facebook page of this forum
There IS a way to get to the data in an excel file without opening it,
but I've not worked with that much.
Mainly because it's very convenient to simply have Excel disable display
updating.
In which case a macro can open hundreds of excel files and file/save them as
text files
in a relatively
I've got a tracking sheet with 6 columns, each row being an entry for
equipment maintenance. Column C contains the serial number of the
equipment. On a separate
sheet I have a summary, by serial number, that I want to calculate the
total number of times a particular entry is made on the
Hi All,
Is it possible to convert a Bitmap image (BMP) into a Excel file through
some Macro?
If it is possible then please send me the code.
Thanks in advance.
--
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use
Hi,
Please find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Thu, Dec 6, 2012 at 11:40 PM, JMac jsvi...@gmail.com wrote:
I've got a tracking sheet with 6 columns, each row being an entry for
equipment maintenance. Column C contains the serial number of the
equipment.
If you're wanting to do it with simple functions..
What I'd do is add a column to the tracking sheet in which you
concatenate the serial number and activity.
Like: Cell G1: =C1F1
and copy down.
Then, in the summary sheet, you can use:
=COUNTIF(Tracking!G:G,A1B1)
Paul
When I opened the file, the formulas don't work on my PC. WIll they not
work in Excel 2003 ?
Thanks
On Thursday, December 6, 2012 1:10:14 PM UTC-5, JMac wrote:
I've got a tracking sheet with 6 columns, each row being an entry for
equipment maintenance. Column C contains the serial number
Hi,
PFA
On Fri, Dec 7, 2012 at 12:30 AM, JMac jsvi...@gmail.com wrote:
When I opened the file, the formulas don't work on my PC. WIll they not
work in Excel 2003 ?
Thanks
On Thursday, December 6, 2012 1:10:14 PM UTC-5, JMac wrote:
I've got a tracking sheet with 6 columns, each row
Ravinder Negi
Thanks for your support , But it does not work
Regards
Ahmed
On Thursday, December 6, 2012 1:50:24 PM UTC+3, Ahmed Ab wrote:
Hi group ,
Actually I am new here , And I am asking for you support
Attached file has table for lease , I am searching for the possibility to
get
On Thursday, December 6, 2012 9:17:50 AM UTC-6, Paul Schreiner wrote:
Do you have the password?
Is it asking for the password when you open the file? or when you try to
select the range?
(need to figure out if you are dealing with a protected file or sheet)
if your password is
Need to create a summary sheet for the attached Excel doc.
Tab “Detailed” is the input tab and works fine.
Tab “Summary” should show the name from the A column in “Detailed” in any
cell that corresponds.
An example is showing Booth 1 is:
9am
10am
11am
12pm
Booth 1
Person6
Paul,
Wow! OK, let's see what we can do. Going with your most recent post first:
I tried running the ReadData first pass on the real output. I got an error:
Run-time error '9': Subscript out of range. When I chose debug, the
code that was highlighed was Ln 41, Col 1:
Hi Ahmed
If you want more help you will have to give us more information. It is not
helpful to just say It did not work You need to tell us just what you
want to happen when the date arrives, and you need to tell us what happened
when you made inserted the conditional formatting. It would be
Hi ppl ,
Could u suggest some good vb and macros
material
On Dec 5, 2012 6:56 AM, Dhaval Shah todhavals...@gmail.com wrote:
Friends,
pls go through the attached excel sheet
in main sheet there is raw data of differenet date for different product
now suppose product x trade for 5 days and
It worked.
Thanks a lot.
On Thu, Dec 6, 2012 at 8:01 PM, ashish koul koul.ash...@gmail.com wrote:
try this
=RIGHT(G4,LEN(G4)-FIND(~,SUBSTITUTE(G4,
,~,LEN(G4)-LEN(SUBSTITUTE(G4, ,)
On Thu, Dec 6, 2012 at 4:07 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:
Dear Anoop,
Thanks.
Thanks Anoop for helping supporting me.
Regards,
C.G.Kumar
On Fri, Dec 7, 2012 at 9:40 AM, Anoop K Sharma aks.sharm...@gmail.comwrote:
Use the Ashish's formula for second case.
Regards,
Anoop
On Thu, Dec 6, 2012 at 8:01 PM, ashish koul koul.ash...@gmail.com wrote:
try this
Hi,
=WEEKNUM(Future date,2)-WEEKNUM(today(),2)Weeknum gives number of week
you can change option (2) in formula as per your requirement, formula will
prompt you when you enter formula.
If this works otherwise tell us more detail
--- On Thu, 12/6/12, t vinay vinaytu...@gmail.com wrote:
From: t
Dear Team,
Can you help me how to calculate age ( in Year, month day) in Excel
--
Regards,
Rakesh Kumar Sharma
Contact: +91-9971024741
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread
Hi Annop,
Good Solution.But If there are Constant number both cell then I want
Neutral arrow,can it possible?
Regards Amar
On Wed, Dec 5, 2012 at 11:35 AM, Anoop K Sharma aks.sharm...@gmail.comwrote:
Please find attached. I hope this can help you.
Regards,
Anoop
Sr. Developer
On Wed,
Hi,
if the date is (D111) - 12/20/1991, then
for no. year : =DATEDIF(D111,TODAY(),y) = 20
for no. of month : =DATEDIF(D111,TODAY(),m) = 251
for no. of days : =DATEDIF(D111,TODAY(),d) = 7658
--- and if you want link 20 years, some month and some days then -
just chnage the text as -
for
Use the following one
=IF(B2$A$2,↓,IF(B2$A$2,↑,↕))
On Fri, Dec 7, 2012 at 12:37 PM, amar takale amartak...@gmail.com wrote:
Hi Annop,
Good Solution.But If there are Constant number both cell then I want
Neutral arrow,can it possible?
Regards Amar
On Wed, Dec 5, 2012 at 11:35 AM, Anoop
Hi Rakesh,
follow below link:
http://www.cpearson.com/excel/datedif.aspx
Regards
Anoop
On Fri, Dec 7, 2012 at 12:12 PM, Rakesh Kumar Sharma rakeshks@gmail.com
wrote:
Dear Team,
Can you help me how to calculate age ( in Year, month day) in Excel
--
Regards,
Rakesh Kumar Sharma
50 matches
Mail list logo