The discussions
Vb code to copy data from one sheet to anothe
Hello, My problem is similar to first one. I was able to solve with the solution provided by helper. thanks helper. But, if column Q contains blan...
Solved... didn't need a macro!
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...
SolvedHello, 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
ClosedHello, 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
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
ClosedHello, 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
ClosedHello, I NEED SOULTION. i HAVE DATA LIKE BELOW FORMAT. A B Apple Apple Apple Apple ...
Excel - select last 25 records
SolvedHi 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
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
SolvedHello, 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
ClosedHello, 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
SolvedHello, 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
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
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
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
SolvedHello, 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
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
SolvedHello, 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
SolvedHello, 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
Closedsuppose in column g5 there is some values ranges 5 to 50, when g5
Change date format in excel
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
SolvedDear 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
ClosedHello, 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
ClosedHello, 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
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
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
SolvedHello, 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
ClosedHello, 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
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
SolvedHello, 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
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
SolvedHello, 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
SolvedHello, 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
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
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
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
SolvedHi 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
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?
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
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
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
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
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??
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
SolvedHello, 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
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
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
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
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
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", "...