hi copy all the content of the document and paste i t in col a of sheet 1
then run this macro
Option Compare Text
Sub test()
Dim i As Long
j = 1
For i = 1 To Range("a65356").End(xlUp).Row
If Left(Cells(i, 1).Value, 7) = "School:" Then
j = j + 1
Cells(j, 8).Value = Right(Cells(i, 1).Value, Le
do you want to change the source data or just refresh
change calculations to automatic and then click on refresh all
On Sat, Jul 23, 2011 at 10:36 PM, Ruchi B wrote:
> All,
>
> Have a excel workbook with around 15 tabs ..each of tab has multiple
> pivots referring to different sets of data.
For the second question (redim a 2d array in a for loop) my own guess:
c = 0
for r = 0 to cells.(r+1,1) = ""
MyArray(r,c) = cells(r+1,c+1).Value
c = c+1
redim preserve MyArray(r+1,c)
next r
?
--
--
Some important li
How can I attach!? Sorry -- I'm new.
On Jul 22, 11:50 pm, "Rajan_Verma" wrote:
> Attached your word document.
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Darin Kelberlau
> Sent: Saturday, July 23, 2011 9:04 AM
> To: excel-macros@googlegroups.com
It's Working Daniel ...Thanks a lot.
*Best Regards,*
*Venkat*
On Sat, Jul 23, 2011 at 8:19 PM, Daniel wrote:
> Hi,
>
> ** **
>
> Run the following macro :
>
> ** **
>
> Sub LoginLogout()
>
> Dim c As Range
>
> Range([L3], Cells(Rows.Count, "I").End(xlUp)).ClearCont
All,
Have a excel workbook with around 15 tabs ..each of tab has multiple
pivots referring to different sets of data. All the pivots refer to 4
data sets in all .What is the best way of refreshing these multiple
Pivots in different tabs at one go?
Regards,
Ruchi
--
-
Hi
The question worksheets is filled with data on 5 rows and 3 columns.
I'd like to have this data stored in an Array. For testing purpose, I
want to test if the loop is "reading" the data with an integer "tmp"
that should return the number of cells filled in with data.
Set wkb = ThisWorkbook
S
Experts,
Would one of you be so kind to advise on the subjected question?
Regards,
On Fri, Jul 22, 2011 at 2:17 AM, crazybond wrote:
> Experts,
>
> In order to unlock locked sheets/workbooks or VBA project, which program or
> codes would you suggest.
>
>
> Regards
>
> --
>
>
There is no feature in google groups to send an email to new users.
The link is available on the top of the page for new users.
Regards
Ayush Jain
On Sat, Jul 23, 2011 at 8:23 PM, XLS S wrote:
> Dear Ayush,
>
> Thanks for sharing rule's, Is it possible that read all the rules and
> regulation
Hi
Do You want this , My Maths is not so good but I think it will generate 9^9
Unique Id Number for you.
Sub ss()
For One = 1 To 9
For Two = 1 To 9
For three = 1 To 9
For Four = 1 To 9
For Five = 1 To 9
For Six = 1 To 9
*Experience required for the Job:* 2 - 4 years
*Annual Salary of the Job:* 2.0 - 3.0 Lacs
*Job Location:* Delhi/NCR
*Dear Candidate,*
Hi,
We have an urgent requirement of MIS/Sr MIS Executive at our head office at
Okhla.
Company profile: CPM India is leading organization in sales marketing which
Dear Ayush,
Thanks for sharing rule's, Is it possible that read all the rules and
regulation before join from? specially for new member
Because i am also new member...
On Sat, Jul 23, 2011 at 4:50 PM, Ayush Jain wrote:
> Hello everyone,
>
> Please adhere to below rules of the f
Hi,
Run the following macro :
Sub LoginLogout()
Dim c As Range
Range([L3], Cells(Rows.Count, "I").End(xlUp)).ClearContents
Range([A1], Cells(Rows.Count, 3).End(xlUp)).AdvancedFilter xlFilterCopy,
, [I2:K2], Unique:=True
Range([L3], Cells(Rows.Count, "I").End(xlUp)).Sort
Hi Haseeb,
I of course haven't seen every answer to every question on this forum, but your
formula solution to finding the number of groups is one of the best I've seen.
Regards - Dave.
Date: Thu, 21 Jul 2011 09:11:12 -0700
From: haseeb.avarak...@gmail.com
To: excel-macros@googlegroups.com
Subje
Hello everyone,
Please adhere to below rules of the forum. You will be banned without
warning on non compliance.
Till date 806 members are banned in group, This is the reason the group is
spam free.
*Please read and adhere to these simple rules!*
*
1. Use concise, accurate thread titles. *Your
Hi!
Reference to your profile in Job Portal, we have openings for MIS Automation
Analyst, with European Investment Bank ::: Work Location: Hyderabad.
Send your update profile to bfsi.job...@gmail.com along with following
details.
***Checklist Is Mandatory
1. Have you Read the Job Descripti
I'm trying to utilize a series of data to execute multiple Linests.
I have 10 columns of data of equal length.
The first 9 columns represent 'x-value' candidates
The 10th column represents 'y-value'
I'd like to create linests that utilize each potential unique
variation of each of the first 9 col
I have a series of columns that represent candidates 'x' values for a
regression.
I'd like to be able to create a very simple way of running linest scenarios
on each independent permutation w/o having to rearrange all of the columns a
bunch of different times.
Example:
Column A-J are the candi
*Experience required for the Job:* 2 - 4 years
*Annual Salary of the Job:* 1.0 - 6.0 Lacs
*Job Location:* Hyderabad
*Dear Candidate,*
Hi,
We have excellent oppurtunity with Global Consulting Firm for Sr Analyst
position
Looking for candidates with excellent exp in MIS reporting, Excel macros a
MS Excel MCQ Quiz
1. You can use the formula pallette to
A) format cells containing numbers
B) create and edit formula containing functions
C) enter assumptions data
D) copy a range of cells
2. When a range is selected, how can you activate the previous cell?
A) Press the Alt key
B) Pre
Thanks to All,
It really amazing..
Great
With Regards,
Akshay
On Sat, Jul 23, 2011 at 10:29 AM, Rajan_Verma wrote:
> *See the attached File..*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *ashish koul
> *Sent:* Friday,
21 matches
Mail list logo
