The discussions
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 ...
If, then statement in excel
SolvedHello, This formula sounds easy to come up with, but I cannot figure it out. I'm trying to figure out how to add a certain amount of days to a dat...
Count days excluding weekends
SolvedHello, I want to do a monthly report and I have four colums: "issue date" "pick date" "pack date" "Ship date", each cell have dates, I need a form...
Conditional formatting
Hello, I'm creating an excel doc and I have used vba to conditional format a cell based on an exact match i.e. "HOL" so that when HOL appears a ce...
Show value of row 1, where row 2 is greatest
SolvedHello, 0 1 2 3 4 5 6 7 8 9 10 0 2 5 6 5 1 3 1 0 0 0 1 4 2 4 5 4 2 1 0 0 0 0 4 6 5 1 5 0 1 0 0 1 1 0 5 8 5 3 1 0 0 0 0 in the t...
Vba code in excel to work for many sheets
Dears who can help me. I have excel file includes 30 sheets for different 30 employees. I have the following VBA code. Private Sub Worksheet_C...
Remove watermark/objects in pdf
SolvedHello, I wanted to remove watermark/image like objects at particular portion of every page of a pdf. Can anyone please tell me which software app t...
Copy data from one sheet to a master sheet
Hello, I have a worksheet, sheet1 where I enter the product code and it gives me the Bill of Materials for this product. I would now like to cop...
Excel
ClosedHello, I am trying to make it easier to get expense totals by category. I have created a spreadsheet that has text (expense categories -- meals, ...
Vba for repeating groups of rows
ClosedHello, I need to copy several rows of data n times. An example of the data would be: 63111 64546 67818 So that the results of the VBA would...
Transferrring figures from page to summary
ClosedHello, I have a spreadsheet with different names on each sheet. On the sheet it keeps a total of money for job, then it keeps total of money spent a...
Excel: populate data based on criteria
SolvedHello, Good day. I would like to populate data from 1 sheet to another sheet based on certain criterias. With reference to the sample data provide...
Excel comparision
Solvedhello, can any one help me solve the following comparison problem.. a(reference data) b(raw data) c(status) ab ...
Vba code in excel for 200 sheets
SolvedDear all who can help me. I have salary excel file. This file includes 200 sheets which are for each employee. I have the following VBA code. P...
Inserting text
Hello, I'm not tech savvy, so please bare with me. Using Excel, I want to have text inserted into one cell based on text in another cell. If I...
Double problem - password and drive
ClosedHello, I have a compaq laptop. The cat knocked it off of the table. Now when I attempt to log on, It will not recognize my password - I know it is the...
Copy row if a range of column matches a value
SolvedCould you please help me with the following macro. The following macro basically copies the entire row if the column B contains the value "1". But ...
Excel help
SolvedHello, If possible, can you help me in coding this: Collumn J will have the drop down menu of Open, In Progress, Complete [Open as default] ...
Macro for deleting row with condition
ClosedHello, suppose I have one column in which there are 24 rows i.e. A1:A24 and these rows contain some value I need to make one macro in which I ...
Diffrent formula in one column
Hello, I am using Excel 2007 I used conditional formatting for the selected area example I wanted that if the figures in column E get higher then co...
Comparing two lists
Hello, So I am really stupid, I need the exact code and where to put it. I have two separate sheets Sheet 1 has 1 2 3 4 5 6 7 8 ...
Pls help me transfer itouch apps to my comp
ClosedHello, I took ipod touch apps from my friend and synced it on his computer and now i am trying to transfer the apps to my computer and I have autho...
Password screen
Hello, i have a toshiba laptop and i cannot access my password screen therefore preventing me from accessing my start menu to shutdown my windows ...
Memory card password missing
Hello, i have set password for locking memory card with nokia supernove7310 but now i used nokia 2700c 2 ,therefor i couldnot unlock my memor...
Delete rows that don't match another data set
Hello, Excel 2010. I have essentially two data sets. One is a dump from an analytics tool that contains about 8,500 rows of data with about 3 c...
Memorycard password
Hello, my name sri ican forget my memory card password icannot run the feexplorer in my nokiac2-03 mobile ,how can i know the password Thanks C...
How to create a row list according with dates
SolvedHello, I'm trying to create a list of dates according with the time periods shown bellow on each row, i.e. for entry 1991001, I need to replicate ...
Bowling scores
ClosedHello, I've created a spreadsheet (Excel) that calculates scores, handicaps, points won and lost. what i am tryin to do... i have the bowlers scra...
Excel
SolvedHello, My name is amit and i am having problem with creating a excel sheet which has three columns stating date , service and amount. and now i wan...
Real time clock
Hello, is there is any way to add real time clock in excel which updated automatically. and is there is any way to set a count down counter in ex...
Vba code to copy row based on dates
ClosedHello, I have a spreadsheet that I am compiling for completed work orders. The sheet I want to copy the information from is called "Completed". In...
Password reset
I need help with a password required before startup. cn any1 pls help
Sunil dhyani
SolvedHello, I have a problem, how to delete entire column from the sheet that contain particular word with other word as a header. Example i want to de...
Vba code in excel
SolvedDears who can help me to write VBA code to solve the following case: I have Excel sheet to calculate overtime, includes several rows for each month...
Collect all data in the drop down list
ClosedHello Guys, Hope you can help me on this one. In the first TAB I have the Overview report where all the data together. I was looking for a ...
Recovering a word document
Hello, well basically i have two years of important college work saved to a usb flash drive and i havent saved them anywhere on my computer, unfortu...
Compare 7 colums of data in 17 worksheets
Hello, I am a complete beginner with Excel, so please excuse me if this makes no sense !! I have made a spreadsheet for driving hours which add...
Excel 2003 color drop down menu limit of 3?
Hello, I am working of Excel 2003. I already created a drop down menu which has 6 items in it. When I get to the part about "Conditional Formatting"...
Macros
Hello, I want to create a VBA code which if can fiend in column "B" the value ICA to copy the row in another worksheet. EX A B C D 1 ICA 2...
Find data by entering data in another cell
SolvedHello, I have an Excel 2007 Workbook that I use for tracking the status of over 50 projects. This Workbook contains 6 worksheets plus a "MainMenu"...
Macro or vb in excel 2007
SolvedHi. I have next to no experience with macros & VB. But I have a problem that I need resolved. I have 11 sheets in excel. 10 sheets need to pull in...
Formulas no longer calculating
ClosedHello, I have several Excel Workbooks that, recently, no longer recalculated/run my formulas when I change a number. For instance if I change a val...
To get cell contents into excel file property
SolvedHello, Can you please kindly help me to solve the below interesting issue? (I will make my best to make myself understood, which is sometimes very ...
Copying certain cells from one column
Hello, I want to copy certain cells depending on their value contents from a column into another column but follow their order. If some cells ar...
Forgot the password
ClosedHello, hi i forgot my security password which i set for my mobile....plz tell me how find it?? samsung omnia HD (i8910)
Excel macro to insert row based on data
SolvedHello, I have a large spreadsheet w/ over 9,000 rows of data. I would like to know if a macro can be built to add a row(s) based on the month. In t...
