is there a way whereby i can export into another sheet but the same file of the excel?

Hi Frank, I've got an access application which produces a report, then the report outputs into excel. The excel application opens automatically when you run...

Hi NG, I didn't find the answer on line so here I am. I need to import a file like:

Does anyone know how to make an attractive graph that would show total revenue changes through product elasticty? Maybe even show the equilibrium changes?...

Cell appears to have nothing in it, but the result of ISBLANK() is FALSE. Why is this.

Hi: Setting up charts are perplexing to me. Attempting to plot weights vs dates (lbs along y-axis; dates along x-axis). Every time I get the chart to display...

Hi, trying to delete a empty sheet but after selecting it , the delete sheet button is not active in the edit menu . Why and what should I do? -- XP home ,...

First of all, thanks to everyone who answers our questions--it is a HUGE help. Here is my current dilema: I have a totals bar on Row 1 for a sales...

Thanks Charles! This works for all states EXCEPT states that begin with "i"...any suggestions? "Charlie O'Neill" wrote in...

Hi Lady Layla I have the same problem as Jeff in PA. I cannot seem to be able to select the data in my Excel file asn then name the cells to create the...

Hi I would like to put a name in B1(Tony) that triggers a total that i get in G26(43)and have the total in G26 (43) come up in cell L6.Changing the name 8...

Hi all, In my routine job, I have to input data in excel. I want that after I input data in Range "A1", then press Enter button, it will move to right to let...

Is there a way of finding out who saved a particular file the last time it was saved? Is there a way to find out the history of who saved and when?

Here's what I need to do: I have a rectangular array with values for a number of variables (columns) in a number of samples (rows). In another (square)...

This has been bugging us for ages. We have a solution that works on one page, but not across pages. Does anyone have a "super" vlookup that allows you to...

When I cut and paste from another program into an excel spreadsheet I cannot use the CNTRL key to select just the data and the headings on the first page only....

ive got the following in my workbook; =MID(CELL("filename",A1),FIND("",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1) is there anyway of getting...

I call this macro from a "Masterfile" workbook. I want to open a trans workbook and append the data from each sheet to the same sheets on the "masterfile"...

I have the following macro which appends data from a selected workbook to a masterfile (name always the same) workbook. my problem is after I append the data...

Using Excel 97, I'm using a very basic spreadsheet to log some files for a business. The reference numbers for the files are all 16 digits long. I've set the...