Spreadsheet

How do you combine 12 months of spreadsheet data into one report for the year in lotus 123 release 9?

I have a spreadsheet with two separate sheets. I need to import the colored value from a range of sheet to the column C of Sheet 2. In short, something like, If Sheet1!A4=Sheet2!A3, Sheet2!C3=The colored value of the range Sheet1!(C7:AG7) and If Sheet1!A10=Sheet2!A4, Sheet2!C4=The colored...

Hello everyone, I have an openoffice spreadsheet in which I have some data in data 1-workbook which I want to find out from data2- workbook which has more rows and columns Sample file linksample Let say I want to search SNo.1 of data-1 in data 2 and auto-paste data found in data 2 to data...

Hello everyone, I have an excel spreadsheet in which there are some random numbers available and I want to find out the specific total. Let's say I have 4 numbers in colmun 80, 40, 20, 90 in separate rows and I want to find out which rows add to 130. Any help on this? PS: I am a beginner in...

hi there, i'm working on an excel spreadsheet, and basically i have to copy text from a pdf file to an excel sheet. sometimes, without doing anything different i stop being able to paste, on the cell or on the formula cell (i've been pasting there because of different formatings in the text). i...

Ok so I've been working on a spread sheet for a gane i play (NWN) Im looks g for help on a formula to do the following if it's possible. I need to look in the range AV6:BF45 within that range I need to find out if a cell contains "weapon focus: A13" A13 refers to a cell value which changes...

Hey everybody, At work I have to maintain a schedule for my boss in Google Spreadsheet that has 5 appointments per day, Tuesday thru Friday. Right now that involves me writing in the date and then copying and pasting it in 5 rows and then copying and pasting the time slots (9, 10, 11, 1:30, and...

Is there a software program out there that can take a list of names (for instance, in an Excel spreadsheet) and automatically insert those names into a graphic image (jpg, gif, tiff)? To clarify, I would have a meme and at the bottom I would have something like "<<First Name >> <<Last Name>>...

Hello, I'm attempting to apply the 'FORECAST' function to forecast a row of numbers 0 to 3. I selected a row of numbers to forecast. I then receive the following prompt: The formula you entered contains errors. If you do not wish to use a formula, insert a single quotation-mark before your...

problems with hyperlinks in excel spreadsheets

One of my users in our Sales department showed me an Excel file today that when saved is excessively large. All the rows (approx 30) and columns (approx 15) are all using simple formulas (add left to right, top to bottom, summarize at the end kind of stuff). There are 5 tabs in the spreadsheet...

Currently, each email address in the document is behind a hyperlink that's represented by a small white envelope icon (I've attached a picture). I need a contact information sheet that I can print; I need to keep the same text and formatting, and replace the icon with the email address in plain...

I need to produce a CD with a file like an EXCEL spreadsheet to be supplied with a product. Is there something I could use that is usable on PC and MAC that can be opened/ copied to the customers machine and edited?

I have a spreadsheet made with Microsoft Office that I put on a flash drive. I cannot open this file on my new computer because I do not have Office on my computer. Is there anyway to change this file name so I can open it? Thanks

I have a spreadsheet with one column that indicates what type of Ultrasound we performed (i.e. OB, MFM, GYN) - is there a way to put a formula in so that if F1 = OB then J1 will = 35.00 (for all 3) - i.e. if J1 = MFM then J1 will = 65.00... not sure how to fun the formula for multiple values in...

I am working with Access 2013 and would like to be able to make changes in my tables and have them automatically reflected in an excel spreadsheet.

Okay, I'm going to try to explain this as thoroughly as I can so there are no mix-ups about what i'm trying to do. I have two existing excel spreadsheets with company inventory on them. The first has the part number and the cost of all items ever put into inventory, the second is for inventory...

Would be grateful if someone can assist. I wish to highlight the column heading and row label if a cell within a table is selected. Excel 2007 example of what I want - Column Headings are in cells C3:J3. Row labels are in cells A4:A56 and B4:B56. Data is in cells C4 to J56 eg if cell F7 is...

We have a multi-page spreadsheet used for account-keeping at the studio I work in. I had to recently rebuild our reception PC as multiple memory components failed in the motherboard. The rebuild has not problems what so ever, the only problem we have is transferring establishing the extensive...

Can someone please help me find the right formula for this spreadsheet? I need to subtract from the "Savings Account" to make the "Current Account Bank Balance" 0 (ZERO) only IF the "Current Account Bank Balance" is negative, otherwise not. Also, if the negative balance of "Current Account Bank...