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?
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

dcardno

Well-known Member
Joined
Nov 20, 2002
Messages
544
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!
 

Forum statistics

Threads
1,141,167
Messages
5,704,674
Members
421,360
Latest member
AJPlant

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top