Integrating Excel spreadsheets into Word format

[suekim77]

Hi everyone,

I have an excel spreadsheet that is a price list.
Column A
Item #

Column B
Item Description

column C
Quantity

Column D
Price

There are about 50 items. To create a proposal, I go down column C and mark a "1" next to the items I want on the proposal.

Now, the easiest thing to do is just copy and paste the rows I need into Word for the proposal.

However, my boss wants me to find out more about the lookup function, and see if it applies to automating a proposal somehow.

I've played around with the idea of creating the proposals in Excel and formatting them to look like Word documents when they're printed out.

So, is it possible, that excel (or word) can pick out only the rows that have quantities greater than or equal to 1 and return them on the new spreadsheet (or new document) in the order that they've been picked?

 

[dcardno]

You could do an autofilter on Column C with the "1s" and blanks and filter for only cells with a "1" - that will give you just the required rows, although all the rows with a blank will still be there, just hidden. If you select all of the rows that are shown then click "Edit | Go to | Special..." Excel will bring up a dialogue box - chose "Visible cells only" (on the right, about 2/3rds of the way down) and click "okay." You will be left with only the visible (ie - a "1" in Column C) rows - you can then copy and paste them directly into Word, or into another spreadsheet.

 

[suekim77]

Not copy and paste

Hi,
Thanks for your reply, but I already do the copy and paste route, I'm actually looking for a solution using Lookup, if it's possible. The idea is to use as little keystrokes as possible to get from Excel price list to Word proposal.
Thanks!

 

[suekim77]

Not copy and paste

Hi,
Thanks for your reply, but I already do the copy and paste route, I'm actually looking for a solution using Lookup, if it's possible. The idea is to use as little keystrokes as possible to get from Excel price list to Word proposal.
Thanks!