I was using a macro whihc creates a pivot table from an excel sheet. while grouping the data in the pivot table.while grouping,i have few problems. i have grouped issues under <1week,2weeks, 3...
I have a spreadsheet with data in several colums and down a number of rows.
Each record comprises data horizontally across the row.
I need to be able to sort this data by eg. date and have a...
Hi,
I'm working with Excel 2007 and I have a spreadsheet with data starting each row in column B and I want to sum it all in column A. In other words A1=Sum(B1:Z1), A2=Sum(B2:Z2) etc.
Th...
Hi experts,
I have a report that outputs text into a date column 'E' in excel.
This formula works:
The Excel function that converts dates to text is: =TEXT(XX,"m-d-yyyy")
XX is the ...
Hello,
I found this function, FIFO, that computes product cost. I want to modify the example so I can apply it to my case. Instead of many product codes, I only have one product. Instead o...
In Excel I've inserted a "button" and assigned it to a macro. How do I change the face color of the button? I'd like to change the face color from grey to blue. Or better yet can I insert a...
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 ...
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...
This is probably a very basic Excel question, but I just can't find the answer anywhere! If I type a word into cell A1 and make column A very narrow, the text overlaps into cell B1 (which is ...
We have an online scheduling application at work that requires us to fill out the same form for each event. (Hour by hour). You end up filling out the same form over and over to build one day...
Using MS Excel 2003, I need to compare sheet1, column a, with sheet2, column a, and combine ALL unique values to create a list on sheet 3. For example,
NOTE: sheet1, column A does not cont...
An Sccess database for process rejects/downtime has a lookup table for description by product code.
The codes change and the description table has to be updated from time to time. It has bee...
Good afternoon,
I have a fairly simple question. I want to copy the formulas in cells B1 and C1, based on the number of rows that are populated in Column A today vs yesterday. So lets say ...
I am working with a solution (not mine) in which and Excel application (you know a bunch of Excel forms using Excel as the source) finishes the process of auditing payroll records by generatin...
Hello,
A person on this forum helped me with modifying this code to compute inventory cost via FIFO method. I forgot to ask him to include beginning inventory. Does anyone know how to modif...
The setup: Excel workbook with 53 sheets: one totals page, 2 expense reports and 50 invoice style pay stubs. The totals page is pulling info from some other workbooks, namely the employee's na...
Hi Experts,
I have an Excel spreadsheet that has hyperlinks randomly scattered in different cells within the spreadsheet, is there a way of having a macro that can remove all hyperlinks in th...
I'm trying to import an Excel 2007worksheet into Access 2007 using the "Import Spreadsheet Wizard" and when I go to "Finish" I get the message "The search key was not found in any record." and...
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...
we have severals spreadsheets wich has linked excel files to severals cells. all files are linked to different servers and we would like to modify them to point to just one server with all the...
How do I use a filter in Excel to only show records that have a certain number of characters? For example, I have data that contain three columns each with a heading of "First", "Middle Initia...
HI
I try to read a specific column from excel sheet for example column 1 and column 3
I used
A = xlsread('test.xls' ) ,but it read the whole excel sheet
can any one help me in that
Hello all:
I need assistance regarding Excel. I need to insert VBA code under workbook in order to process an SQL file (already exists), save the workbook, close and exit Excel. What are t...
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...
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...
