Convert Large Spreadsheet Tp Pdf For Printing?

Jul 10, 2013

I need to be able to convert a large spreadsheet to pdf for sending to a commercial printer. The spreadsheet is a family tree and covers an area a1 to ca107. The printers normally do the conversion from an emailed copy of the .xls file but charge for this.

Printing will be done on a wide carriage printer so the pdf has to be one sheet not a large number of a4. I have a copy of Acrobat but cannot work out how to get the spreadsheet to save as one sheet.

View 7 Replies


Convert Large Number Of Row Data Into Columns For Easy Printing

Mar 1, 2014

i was stuck with some mass data which spans over many rows and columns. i am relatively new to excel and wanted to know how i can get this data arranged in a way where i can access all the data from a printable view. i have attached a file explaining basically what i want.

View 5 Replies View Related

Convert Column Headings To Cell Value In Large Spreadsheet

Mar 12, 2014

I have a very large spreadsheet that is a consolidation of approximately 105 separate of contacts lists. The new consolidated spreadsheet contains demographic data, and a column for the name of each of the 105 lists. Each contact in the consolidated list had an "X" placed in the column if they were a member of that particular list. Each contact can be in more than one list. This is not very useful for me.

Here's a visual representation of the current list along with what I need:


[Code] .....

I would like to add a column to the spreadsheet and call it "Source"

And then have a macro or VB script to do the following:

1. As shown above, put the column name (ie "List2") in the "Source" column whenever there is an "X" in that row for the corresponding Column.
2. Because each contact can be in more than one list, I need to append the column names so that "Source" column contains all of the column names (Lists) that had an "X"
3. Once all of the list names have been added to the "Source" column, I will delete the list columns.

View 1 Replies View Related

Link The Numbers In The Form To Separate Parts Of A Large Printing Macro?

Jan 12, 2007

I have set up a form where the user can enter the number of copies they want for 10 items (I will call them item1, item2 etc for ease)

Is it possible to then link the numbers in the form to separate parts of a large printing Macro?

View 9 Replies View Related

Printing Spreadsheet On 11 X 17 Paper?

May 7, 2004

how to choose 11 x 17 paper as my paper size option. They don't want it on anything but this size.

View 8 Replies View Related

Restrict Saving And Printing Spreadsheet

May 2, 2014

I need to restrict printing & saving functionality on a excel spreadsheet that is shared with a large group of people.

I was also hoping for the restricting save part, to do an AD lookup to see if they are a member of group "X", if they are then allow the save, if they are not then deny the save.

View 1 Replies View Related

Printing Each Spreadsheet Row On A Separate Page

Mar 29, 2007

I am trying to take a spreadsheet and have each row print on a seperate page - without having to do the print area thing on each row. Is there a way to automate this process?

View 2 Replies View Related

Extract Data From Large Spreadsheet?

May 29, 2014

I have a very large spreadsheet that was exported from an ecommerce site with close to 1000 products. I have one column that I need to extract some text from. This column holds all of the html from the product description and is huge. I only need to extract the actual description of the product, but am having a very hard time figuring out how to do it. I've tried using the mid, left, and right function; but not all of the html is the same so it's not really working the way I need it to.

I have multiple tags throughout the html that I can use with the mid function, but there is more than one occurrence of them. So, how can I tell it to start at the 4th occurrence? I've spent countless hours searching, but I'm a complete novice when it comes to excel and I don't even know what to search for. I end up looking through sites that explain how to pull the Y out of XYZ, which is what I need, just on a much larger (and more complicated) scale.

It was suggested that I set up a macro that will find the 4th occurrence of the word, and then uses the mid function to pull the data out, but when I try to find the word, it says it doesn't exist even though I can see it right in front of me.

View 10 Replies View Related

Delete Every Nth Column From A Very Large Spreadsheet

Mar 12, 2009

I have created a sample spreadsheet (the real data is sensitive) but I am basically faced with a spreadsheet of many columns of which I would like to remove the 4th,5th, 8th,9th, 12th, 13th etc...

So every 3rd column starting from Column B, and also every 3rd starting from Column C, (every 3rd, and every 3rd + 1 starting from B?), it's obvious what I'm after from the spreadsheet I've provided.

Unfortunately manually isn't an option, this needs doing every week, and it goes all the way across to column HZ!

View 2 Replies View Related

Macro To Move Around Large Spreadsheet....

Jan 6, 2010

Need the code to put into a command button which jumps from the cell selected, X number of cells to the right. Also will need the code to jump back again when clicking on a different command button.

View 5 Replies View Related

Large Spreadsheet - Capitalize All Text

Mar 1, 2002

I generated a large spreadsheet and now for legal reasons all the data has to be in Upper case. Is there a quick way to convert all the text.

View 6 Replies View Related

Large Spreadsheet With Conditional Formatting

Apr 3, 2009

I have multiple large spreadsheets of questionnaire data. Responses are as %'s
What I would like to do is use conditional formatting to pick out the top 3 of each set of questions per column not including 0% (if it falls in the top 3). Using different shades of green in the cell background and a white font.


