Excel Forum
-
SOLVED... didn't need a macro! Closed
Hello, Turns out no macro is needed... =INDEX(Sheet1!B:B,MATCH(A1,Sheet1!A:A,0)) I have a rather complex issue I'm trying to solve with a macr...
-
Excel Macro for deleting rows IF cells not... Solved/Closed
Hello, I need help to create a Excel macro. Basicly what I have is a sheet full with information about different departments and what I want to do...
-
Comparing value of a cell to a range of cells Closed
Hello, I want to compare the value in a cell - B1 - to the values in a range of cells and return 1 if true and 0 if false. I set up $H$1:$H$14 as my...
-
Conditional Formatting in MS Excel Closed
Hello, Would appreciate if you could please help me with the entire process how to do do conditional formatting for one entire row- which contai...
-
Paste inserting blank cells Closed
Hello, Using VBA I want to copy a column with a variable length and paste into another column inserting 2 blank cells for every value pasted, like t...
-
Need Macro Coding Closed
Hello, I NEED SOULTION. i HAVE DATA LIKE BELOW FORMAT. A B Apple Apple Apple Apple ...
-
Excel - Select Last 25 Records Solved/Closed
Hi I have a spreadsheet that is entered into daily a list of actions taken in a department. This needs to be printed weekly and displayed. Obviously t...
-
Auto Update Master Sheet Closed
Hello, I am trying to prepare a master sheet. My problems is as below:- There are 4 different work stream owners and all of them have access to...
-
Excel - Removing different rows in 2 sheets Solved/Closed
Hello, I have two worksheets containing a different number of rows. I want to delete all rows in sheet 1 that have a value in column A that c...
-
Excel Closed
Hello, i want to highlight a cell if there is no value in the cell. I am using the isblank funtion in the excel but how do i set the color code ...
-
Compare columns and copy Solved/Closed
Hello, I need a Macro to do next : i have 2 sheets Sheet1 and Sheet2. In Sheet1 column A has a variable range of values i.e. A2 : A... Column B is e...
-
Need to find correct Formula in Excel- Urgent Closed
Hello, Received one issue on 29-Sep-11, the turnaround time to solve this issue is 6 working day. In my case A1-9/29/11 and TAT for its closure of...
-
Excel filter with macro Closed
Hello, I have a excel with different criteria , in which i have to filter according to three criteria's . * And finally i have to pick a ce...
-
Require Correct Formula in Excel Closed
Hello, Received one issue on 22-Sep-11, the turnaround time to solve this issue is 6 working days therefore the Expected date of Closure is 29-Sep...
-
Creation of dropdown from dynamic list in VBA Solved/Closed
Hello, I have been trying to make a Macro that can create a dropdown list from a dynamic list in column A. So far I've come up with the followin...
-
Excel:Sorting2 Closed
Hello, Would be very thankful if You could help. I have 2 columns with country names i need to find which country is most used and sort it DESC ...
-
Avg multiple cells in multiple sheets - Excel Solved/Closed
Hello, I need to average multiple cells across multiple sheets, but not all are in the same column/number. I need to average B35,D35,F35 in Sheet 1...
-
Macro to insert data to changing cells Solved/Closed
Hello, I'm trying to write a macro in excel for inserting input text to a specified cell. I have already an InputBox specifying the text to be put...
-
how to insert 3 logical condition in excel,07 Closed
suppose in column g5 there is some values ranges 5 to 50, when g5
-
change date format in excel Closed
Hello, Configuration: Windows 7 / Firefox 6.0.2 My spreadsheet has date in cells as: 7/1/2003 but displays as Jul-03. Need to have date in c...
-
Excel Merge Text files Solved/Closed
Dear Forum Members, As I am not a VB expert I have copied some codes and edited to suit for my purpose. My idea is to combine many .pyc files in a f...
-
get columns from one sheet to another Closed
Hello, i have one sheet with values in number of columns. Its columns may not change but its rows will increase. I would liketo get some o...
-
Excel:Sorting Closed
Hello, I have 2 columns with country names i need to find which country is most used and sort it DESC and by A-Z (most common used countries are m...
-
copy rows and paste in a single column Closed
Hello, I have multiple data rows and columns in excel format 0.00111 0.00111 0.00111 0.000018 0.000018 0.000018 0.000017 0.0000...
-
Excel text to columns converting PM to AM Closed
Hello, I have a spreadsheet that has 9/11/2011 1:33:03 PM in the display bar, 09/11/11 13:33:03 PM in the cell. When I perform text to columns to...
-
Compare two excel Columns of differant size Solved/Closed
Hello, i am having two excel columns of differant size..Both the columns contain mobile numbers..i have columns A containing all the mobile numbe...
-
Macro help - search for text in Excel Closed
Hello, I've been trying to wrap my head around how to do this but haven't had any luck -- I want to search for text in excel in a spreadsheet of 40...
-
Excell mess Closed
Hello, I want a price from Column E if it has in Column F (next to it) the number 1 to go to Column Named GRoup 1 if it has number 2 tou go to Group...
-
Copy paste rows in Excel across worksheets Solved/Closed
Hello, I'm trying to create an excel macro that will copy a sequence of rows from 2 different worksheets and paste them in a third worksheet using t...
-
Excel Conditional Formatting VBA Closed
I am trying to format excel to do the following If A1 is "Bad" B1 to G1 Cell color is Grey If A1 is "Good" B1 to G1 Cell color is Green If D1 is ...
-
Excel if Formula text vs numbers Solved/Closed
Hello, I am trying to run an If formula that if the cell range contain text then use Counta but if cells contain number use Sum. At present I'm us...
-
seach for all worksheet and copy the name Solved/Closed
Hello, I'm trying to see if anyone can help me with this, I do have a master excel file that get info from other excel files, currently I have to d...
-
excel list of names Closed
Hello, I need to type a list of names that I would like to automatically show up in a few other areas of an excel spreadsheet? Is there a way to...
-
Excel-transfer from sheet1 to sheet2 Closed
Hello, I am using Sheet one as a list of materials I have ordered for our company. Once a material arrives, I change the "Status" column from "Ope...
-
Excell macro to calculate date differences Closed
Hello, I have a date string in following format: October 1, 2010 8:00:00 AM GMT+03:00 I need to calculate time difference in days between 2 dates ...
-
MS Excel 2007 - Quick Function Question Solved/Closed
Hi Guys, So say you have 3 cells. A, B, and C. I'm trying to come up with a function to put in C that erases/blanks A if B is #N/A (IsError?). Can ...
-
Need links to copy over with new spreadsheet Closed
Hello, I have several spreadsheets that are linked to one main spreadsheet, these spreadsheets are saved and a copy is created every month, how can ...
-
how do i use a macro to do this? Closed
Hello, I am trying to set up a macro to use in a program where for example. If a value of 1 or 1st place then the value of 6 would be appointed t...
-
How to run 2 macros when worksheet is updated Closed
Hello, I am a total newbie in this and I would really appreaciate your help. I am trying to make macro for counting of cells of same colour in a she...
-
VBA Macro, Next not working Closed
Hello, I would really appreciate some help please. I am attempting to - copy an entire row of data from sheet 1 to a new blank row in sheet 2 - w...
-
Transfering Row Data - Sheet 1 to 2 Closed
Hello, Im new to this macro stuff. Currently I have a file where on the first sheet I have multiple data and that data needs to be transfered to di...
-
VBA - Copy range # of times value is in Colum Closed
Hello, I am looking for VBA code to copy/paste a range the same # of times a value (Department Code) appears in Column A. So, if Department 123...
-
Extract data from specific cells in excel?? Closed
Hello, I am trying to copy specific cells from excel and dump into a worksheet. The macro would open, read those specific cells and dumb the cel...
-
Copy and Paste certain columns based on dates Solved/Closed
Hello, I am trying to create a macro that will look at a list of dates in column B then copy and paste the data in column C and D to another sheet...
-
compare two columns in excel 2010 Closed
Hello, Configuration: Windows 7 / Safari 535.1 I need to compare two columns say column A in worksheet1 with column A in worksheet2, colu...
-
Excel sorting Closed
Hello, I'm an Excel novice and I need to sort a list of email addresses on the company name or everything that appears after the @ sign. How do I...
-
copy data from one excel sheet based on type Closed
Hello, I have a scenario where there is a main worksheet in the workbook which contains information in the below format Item code Ite...
-
Make an excel sheet Closed
Hello, I HAVE TO MAKE A EXCEL SHEET LIKE THE ATTACHED ONE.HERE Cellular Accessories,Cellular Activations AND Performance Metrix Summary ARE THREE ...
-
Delete old information from Excel 2003, VBA Closed
Hello, My appreciation in advance for any responses to this. I have a sheet which measures certain things on a daily basis, there is a "Sat", "...
-
VBA or change settings for "Picture format " Closed
Dears, If any one can help me either by changing some settings or through VBA code. The case: I have excel workbook including 100 worksheets fo...
