I need Excel to create a flowchart based upon data in a spreadsheet. I have attached an example to allow you to see what it is I am trying to achieve. This spreadsheet follows mineral owners a...
Hi,
Im not great at Excel formulas and was after help. I have 10-15 tabs on my spreadsheet. Daily, users enter in new data to these various tabs. At tht end of the day these new entries need ...
I am printing excel file to pdf...I use Adobe and Cute pdf and have the problem on both. I create a document check it in print preview select printer and then a blank page appears as my outpu...
I have several hundred documents that now show up with .SHS file extensions (scrap objects). When I open them, they open with Excel and I can easily view them. When I change the file extensi...
Hello
I would like to create a macro that would allow the workbook user to save the file depending on the name created in cell "A1"
The user would also be able to choose the folder the...
Hi, i am starting to think that the calculation i require does not exist!
Background data, airline data stored in excel 2003 i have a column of dates, and a column of hours.
requirement,...
Hi
This code is from some of my vb.net code
what is the equivilant code in VBA
Dim ExcelFile As String
Dim FindFiles() As String = System.IO.Directory.GetFiles("F:\", "...
I am encountering a problem where Excel will freeze up when performing minor tasks. For example, it freezes when I click on the drop down menu to change the font size. I have tried teh repai...
Hello All!,
;-)
Here is what I need:
Assume my data looks like this:
JeffCoachman
123 Main Street
Bellmore, NY 11745
Tel. 613-123-4567
JC@JC.com
Some Guy
456 Broad Street
Ma...
I have a budget worksheet that I need to keep a running total of expenses by comparing criteria from 2 different columns and then sum if those criteria are met.
For example, I want to know ...
Excel 2007 users get "access violation" error or application hangs when trying to edit shared Excel 2003 spreadsheet on MS 2003 server. Moving spreadsheet to another server solves problem. A...
Hi, pretty random question....Anyone know of a way to sort celles in a column by their colour? I have standard white cells and light blue (third from bottom right in the pallette)...
Any id...
Hi,
I would like to know how to quickly edit large volumes of cells within tables without individually editing each cell.
For example, a cell may contain the formula =B6
I would like to ch...
Hi:
How do I assgin a column to a range variable. The number of cells in the column that have content is unknown. For example:
Dim rng As Range
rng = column(3) 'this doesn't work
...
I have a data pulling from a Query which has 4 columns Date,Category,Description and total in Dataworksheet attached. I have to tranform Date rows into column (One column for each date) as sho...
Hi,
We save an Excel 2003 workbook and try top open in 2007 and get following message on load in 2007
This workbook has lost its VBA project, ActiveX controls and any other programmabili...
I am trying to create a series of lists in an Excel 2007 workbook that will continually contract and expand based on people adding information into the column. How do I make it work without ha...
Hi All
the coding below I used to open several csv file. how do i change it so that i can open multiple csv file and copy all the data to xls document so that i can filter them according to...
I have a workbook that is in creating mode, and every now and then we go into changing mode.
In saying that normally formulas move themselves on the workbook, but in VBA when you delete a r...
I'm quite green with Excel 2007, what I'm after is being able to run a SQL 2005 stored procedure from within it.
I understand that the best way to achive this is with VBA as shown in the co...
I've recently learned how to import data from excel into mysql databases--> http://www.heritage-tech.net/908/inserting-data-into-mysql-from-excel-using-vba/
However, I'd also like to learn...
Hi All
I'm using Excel 2007. Is it possible to use a update or insert into query like what you'll use in SQL Server in the Microsoft Query Builder in Excel?
If yes where can i find examples...
I need to create a CSV-file for import in Excel (or other Calc-program).
One of the columns is an Item number, which can start with zeroes.
How can I force this column to be a Text-column ...
I have the following code that adds a group and button under the addin ribbon. I did it this way because I did not want to deal with writing ribbonx code, however, I am left with a tiny non-d...
Would it be possible someone could help me with the Macro code, that once "ticked" sheet 2 is unhidden. Once unticked sheet 2 is hidden from view.
Your help is much appreciated.
Gary