The spreadsheets are up to 3000 rows long and up to column BB wide. The sets of questions are of random length spaced by an empty row. So question 1 may have 11 parts to it, each taking up a row so 12 rows in total. Question 2 may have 5 parts taking up row each so 6 rows in total...............Question 80 may have 7 parts so 8 rows in total and on and on.

What I have been doing is working down the first column of responses and manually adding the conditional formatting. Then using the format painter to copy across the relevant rows and columns. For example if Question one was from c5:bb26 I would format c$5:c$26 with the top three then use format painter to drag across to bb5:bb26 ...

View 9 Replies View Related

Printing Spreadsheet Results To A Text File

Jun 21, 2009

What I want to be able to do now though, is somehow, when someone sends the document back to me, create an FTP queue. I can do this with BulletProof FTP, because it allows really simple text queues. So, what I need excel to do is, when someone has finished selecting their files, is write the results to a text file like exactly like this (without the Line1:, etc.):

Line1: <text from D2>
Line2: 0
Line3: 0
Line4: 0
Line5: ?
Line6: <text from E2>

(then repeated for each row in the excel document until column A is returning blank)

View 5 Replies View Related

Convert Text To Number - Large Database

Aug 30, 2009

The format of the numbers are:


I have 2000+ numbers is coloumn B.

There are a lot of sets of numbers that are still text! It's highly annoying and I need to analyze the data in Access.

I tried the paste special advice and the 3 ways microsoft suggests. I have a feeling its not working because of the required format that I need.

I need to do this project tonight!

Background: these are imported numbers, I had to combine other excel databases... By the way, is their an easier way to combine excel sheets into 1?

View 12 Replies View Related

Choose Columns To View In A Large Spreadsheet

Oct 3, 2008

I have a large spreadsheet with over 50 columns. Many colleagues use the sheet and often use the format, hide, column function to hide columns they do not need but then the next user has to unhide them and re-hide others until they are left with the different columns they require.

Is there anyway of creating a menu which allows users to select from a list of all the columns those they wish to display, all the others therefore being hidden.

View 5 Replies View Related

Excel 2010 :: Setting Up A Large Spreadsheet?

Mar 2, 2013

I'm have Excel 2010 and Windows XP. Each week I get 3 spreadsheets and each has data unique to it. Each spreadsheet has a week number column which is common to all three. I want to combine the three worksheets into one and make create several dynamic charts for management. How should I organize a large spreadsheet? In addition to my week number I have a host of other date fields. Some of the data I get is (1) vehicle VIN numbers (2) City/State/Country (3a) I break up the VIN to give me vehicle type (3b) year of assembly (3c) car type (3d) number of doors (4) mileage (5) complaint (7) defect code etc. etc. What are the do's and don't when setting up a large spreadsheet? I have data by week which goes back to 2006 and so my date fields go top-down. I inherited the three spreadsheets and would like everything under one roof, so to speak. One spreadsheet which I can make my charts.

View 1 Replies View Related

Creating Spreadsheet With Large Amount Of Data?

Nov 11, 2013

I am creating a spread sheet with a large amount of data.

In column a I have a list of managers, in B I have a list of employees and C, I have a list of activities that have been recorded throughout the day.

What I want to do is create a list (on a new sheet) so in column A that would bring back all the managers. Then in column B, bring back the employee that is tied to the manager from column A and finally in column C, bring back the activity that is tied to the employee.

I know how I can do this by doing list validation with INDIRECT, but with the large amount of data that I have this would take forever in a day.

Is there an easier and quicker way to do this?

View 1 Replies View Related

Extracting Specific Data From Large Spreadsheet

May 22, 2014

I have a large spreadsheet which contains multiple rows of rate data by employee. I have sorted by effective date with most recent date on the top to get the most recent rate of pay, however, is there a way or formula to be able to identify or extract the previous rate of pay after that? I have included a sample below. There are different #'s of rows of rate of pay based on how long someone has been in company, as well as different rates of pay and effective dates.

Employee #
Rate of Pay
Eff Date

John Smith
$ 99,000.00

[Code] ..........

View 3 Replies View Related

Select Columns To View In Large Spreadsheet

Oct 3, 2008

I have a large spreadsheet with over 50 columns but usually only need to view a small selection of them. Many colleagues use the sheet and often use the format, hide, column function to hide columns they do not need but then the next user has to unhide them and re-hide others until they are left with the different columns they require.

Is there anyway of creating a menu which allows users to select from a list of all the columns those they wish to display, all the others therefore being hidden.

View 9 Replies View Related

Importing Information To A Pre-made Form From A Large Spreadsheet

Jun 19, 2007

I have a large spreadsheet (1000-plus entries) that all have about 10 or 15 columns of information (product title, product number, etc).

I also made a form that I want to use as a master form, where all the titles will not change.

What I am wanting to do is, by going off the product number, when you click it, this pre-made master form will pop up, and all the information that was located on the large spreadsheet for this product number will be inserted where it is designated to be on the master form.

