Hi ,
chk if this works for u
Sub test()
On Error Resume Next
Application.DisplayAlerts = False
Criteria = No Sales
For i = 1 To Sheets.Count
Sheets(i).Select
cellf = Cells.Find(what:=Criteria, after:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows,
hi venkat
find the solution sheet attached...
On Wed, May 27, 2009 at 8:04 PM, Norman May nor...@gmail.com wrote:
Paste the following formula on sheet 2 cell B5:
=SUMPRODUCT((Sheet1!$C$5:$C$5)*(Sheet1!$B$5:$B$5=A5))
Norman
On Wed, May 27, 2009 at 7:47 AM, venkat sudhakar
hi dave,
can the user open both the workbooks(company names and workbook with
company name) together or you want to keep company name workbook closed ?
On Thu, May 28, 2009 at 8:32 AM, Aindril De aind...@gmail.com wrote:
Hi Dave,
I guess this will help you.
I made a couple of assumptions for test purposes.
I put a sheet called Company Names in the current sheet and populated it
with ID and Company Names.
If you put it in another workbook, just change the Thisworkbook.Name to the
appropriate name (and the sheet name Company Names to the appropriate
I am using Excel 2007 and have built a workbook that uses a lot of VBA
in the background. My problem centers around forcing the user to enable
macros.
Our security folks have set up rules on the use of macros which only
allows the user to enable the macros. I researched the use a digital
I'm not sure if this will work.
Try replacing the + with
Norman
On Thu, May 28, 2009 at 10:19 AM, Ahmet Yalcin ahmetyalc...@gmail.comwrote:
Hello,
Please help me with the right syntax writing the below
ActiveCell.FormulaR1C1 = ='[2008-04 BIL.xls]+Company(x)'!D7 line. I wish
to insert the
you're trying to insert the sheet name???
I assume the . . . is including code that is selecting a different cell.
so the ActiveCell for loop x = 1 is different than the Active Cell when x = 3.
try recording a macro.
Also, keep in mind that when you declare an array,
the indexes start at 0, not
Hi Paul,
I think the op means that the text NO SALES can be in any cell somewhere on
the sheet - sheet name unknown, and not a sheet called NO SALES.
Hence his desire to look thru every cell on every sheet. (Cells.Select -
Selection.Find)
And that's a good tip about counting backwards. I've
Thank you for your macro. I sat down and had to revise my original
post. So here goes one more time, please I am just starting to code
these macros and its hard to describe a situation. So here is the
revised question below.
I have a spreadsheet called COMPINFO that has tabs for the 12 months
Where exactly is this HTML file coming from?
Is it an actual file or are you trying to get data from a webpage/
site?
On May 27, 9:39 am, joker197cinque joker197cin...@gmail.com wrote:
I'm trying to import into a sheet an HTML table.
The problem is that parsing html string is not so easy ..
Hello Paul,
Thank you. What I am trying is to gather data from same address on many
sheets in my workbook. The name of the file is 2008-04 BIL.xls and within I
have sheets called KM, KS and KD (of course this is just a representative
picture of a larger project). Can you kindly suggest what I
11 matches
Mail list logo