0
votes
2answers
19 views

Make excel relate to different values [closed]

I have an excel-file with 3 spreadsheets. On page two and three I have a huge list of IP addresses which all relate to a specific name which can be found on both page two and three. I want to type in ...
0
votes
1answer
21 views

Compile Excel Spreadsheet from Outlook Message

I would like to know if it is possible to compile an Excel Spreadsheet from an email message. I receive several email messages every day with the same format (the report of a procedure) and I would ...
0
votes
0answers
30 views

How to hide/unhide sheets by hiding/unhiding the sheet name in an index of sheet names?

I have an index of all sheet names in a workbook. I want to be able to hide/unhide sheets by hiding/unhiding the sheet names in the index. Has anyone any suggestions for a vba code?
0
votes
3answers
1k views

For Excel how do I create a field that automatically generates a sequential number

How do I create a field that automatically generates a unique number when I enter a new record in a table ? I have a list of numbers in the B column. I want the numbers in column A to automatically ...
1
vote
1answer
45 views

Trying to move data from csv to a template

I have this time-sheet app that can output a csv file (with my check-in and out with project name and comments) that I would like to copy come row into the template used at my job. For example, the ...
0
votes
1answer
1k views

How to change default text color in MS Excel

How can I make many edits to a MS Excel 2010 spreadsheet and save the edits I make using a different color (i.e. RED). Right now, I have to change the color of each and every cell in the spreadsheet, ...
1
vote
1answer
66 views

Automatic Excel Script

I am a 6th year medical student and I'm working on my thesis. I have no experience with programming whatsoever, a friend recommended me to post my question here. I am strugling with the following ...
2
votes
2answers
387 views

Modify value of a cell using the old value as part of the new one?

I have a table in which row 2 has tons of columns. Each of those columns in row 2 has a varying value in the range of 1-1000000 represented by X in the example below. How can I add modify the cells ...
1
vote
1answer
269 views

Excel - Create the same Charts Monthly

I've got a workbook with a table that has the months across the top. Each month, another month column will be added and the data for that month will be filled in. For each month, I want to create ...
1
vote
2answers
895 views

Automating data from an Excel file and interacting with browser

How can I automate copying records from an Excel file or CSV and interacting with a browser? Example Task: Extract or Copy record(s) from an Excel file row Go to a URL (probably using Google ...
1
vote
1answer
435 views

Finding matching columns in excel

I've never used excel before so I need the simplest solution available, and this is a work assignment due this week so I didn't have time read much of the documentation. Basically, I have two ...
0
votes
1answer
131 views

Excel: Adding and Searching Replacing in Bulk from Many Sheets

I've got a 650 sheet Excel document. I need to do some bulk additions to each of the sheets. Are there ways to say add a bit of text to a specific row/column pair (A4), bulk search and replace, etc?
5
votes
2answers
999 views

How to sum cells depending on the content of a neighbor cell

I have an Excel document with the following columns; Date | Reference | Amount 23/01/11 | 111111111 | £20.00 25/09/11 | 222222222 | £30.00 11/11/11 | 111111111 | ...
1
vote
2answers
93 views

How can I merge two lists of emails to get rid of duplicates without any programming?

Say that I have two lists of emails, that look something like foo@example.com, john@doe.com, boo@boo.com boo@boo.com, jane@bigcorp.com and I need to put them together into one big list while ...
2
votes
2answers
6k views

How can I print Excel spreadsheet files automatically?

My company has computer-generated reports that come out as Excel spreadsheets which are emailed to the Billing Department. They would like these reports to be automatically printed as they are ...
4
votes
2answers
975 views

Excel 2007 save import steps on csv file?

I have a csv file that constantly needs opened into Excel and then have the data copied over to a separate workbook. I find the process of having to click through all of the dialogs, setting the text ...
1
vote
1answer
4k views

How to conditionally highlight cells in OpenOffice Calc?

I have a big chunk of data in an OpenOffice spreadsheet. To make real information standout more, I would like cells with an absolute value over a certain threshold to be highlighted in red. Is there ...
3
votes
3answers
12k views

How do you update an Excel file (Data Refresh and update formulas) WITHOUT opening the file?

I have an Excel file that want to update and save automatically with out having to open it or manually interact with. Manually, I open the file up and hit data refresh which goes and does a SQL query ...
0
votes
2answers
3k views

How to have sequential numbers keep writing themselves?

At work, we use Microsoft Office 2003, and we have to write many numbers that are sequential, e.g. 2590, 2591, 2592, etc. These numbers are either in Excel or in a Word table. How can I ...
2
votes
3answers
4k views

Automate Excel Text Import Wizard?

I receive files on occasion in a fixed width format. I need to import them into Excel but Excel doesn't perfectly pick up the columns. I can do it manually each time with the Text Import Wizard, but ...
1
vote
1answer
384 views

Creating 1 spreadsheet per row with MS Project

I'd like to create a script that creates a set of spreadsheets, 1 for each selected row in an MS project schedule. This is more complex that what I've seen the "export function" do, since the export ...
0
votes
1answer
51 views

Script for preriodic emailing to a list of addresses from an Excel/Access DB?

I'm looking for a program/script, better if it's OpenSource/Free, that can periodically send an email to a list of addresses that are in an Excel File or Access DB. I know I could hack something ...