While I could probably do something like this through Access, we need to keep it on Excel, and in the same workbook so that it will automatically update things once I put a new number or input onto the large spreadsheet.

View 12 Replies View Related

Excel 2010 :: Extracting Data From Large Spreadsheet

Jan 31, 2014

I work with Excel 2010 and have a very large spreadsheet with data that I need to manipulate in several different ways. I have been filtering and then cutting and pasting but this is very time consuming . Is there a way to extract specific data from the spreadsheet and transfer it to different worksheets? I don't really know how to use macros.

[URL] .....

View 14 Replies View Related

Vba To Parse Large Spreadsheet And Only Keep The Most Recent Occurrence Column B

Feb 27, 2014

i have some large reports that i get each day and have to sort into date time order and only keep the newest occurance based on column 2

at the moment i have a vba that converts the list to space delimetd columns, then selects all sorts into date time order, then deletes dupliactes as of column 2 keeping the most recent,

is there a more efficient way just to keep the most recent occurance and removing the rest

example file. so the 2nd row would be what i am left with

0 zztimrdevappg01 tbbzz02/26/201419:04:30
3 zztimrdevappg01 tbbb bb02/27/201402:04:31
8 zztimrdevappg01 hhbbzz02/26/201419:04:32
0 zztimrdevappg01 hhbbbb02/26/201419:04:34

View 5 Replies View Related

Excel 2007 :: Locate A Chart In Large Spreadsheet?

Nov 16, 2011

I have inherited a series of Word reports containing links to charts in several Excel files. I can tell by the link in Word that one of the charts is named 'Chart 6'. Is there an easy way to locate which chart in the Excel file is 'Chart 6' (and on and on for all of the other charts linked in the Word doc)? There are upwards of 21 charts in each Excel file linked to each of the Word reports. I am using 2007 but the files are in 2003 format because of limitations of the program from which the data comes for the charts.

View 4 Replies View Related

Large Order Spreadsheet With 3 Date Related Columns

May 15, 2007

I have a large order spreadsheet with 3 date related columns. One for customer requested delivery date, one for factory quoted delivery date and one for actual delivery date.

I want to be able to set something up that if it gets near either the requested or quoted delivery date (by say a week), that the cell flags red so it's a visual reminder to check whether the order has been dispatched etc.

View 9 Replies View Related

Excel 2007 :: Make Column Headings Appear On Large Spreadsheet?

Sep 7, 2012

How do I make the column headings appear when I'm working on a large spread sheet so I don't have to scroll to the top each time to see where I am. This is on Excel 2007.

View 5 Replies View Related

Split Data From A Large Spreadsheet By Selected Column Into Multiple Workbooks

Aug 25, 2009

I have a large spreadsheet which I need to split into individual workbooks by reference to a particular column.

Rather then doing this manually and splitting the data out one at a time - I would like a macro to do this for me.

I am a novice excel user.

View 9 Replies View Related

Convert Each Row In Spreadsheet Into TXT Or XML File?

Nov 18, 2011

I have a spreadsheet with thousands of lines of code. Each row contains a complete code that needs to either be converted/pasted to a new .txt or .xml. Until now, just copying and pasting each line into a .txt file was necessary but there has to be a way to automate this. I would love to know if it's possible to extract each row(technically it is only a single cell per row, so its just a really large single cell) and add it to a .txt or .xml file?

View 12 Replies View Related

Convert Pdf File To Spreadsheet

Feb 23, 2007

Someone sent me a pdf file. It contains a list of items but the problem is I need to be able to copy and paste each item individually. I tried doing a google search to find a way to convert the PDF to a word doc but did not have any luck. So I think my only other alternative is to convert it to an excel (XLS) file.

Does anyone know of a way to do this so that I can successfully copy and paste words from the document individually and not just wind up with an excel file with a picture of the PDF file in it?

View 3 Replies View Related

Convert A Complex Excel Spreadsheet To Web App?

Sep 16, 2013

to convert a complex Excel file to a Web App (usable in the browser of a iPad) which has 15 sheets and some input.I tried every javascript/jquery library, tried to hire a freelance, asked for a quote everywhere, tried add-ins, etc. Nothing seems to work. Manually, well, it is pretty impossible within 2 days.

View 3 Replies View Related

Convert Excel Spreadsheet To HTML?

Aug 24, 2013

I am looking for a macro that can export excel spreadsheet data to html. I found one that looks perfect for my needs on another site, however it will not work. I have tried to contact the site's owner, but his site does not seem to be contactable any longer. I thought I would try to post my problem here. The script gives me runtime error '76' and debug highlights the following lines:

Open pagename For Output As fnPrint #fn, top$;Print #fn, body$;

Original script is as follows:

' Here are some values you can set to suit yourself
' Any file names that are blank -- i.e. "" -- will not be used
' and will not adversely affect the appearance of your page
Const html_title = "Interesting Web Sites" ' appears here
Const page_title = "Some of my favorite 'places' ..." ' shows on page


View 1 Replies View Related

Copyrights 2005-15, All rights reserved