Where I said "e.g., Discipline" should have said "e.g., Detention."
--
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 atte
Working with Excel 2007. Attached is a sample worksheet with all of the
sample data and desired result.
I have a worksheet ("Data") that lists schools with students who have had
one or more problems:
School Student Issue
---
ABC Middle Bobby De
eWindow.SelectedSheets.Delete
> Application.DisplayAlerts = True
> Sheet1.Select
>
> For k = i + 1 To i + (Diff)
> Range("A" & k & ":C" & k).Select
> Selection.FillDown
>
I have data like so:
Country Year AgeGroup Time Count
A 05 10-6mo 10
A 05 16-12mo5
-
B 05 10-6mo 12
B 05 112-18mo 4
B 05 118-24mo 75
(I added the "-" divid
Mahesh:
This works flawlessly. Thank you so much! And I'm impressed by how you got
it done with such little code.
Can you clarify which line of code formatted the raw data into data tables
and then styled them?
I was expecting to see something like:
.ListObjects("Table1").TableStyle = ""
I
(Second attempt to attach file. ... )
Attached is a file with some sample tables. The README worksheet includes
some notes and the tasks I'm trying to automate (the main one is moving the
tables to separate worksheets, but I'd of course welcome suggestions for
any of the others).
Thanks for a
I should add that these tables are not formatted as data tables. I suspect
it would be easier to first format them as such (I need to do that at some
point anyway, so a macro for that would also be handy. Once they're
formatted as data tables, I can use the following macro to loop through
each
I have an Excel worksheet containing many tables of data. Each table is
separated by a blank row followed by a table title (which is merged across
all 6 columns). (If it's helpful I can make these titles all start with a
common word, like "Table," so "Table 1," "Table 2," etc.)
The tables all h
The objects are locked. The object lock settings on the problem PC are
identical to those on the PCs not experiencing the problem.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
A macro used to delete empty rows and assign some values on multiple
worksheets is, for some reason, also deleting all drawing objects (e.g.,
textboxes, lines, etc.) in the workbook. The problem only occurs on one PC
(the user just got 2007 installed). (When she was using 2003 the macro
worked
Outstanding! Thank you so much.
On Mar 25, 1:02 pm, ashish koul wrote:
> check this
>
> have create a macro to add quarters also one to hide the value of
> individual quarters so you don need to delete anything
>
>
>
> On Fri, Mar 25, 2011 at 7:58 PM, 0 1 wrote:
> &
y
suggestions on how to simply manually drag a base formula and have it
transform accordingly.
Thank you.
On Mar 24, 8:37 pm, ashish koul wrote:
> can you attach the sample data and headers you are using
>
>
>
> On Fri, Mar 25, 2011 at 1:53 AM, 0 1 wrote:
> > I have a spread
I have a spreadsheet with States as rows. For each State, there are 4
columns of data for Year 1, then 4 more columns of data for Year 2,
and so on. Each column represents a quarter for that year.
For example:
Column A lists the State
---
Column B data for 1st quarter, 2000
Column C data for 2nd
That did the trick, Paul. Thank you.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.c
I have a macro that deletes rows in a dynamic range if certain data
are missing. When this happens, the range obviously has no rows. I''m
trying to write a macro to determine when this has happened.
Basically:
IF the range has no rows THEN
MsgBox "Range has no rows"
ELSE
MsgBox "Range has r
I love it when simple code works so well. Thank you!
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http:
Using two separate if-then statements did the trick. But now I have a
related problem.
I'm trying to reverse the code in order to *close* the sheets, if they
are open. I figured I could use the same code for the Function
WorkbookOpen ..., but a new subroutine for closing them:
Public Sub CloseSou
With File3.xls open, I'd like to run a macro that checks if File1.xls
and File2.xls are open. If either or both are not open, then open
them. The code below evaluates only the first file (File1.xls), and
never proceeds to the next step (i.e., it never checks for File2.xls).
Any idea what I need to
With File3.xls open, I'd like to run a macro that checks if File1.xls
and File2.xls are open. If either or both are not open, then open
them. The code below evaluates only the first file (File1.xls), and
never proceeds to the next step (i.e., it never checks for File2.xls).
Any idea what I need to
Thank you everyone. This did the trick:
In B1
=INDIRECT("A"&COLUMN(A1))
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Li
The source document (sample.xls) contains these data:
A
1
2
3
4
In my destination workbook, I would like to put a reference in A1 so
when I copy the formula into B1, C1, etc., I get this:
A 1 2 3 etc.
Instead I get:
A 0 0 0 etc.
I've tried every variation of =sample.xls!$A$1 and none of
I need this to be automated (i.e., with a formula or macro), and it
needs to handle the fact that the source data is part of a dynamic
range and will often change. But I used your transpose idea and came
up with this macro, which does the job:
Sheets("Sheet1").Range("MyRange").Copy
Sheets("Sheet4"
I'm trying to create a dynamic range to identify the rows in Column C
that have the text "Hello" in the corresponding row in column B.
For example:
B C
8 ABC 3
9 EFG 5
10 XYZ 12
11 Hello 16
12 Hello 17
13 Hello 23
In this example, the dynamic range needs to select C11:C13 (i.e., the
cells co
In Sheet1, I have a dynamic range ("MyRange") that spans several rows
in one column.
I'd like to copy the values in each row into columns in Sheet4.
For example, in Sheet1 MyRange has these values:
A
--
2
4
7
10
In Sheet4, I'd like to return:
A B C D
-- -- -- --
2 4 7 10
I suspect ei
"Most Recent"
> End If
> FindTrend = TrendFlag
> End Function
> '
>
> then, in an adjacent cell, use the formula:
>
> =findtrend(A1:E1)
>
> (assuming the values are in A1:E1)
>
&g
I'm trying to return a value (1,2,or3) based on the percent change in
values since a max value. For example, assume cells A1:E1 contain
these values:
200,300,200,50,150.
The values represent the number of widgets produced in year 1, year 2,
up to year 5.
The max value for this example is 300.
T
26 matches
Mail list logo
