"rsp" wrote:

> We order 7 column buff ledger pads at our office. I have a worksheet that I

> have to handwrite on this paper every year and I was wondering if there is

> any way to make a 7 column ledger worksheet in excel. I can't find anything

> in the templates.

Yes, yes yes

Enter Column heading and some data on the next row and add a few simple

formulas to perfprm calculations.

Peter

- How do I make a particular column required in Excel?
- How do I make a line-column 2-axis chart in Excel 2007?
- Combine / sum sheets and make a summary into another sheet
- Make a new column from specific cells of one column
- How to make a multi-column label?
- How do I make a stacked column chart with side-by-side comparison.
- Making a list with information from two columns on another sheet
- Making a new column based on data in an existing column
- How to make a column with the same # repeating 3x?
- Copying every 4 row to a new column on a new sheet?
- Make a code independent of sheet name
- How do I make a particular column required in Excel?
- Returning values in sheet 2 with a matching column in sheet 1
- Make a cell value in one sheet equal to another cell in a different sheet...
- Make a column/row read only
- How do i make a monthly expense spread sheet
- How do I make a particular column required in Excel?
- Making a username from data in two different columns
- Problem Formatting Data to Properly make a Stacked Column Chart
- Consolidating column values in a new column to remove blanks.
- Making a second column from data in first column
- Make hyperlinks follow the copied sheet, not the original
- Making Special "Stacked Column" Chart
- Making a One Column Directory from Two Columns

and we're trying to make it so that if they do not fill in a particular

column entitled "Project," they will get an error message or will be unable

to sum their final expenses together.

Is there a way to make a single column required in an Excel sheet so that

not filling in this cell would block any more entries or would block a final

reimbursement number?

Thank you in advance for any help or advice!

Used to be one of the "Special" or "Custom" chart type selections in Excel 2003 and earlier. Help!

how do i combine / sum sheets and make a summary into another sheet. taking the DESC as the point reference to achieve the output?

excel.jpg

Thank you. any help will be appreciated.

I am having a hard time finding a way to do something so I thought I asked for some help.

So, I need to make a new column that would contain every fourth cell of one column starting from. So, for example, B1 would contain A1, B2 Would contain A4, B3 would contain A8 and so on...

I hope I explained it well enough

Thanks in advance

clustered column, able to compare 2 items next to each other. Any thoughts?

Is there any way I could then use the two columns on different sheets and make a list in another sheet, with the names in Column A, and the amounts on Column B, while keeping in mind that I am constantly adding new names and entries into the original sheets, so they would have to automatically update?

Any help would be appreciated. Thank you so much in advance.

I have a very large worksheet. Each row is a date from 1/1/1900 through the

present. I have about 600 columns.

What I need to do now is take a certain exisiting column, and then create a

new column based on the data in the old column. The old column has either a

1 or a -1 or a 2 in certain cells, based on various criteria. The new column

must look at the old one, and find the 1, or -1, or 2 and then count down

five rows, and put in a 1. (All dates are not necessarily in. most weekends

and holidays are missing, so I wouldn't really need something based on dates,

simply to count down five rows, and put in the 1) To make this easier, I

would copy the column to a different worksheet, and work with it there and

then insert the new column where I need it. Also, I can also take the

original copied column, and change the 1, or -1 or 2 all to the same thing,

in order to make the new column. I have to find cells that are not blank, and

then based on that, put in the 1 in the new column. Also, not always do I

need five rows down, sometimes I would need 3, or two or 10 or 30, etc.

Sample:

Date: old column new column should end up with:

1/2/1900 1

1/3/1900 1

1/6/1900

1/7/1900 1

1/8/1900 1

1/9/1900 1

1/10/1900 1 1

1/11/1900

1/12/1900 1

1/13/1900 1

1/14/1900

1/17/1900 1

--

newyorkjoy

thanks for the help!

I'm so glad I found this forum. I am trying to work on an experiment for my lab and am trying to figure out how to do the following:

I have one column with 89 cells. In that column each cell has one number, 0 through 7 such as.... 7,2,6,3,4,4,2,0,2,3,4, etc, etc.

What I need to do is make a new column which has every number n1,n2,n3,etc repeated three times such as n1,n1,n1,n2,n2,n2,n3,n3,n3 etc...

Keeping the order of the list is important but I just need to have it tripled...

Any ideas? I am using Excel 2007.

Thank you in advance!

eg.

Sheet 1, values in;

A1

A4

A7

A10 etc

Copy to Sheet 2

A1

A2

A3

A4 etc

