Integrating Excel spreadsheets into Word format

suekim77

New Member
Joined
Nov 5, 2004
Messages
14
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?
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

dcardno

Well-known Member
Joined
Nov 20, 2002
Messages
534
Office Version
  1. 2013
Platform
  1. Windows
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

New Member
Joined
Nov 5, 2004
Messages
14
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

New Member
Joined
Nov 5, 2004
Messages
14
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,111,598
Messages
5,541,163
Members
410,543
Latest member
ExcelGlenn
Top