Hello Experts,
I have a range (Data) that will have either 4 or 5 columns of data. The range may begin in any cell of any sheet name and may have any number of rows. Using VBA code I would ...
Ok - this should be easy for anybody working with Access/Excel/VBA:
I'm transferring a Recordset in Access to a spreadsheet in Excel. All is working nicely. Now I'd like to 'gussy-up' the s...
trying to change a data sheet in excell with all caps to first letter upper and the rest lower case for a group of columns. i try to put in my formula and it appears it will do fine but a "ci...
I have a client that wants to somehow change a letter into a number with a macro or VBA. The source is an excel spreadsheet. His example states that for instance U=2, qd=3, qod=3, I=1, IU=5 w...
I read a previous post where the question was asked about summing values in Excel with colors. I have found that this will only work with one color. In my situation i need to sum at least 10...
Hello expert
I need a expert in excel who can help me with plotting the tasks in the project
say
project tasks, Planned Start Date, Planned end date, Actual start date, Actual end date
i...
Hi Folks,
I am trying to retrieve data from a column in a listbox on a form.
The list box has several rows and columns of data, and all i want to do is to cycle through each row of data ...
Currently, when the file is already opened and another user on the network open it, it says it is already open by User1 would you like to open in read-only?
What we want with this particular ...
I am trying to use a For LOOP to alternate throught the range of cells in Excell but do not quite remember the syntex. Here is what i am trying to do:
On row 1 select first three cells ...
Hello
I have an Excel Spreadsheet which houses 4 pieces of information: Account Names, Inital Mortgage, Paid Amount to Date, and Balance do. Is there a way to generate an Letter Template ...
hi there,
in excel 2008 (Mac version) i'm trying to find a solution to search for part of a pattern in an array of cell, and then applying a sort function to give me the highest match.
E...
I have a spreadsheet with 1333 entries. At the end of this spread sheet is an entry for a company called "ETI". When I try to filter for this entry it does not show up but the comany is listed...
Hello Experts:
Looking for a VBA script that will find the maximum value for a range of values in one column and repeat this between breaks. The breaks are not uniform meaning that there m...
Hello,
We have an internal web application based on PHP and MySQL that produces HTML tables of data. The data is generated by MySQL queries in the PHP code, and the PHP write the files as ...
I am on excel 2007, XP:, and working with financial statements in Cordobas (foreign currency); I need to convert all of the in balance sheet, income statemtns, cash flows, et al financial numb...
I have two spreadsheets that I need to compare and merge. Here's what I'm looking to do:
Sheet 1
Customer Number Customer Name Accounting ID
12345 Joe...
How do you make a Class module created in an addin visable and usable to other workbooks?
Addin properly loaded and registered. Office/Addins/Addin checked
within vba project... Tools/Refere...
I have an Excel spreadsheet with about 15 columns and want to print them out onto a 8-1/2 by 11 inch page.
I want to do this because printing a regular spreadsheet of about 15 columns would...
I can't locate clear answers to basic questions about Excel Macros: 1) Where is the code for a Macro I create stored? Apparently, it can be in one's PERSONAL.XLS file, but I have never seen a...
Seeking a software solution for the following:
I work at a school where, currently, proposed events, fixtures, sports matchs, drama performances, etc are put onto an excel spreadsheet. Whe...
In a 2003 excel workbook1 i have a button to which i have assigned a hyperlink to another workbook2. Workbook2 needs to be scrolled through by the user. In workbook2 i want to show a butto...
How do I combine the below SumProduct Formulas. Whenever I try I get a N/A error. What am I doing wrong?
First Formula
=SUM( SUMPRODUCT((LEFT('NTCSS-RAWDATA'!B9:B2557,8)="NALC IMA")*('...
I exported a record to Excel that had lot of repeating information. I filtered the data by clicking on unique record, which got rid of the repeating records. The problem here now is that inst...
I was wondering if anyone has ever accomplished creating a dynamic dropdown in Excel that derives it data from Access 2007. I am to make a cell a dropdown and have it populate that data with a...