I am looking for a formula to be able to put on Sheet 2, A1 (or other) and drag down the page.

Thanking you in anticipation.

I got the solution as

"Use Sheet Code names:

These can be seen in the "Project Explorer" (Ctr+R).

Get into this habit as the Code name never changes, even if

the sheet is renamed or moved within the workbook."

But I could not make out how to do this.

Can anybody help me?

Many thanks in advance.

so that if employees do not fill in one particular column entitled

"Projects," they will get an error or will be unable to have a final sum

filled in.

Is there any way I can make this particular column required so that if it is

not filled in, the chart will not complete properly?

Thank you in advance for any advice or help!

I am trying to bring over hours worked data from a large report style sheet with multiple groups of information into a more personal sheet for the purpose of creating metrics. The hours information have job codes attached.

The sheets have the format:

Personal sheet that contains the codes and other columns for pulling the hours worked. The codes are in one column:

|Codes|

101

102

103

104

Database sheet has multiple columns, with the codes being one, and the total hours being another. The codes aren't in any order in the database sheet.

|data|data|data|codes|data|data|total hours|

x | x | x| 104 | x | x | 5 |

x | x | x| 207 | x | x | 1 |

x | x | x| 141 | x | x | 10 |

x | x | x| 101 | x | x | 2 |

I want to have the personal sheet match the codes from the database code column, then pull the total hours from that row over to the personal sheet for each corresponding code.

Thanks, and if anything needs clarification please ask.

Chris

How do i make a cell in one sheet equal to a cell in another?

ive tried:

=(and then clicked on the other sheet's cell) then enter

all i get is VALUE?

i dont want it to be a macro, just a simple forumla/function like that...i cant remember how to do it

Thnx

Mayhs

Can someone help me in making a particular column or "n"number of columns/rows read only in a worksheet.

Regards,

Lavina

the business recipts and put them on a spread sheet with detail.

so that if employees do not fill in one particular column entitled

"Projects," they will get an error or will be unable to have a final sum

filled in.

Is there any way I can make this particular column required so that if it is

not filled in, the chart will not complete properly?

Thank you in advance for any advice or help--I'm a bit of a novice to this!

one with first name

second with last name.

i want to make a third column to display first letter of first name and entire last name....

Tim Wilson twilson

any ideas?

Hugh

My problem involves trying to make a chart out of two different sets of data.

Each series is a section of data that basically acts as a length, and I was hoping to generate a stacked column with all the series adjact to each other vertically. The stacked chart in Excel works fine for this.

The problem arises when I want to add another column to compare side by side with the first. Excel wants to make the second column relatable to the first column but I want the series to be independ of each other.

Basically 2 independent columns with series that are related, but not related between columns.

Does anyone know the best way to format the data in Excel so I can make this chart properly?

I attached my workbook with the data. Please and thank you some much forum members!

Excel_Forum_blosoya_help.xls

19.6

__

__

__

308.9

__

__

__

__

__

257.8

to

1

2

3

etc..

I want to take every other value (the even numbered rows) and move them to a

second column next to the date. Of course I'll end up with a blank every

other row, so I'll then want to "collapse" the columns to eliminate the

blanks.

Any easy way to do this as I have several thousand pieces of data.

Thanks in advance.,

Stephen

but named differently. I want to make one sheet, with all its hyperlinks to

different parts of the document, and then just make a copy of that sheet and

rename. But what I really want is, the hyperlinks in the copied sheet (after

renaming) to stay with that sheet, and not jump back to the original sheet.

i.e. sheet 1's hyperlinks stay in sheet 1, but sheet 2's hyperlinks jump

within sheet 2, not back to sheet 1 where they were copied from. There must

be a way to do this, and save me a lot of work. The finshed book will contain

about 100 sheets, with about 50 hyperlinks per sheet. To do this manually

will take forever.

Thanks in advance for taking the time to read this, hope you can help me.

Regards

Paul

two categories that make up income (regular and vision) and one expense

category. I want to make a stacked column with regular and vision income and

another column next to it with only expense. How would I accomplish this?

Thanks for the help.

I have a 2 column list of chapter members' names in one column and their

schools inthe other. There are over 1800 entries.

I want to end up with a single column sorted by the schools, with the name

of the school in a row, followed below by the names of the graduates in

separate rows. then the next school, etc.

Like

Emery-Riddle University

Jones, Frank

Smith, Fred

Franklin University

Adams, Susan

Baker, Sam

Is there a formula that can do this or do I have some (a lot) manual

formatting to do?

Thanks,

Dennis

No luck finding an answer? You could always try Google.