I have a Macro that essentially consolidates all the same data in column A, then separates the worksheet into individual worksheets, named based on the data...

I would like to be able to forecast next years production using previous years production figures.

Hi, This is my spreadsheet. Column C has the LOOKUP formula. A B C 53 a a LOOKUP(A2,$A$2:$A$14,$B$2:$B$14) 447 b b LOOKUP(A3,$A$2:$A$14,$B$2:$B$14) 1...

I am using the lookup function to find similar values in two different columns and am able to get the desired results. However when I want to bring the value...

I try to use ALT+ENTER in a function, but the result is a continous line. ex. C1=A1 &A2 &A3 Is there any way to produce a result in C1 with hard breaks?

Is it possible to have a button on a worksheet and just have the buttons say "notes". Then when it's pressed a dailog box opens for the data entry?. If so, how...

I'm working with two sheets. I have certain cell's information from sheet 1 going to sheet 2. I was doing fine until I needed to add an insane amount more...

I am trying to get a cell to act how Microsoft Words deals with web address. For example writing. www.bob.com in Word would link that to the website, chnaging...

Hi, I made a mistake last time ....sorry I have two separates excel workbooks ( not worksheets!!). Workbook no 1 which has several columns : A ( XP numbers)...

I have a big spreadsheet, and need a quick macro or formula to automatically delete every seventh row.

i have a spreadsheet w/over 800 rows and when i was printing a couple (well over 200 )of the rows did not print correctly. So I have hidden the rows...

When I use New database query -funtion and having a semi-colon delimited csv-file, everything works fine, I can make a qeury and use criterias. When a csv-file...

Hello: Before I drive myself nuts building this workbook, I need to find out if it's doable. I appreciate any help or suggestions offered. We have a...

I'd like to create a logical formula i.e. if X = Y, "A","B", and have excel speak the result. Any ideas ? ---------------- This post is a suggestion for...

I'm trying to update a weekly report that contains historic data. the challenge is to count only the new information based on the date the worksheet or...

When trying to access changes in sharing I come up with the following message. "Excel cannot complete this task with available resources. Choose less data or...

Hi, I have a cell in worksheet2 which references a cell in worksheet 1: e.g = Worksheet1!A3 But if A3 in woksheet 1 is empty (null?) the cell in worksheet2 has...

I have a fax coversheet set up on Excel that I can type and then print. At the bottom there is a comments section. Even though I have the text set up to wrap...

Just wondering if I could automatically change a graph. For example I do a number of graphs for every month, obviously days of the months changes so on a...