Dear marcio,
You can also use..
=INDEX($2:$2,0,LARGE(IF(C3:Z30,COLUMN($C$2:$Z$2),),COLUMN(A2)))
with ctrl+shift+enter
See attached sheet.
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On Mon, Mar
Dear Jim,
Please share your workbook
On Sat, Mar 10, 2012 at 6:13 AM, Jim sch...@gmail.com wrote:
I'm using Group by Day with 7 days to create the following example:
1/1/2012 - 1/7/2012
1/15/2012 - 1/21/2012
1/22/2012 - 1/28/2012
1/29/2012 - 2/4/2012
1/8/2012 - 1/14/2012- out of
Dear Group, I want to select multiple cell values(a1 b1) to change the
target cell C1.
Can I do it like this? Plz suggest?
If any formula or code, anyway that can do well plz send.
Regards,
Muneer,
CC...
--
FORUM RULES (986+ members already BANNED for violation)
1) Use
May be this can help -
http://www.vbaexpress.com/kb/getarticle.php?kb_id=433
On Mon, Mar 12, 2012 at 1:42 PM, Mohammed Muneer mmun...@ccc.com.qa wrote:
Dear Group, I want to select multiple cell values(a1 b1) to change the
target cell “C1”.
** **
Can I do it like this? Plz
hello
long time no see!how are you recently?i have bought a laptop on the
www.purchasing-bar.com
low price ,100% original and i am sure you can find the best item for you !have
a try,zolgyfa.com
Regards!
click here or www.purchasing-bar.com
--
FORUM
hi Asa rossoff,
Thanks alot for your advise could please forward the tested macro with
these changes.
thanks in advance.
On Mon, Mar 12, 2012 at 7:37 AM, Asa Rossoff a...@lovetour.info wrote:
Hi Rekha,
You can change the line that sets the vertical position from:
A macro approach.
Sub lineemupSAS()
Dim i As Long
Dim j As Integer
Application.ScreenUpdating = False
For i = 1 To Cells(Rows.Count, 2).End(xlUp).Row Step 4
For j = 1 To 4
Cells(i, j + 2).Value = Cells(j + 1, 2).Value
Next j
Next i
‘clean up
You can help yourself learn. Record a macr while
select your rangedatafilterfilter by datecopy/paste to other sheetunfilter.
clean it up to use for next time.
Post back your results
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Monday,
Dear Excel gurus,
I want to link my excel table which is in MS WORD as table with other MS EXCEL
file.
Can it be possible with any macros.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles.
Hi Experts
i am trying to use the logical formula ie or operator to have an
outcome such that if the figure in say cell A is greater than that of cell
B, i want it to read is higher than, if false then lesser than, this would
be achieved by selecting the year from the drop down, i have done
Nice collection ... Noorain.
Regards,
DILIPandey
On Mon, Mar 12, 2012 at 12:44 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Hi dnkndnkn,
Please find attached Ebook for VBA beginner.
On Sun, Mar 11, 2012 at 6:21 PM, dnkndnkn dnknd...@gmail.com wrote:
The syntax of VBA is different
Hello :)
I have a problem with an active selection in Excel, which I couldn't
resolve using google...
I'm writing a makro which at some point uses the
Chars.Add
Method. Now if there was a previously selected range it is automaticly
inclouded in the diagram.
How can I avoid this?
Thanks! :)
Hi team,
Need help here:
I have a Master file having 5 tabs; 1st tab is Master tab
which populated through other 4 tab's data. Source of those 4 tabs are
four differet excel file having multiple tabs in it and a specific
tab's data to be loaded in Master file's specific tab.
Thanks
Dear Experts,
I have to create 'N' number of empty files of word and note pad files, this
word will long time to do can any one help to write a macro where in which
i can create empty word files or note pad files by running the macro, my
files will be listed in excel file (please refer the
See if this simpler approach is helpful
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: hilary lomotey
Sent: Monday, March 12, 2012 10:22 AM
To: excel-macros
Subject: $$Excel-Macros$$ Logical Formula Problem
Hi Experts
i am trying to use the logical formula ie
hey Don, i didnt get the sheet can re-send it again
On Mar 9, 8:59 am, dguillett1 dguille...@gmail.com wrote:
I sent a “solved macro for this”
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Selva Loganathan
Sent: Thursday, March 08, 2012 8:31 PM
To:
Dear Lippe
Please use *charts.Add* instead of Chars.Add
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/* http://excelmacroworld.blogspot.com/
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On Mon, Mar 12, 2012 at 2:25 PM, Grzegorz Lippe
Dear Mayank,
Please share your workbook with excel-macro group.
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/* http://excelmacroworld.blogspot.com/
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On Mon, Mar 12, 2012 at 3:16 PM, Mayank
you can use paste special link function ..
On Mon, Mar 12, 2012 at 8:13 PM, chhajersand...@gmail.com wrote:
Dear Excel gurus,
I want to link my excel table which is in MS WORD as table with other MS
EXCEL file.
Can it be possible with any macros.
Sandeep Chhajer.
Sent on my BlackBerry®
Hi experts,
I have a large data in Tally 7.2,when i try to I got data in a
different format, please check the attached file Sheet 2 and make a
solution.
Thanks in advance
Rajesh Kainikkara
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor
20 matches
Mail list logo