The discussions
Formula needed
Hello, Hi - needing some help with a formula - I have several columns taken from sage data. I have in one column employees hours and another employ...
Formula challenge for the excel wizzards. please help
Hello, This might be a long explanation, but only because I want to be clear about the problem. I have 3 different Workbooks and the names are ...
Excel 2010 formula/macro help
Hello, I'm hoping some of you excel wiz's can help me, I've been off the tools too long. Worksheet 1 Column A contains dates Column B contain...
Excel logic
Hello, I am trying to create a worksheet in excel that will allow me to add a certain amount if 2 conditions are met. So far I can only get it to a...
Date format
Hello, please advise me in Changing the date format eg. from 10-02-2012 to 10th February, 2012 Configuration: Windows XP / Internet Explorer...
Insert row in excel by criteria
ClosedHello, Configuration: Windows XP / Firefox 10.0.2 I want to insert row in excel using formula because i have dates in the and there is da...
Copying value to another worksheet
ClosedHello, I am trying to copy a value for from one worksheet, do some math --> say I have three values that I want to subtract separately from cell i...
Pdf reader for samsung gt-b3410
Hello, I use samsung gt-b3410 . I want to download pdf reader for my phone.. from where shall I get??.. pls help me with this... Configuration...
Excel conditional formatting row color
ClosedHello, Column A indicates what type of transaction I've made (ie POS/ATM/CASH/Bill Pay) Column D is the date the transaction has cleared my bank. ...
Excel macro - create new files from ranges
Hi. I am trying to create a macro that will create new excel files for ranges of rows in a worksheet. I want to copy the range F5:S61 and paste i...
Enter sheet update other worksheet with text
Hello, Can anyone help me with this problem. I am updating leave availability , As soon as I enter the name in one worksheet the other workshee...
Instant auto filter
Hello, I am using Excel 2010, and I would like to write some codes that does the following: I have a data sheet of many entries, in rows 9~6000+ ...
How to determine cell value in excel column
SolvedHello, Sorry the title is really vague, it's hard to describe with a limited number of characters. I have a column (C) which contains a full li...
Forget the password
Hello, sir i am using sony ericsson w890i. and i need to format my memory card but i forgot the password. plz sir tell me what should i do ? and sir...
Computer just keep asking for password
Hello, Hi, I am having trouble with my hoshiba labtop. It keeps asking for my password. and behind it is a black screen. It will not allow me to do ...
Read first two characters
Hello, I am new at VB and cannot complete a macro so your help will be appreciated. If I have this data on a worksheet: A ...
Admin. password
Hello, My Daughter cant remember what she changed the owner password to on her laptop. She has windows 7 home pre. Is there anyway to resolve this? ...
Macro - sort range error
ClosedHello, I've created a Macro within Excel that is supposed to Delete, Formulate and Sort data.. I've managed to get the Macro to the point where it...
Worksheet_change from a data validation list
Hello, I want my pivots to rebuilt when a value in range("Book_Select") is changed. This range is a drop down data valiation list. What is wrong w...
Comparing values of 1 excel cell with column
Hello, Please can you assist me with this excel formula? In sheet 1 I have business rules specified in column A and all the requirements that exe...
When value appears adjacent cell acknowledges
Hello, I am looking for some VBA code that looks at a column in my worksheet called "Database" and when a value appears in this column, I would li...
Excel macro
SolvedHello, I wonder if anyone can help me with a small (I think) problem, please? I'm trying to write a macro to manipulate a spreadsheet sent to m...
Pull data from one tab/sheet to another
Hello, Configuration: Windows Vista / Internet Explorer 9.0 Reading all of these posts I get a lot of ideas, but since I am a novice at this ...
Hide rows without conditional formatting
ClosedHello, I'm creating an Excel spreadsheet and want to give it a cleaner look by hiding the contents of a row based on the value of a cell in that ro...
Macro help
Hello, I am new to VB and Excel. I've got the following code: I've got everything working fine, but need the entire row to change colors...
Sum a range only if certain text in another
ClosedHello, I need a formula to sum the values in a range of cells but only for the cells that have a specific text in a completely different range of ce...
Excel search and save problem
Hello, I'm a total Excel noobie so I hope you can help me, I will try and be as brief as posible. Each week I will be getting an Excel CSV of 4...
How to make secondary cells color of primary
Hello, Is there a way to make cells automaticaly change to the color I chose for another? Example: I decide to make cell A1 red. When I do this ...
Filter-cut-paste to other sheet
Hello, Could you please help me on this one, i have a data sheet and i want to filter then cut the data if the criteria is met (Adhoc,Chaser,Excep...
Open pdf file using command buttong in excel
SolvedHello, i have a form in excel which retrieves details of a user from one of the worksheet. against tht user row, there is a pdf file name which basic...
Import from list to table
Hello, I have a list of user ID's, Users & roles allowed on an application. I now need to make a table with users & user names and a place an x u...
Compare cell a1 to entire a col in sheet2
SolvedHello, I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to ...
Excel problem
SolvedHello, Hello, I am hoping that someone can help with the following problem, I have a list of numbers, golf staplford scores, located in cell...
Macros and histograms
Hello, I want to create a histogram on sheet2 while the data required is on sheet1 using a macro. everytime I try, it either says no data availabl...
Conditional formating on more than one cell
Hello, I have 50 columns. Each column represents a different department. Row 2 shows numerical targets for each department. Row 3 shows curren...
Excel - copy data macro
SolvedHello, I am currently learning the tricks in excel but have become stuck. I have created an expenses sheet where employees record various expenses...
Absolute column but reference current row
Hello, Here is my formula i need it to auto fill for a column which stays that same but changes depending which row. Column T is time spent C...
Transfer value between cells
ClosedHello, i am maintaining attendance on daily basis per day per sheet. but sheet 1 contains only number of present on that day. how to auto up...
Excel question
ClosedHello, I am trying to find out how to get the following working, I have a list of numbers located in cells D-AN, these random numbers are loaded we...
How to calculate all the difference alphabet
ClosedHello, Can I calculate all the difference alphabet in 1 column ? Example : in 1 column have A,B,C.... Have any formulue can help me direct c...
Cut and paste row containing certain keywords
Hello, I am wanting to be able to run a macro that will cut and paste into a new sheet any rows that contain certain keywords Is it possible, ...
Excel macro-pasting on next available row
Hello, I am having issues with my macro, I hope someone can help. I have a list, where I would like the macro to see if the value in Column J "Paid...
Read data from one excel and write to other
Hello, I am a newbie. I am trying to find out if we can achieve the below scenario using macros. We have 2 excels in our case. Excel1 contain...
Copy the data from this sheet to other sheet
Hello, I have a problem about macro excel as: I have the data in file excel: Exam: Vendor account Date Invoice Due date Amount c...
Convert rows to cols
Hello, I have an example as below A cac 20 A dwp 22 B cac 15 B dwp 22 B erp 20 I want output as A CAC 20 DWP 22 B ...
Conditional formatting based on 2 cells
Hi, I want to use conditional formatting to highlight a whole row based on text in 2 different cells. For example: I have 10 columns and I need...
Help with macro
hey folks i am trying to create a macro to copy lines of data to another worksheet baed on the original date meeting certain criteria I have a s...
Find the location of cell
Hello, hi can any one help me to find the location of the cell which contain certain value in the excel sheet and then print its location at ...
I need help with simple code
ClosedHello, I need a piece of code that would search B1:N10 in Sheet1 for dates then copy the corresponding A:i value to a column in Sheet2 labeled with ...
How to move data in rows to columns
SolvedThe data now is in the below format 1 2 3 9 15 16 20 25 1 This has to come in this format 1 2 3 9 15 16 20 25 1 ...
