Excel Forum
-
skip a value [Closed]
suppose a1 a2 a3 = john,michel, robert, respectively and b1,b2,b3=10,9,10 then from values of b cell i wanted to print name in g cell who have corres...
-
comparing multiple columns for list of items [Closed]
Dear experts I have list of names with multiple words in column A List of names with multiple words in column B List of names with multiple w...
-
Copying data on Macro Enabled Excel Sheet from Source File [Closed]
I am doing account reconciliation on a Macro enabled excel sheet for various funds. which performs some task through Macro on sheet, Now i want to ...
-
How to delete a line from Excel cell [Solved/Closed]
Dear all How to delete a line from every cell in a column??
-
Running a Macro permanently [Closed]
Hello, I have copied and edited a Macro to a workbook to save a certain cell as the file name. The problem is that you have to click on Macros fin...
-
2010 IF function help [Solved/Closed]
I'm looking to combine a IF function for one cell with a date function in another. The aim is to have something like this: =IF(A1=2099,"James Jones...
-
conditional statement [Closed]
i want to create a conditional statement to formulate below if A1=>0 then equal the value, then if it is blank then get the value or number from A2...
-
Need a cell value to change automatically based on a future date [Closed]
Hello, I need to submit weekly reports on the number of students in classes (currently enrolled, graduated, etc.) The problem I have is that sometime...
-
Iam trying a lot to make the formula succes, but its not helping [Solved/Closed]
Hello Ther!! Iam trying a lot to make the formula succes, but its not helping all people ther Kindly help me on the below formula it gives resu...
-
Formula to move appropriate data to new sheet [Closed]
Hey everyone, I wanted to attach my spreadsheet but no such luck. Essentially, I have a spreadsheet with people's certifications. I have one col...
-
How can i transfer data in a row in a work book to another book [Closed]
Hi, I will be downloading data each day which consists 150 rows. Each row contains a data set pertaining to an individual item. Each of these ite...
-
finding a subset [Closed]
Please help me to find subset of A=(1-39). All subsets should be having six (6) numbers, e.g (1,2,3,4,5,6), (1,4,7,23,34,39), (2,8,9,21,29,30). Or hel...
-
Archiving an order [Closed]
Hello, Hi all, I wonder if anyone can help, I am trying to make a macro that will archive an invoice before the next order. Thanks for any help...
-
Link data with image [Closed]
Hello, I have C:\Photo folder with all jpeg images. All the names are unique and exactly matches with my product code number. In excel 2007 ...
-
Populate data from spreadsheet to spreadsheet [Closed]
Hello, Project Description: For daily customer orders, I need to be able to quickly and automatically have all rows in column D populated with t...
-
Conditional Formatting [Closed]
A B 226 215 80 127 0 0 226 215 80 127 229 234 206 206 211 233 19 217 220 231 20 232 21 134 32 224 51 227 above is my data. when ...
-
Automatically transfering data from one worksheet to another [Closed]
On excel is there any way you can get rows to move over automatically if their status changes?? So for example on a spreadsheet if you had a list of v...
-
Autofill of information from another worksheet [Closed]
Hi! I am currently making a report wherein I need for the information from another worksheet to be automatically inputted once the code is typed in...
-
Conditional Formatting analyzing the a range of cells [Closed]
Hello, I have an excel workbook with multiple tabs that contain many internal checks. Therefore, I created a "summary tab" that uses conditional ...
-
Merging two excel sheets [Closed]
Hello guys im totally new here and i want to ask a question. I have two excel sheets that i want to merge. Let me explain what i want to do and i ho...
-
Conditional formatting for a range [Closed]
Hi! I am working on a file where I have to format the cells in one column based on a list place in the same sheet in a different column. Basically...
-
duplication [Closed]
Hi, I a have a column A i.e names . for ex. 1 Row shailendra, 2 Row sailendra, 3 Row shylendra. above (3) names are same but spelling change now i...
-
Dating Problem! [Solved/Closed]
Hi Can you help? I need a cell to only input if a lead cell is blank but if the lead cell has a date format i.e 24/11/13 then to input that sam...
-
Matching data from two spreadsheets [Closed]
I have 2 spreadwheets. One is a master equipment list with info stored according to Equipment #. The second is an invoice for equipment that is on th...
-
how to add a value to a cell if the other cell has text [Closed]
Hi, i am not able to find how to do the following formula in excel. what is the exact formula for: "if the value of the cell A2 is text then t...
-
Link image as per cell value : Complicated [Closed]
The explanation of the required details is in the attached sheet itself http://speedy.sh/M5SHA/Images.xlsm regards Pooja
-
Hide/Unhide an Autoshape or Picture in Excel [Solved/Closed]
Hi All, Could anyone tell me the method to Hide/Unhide an Autoshape or Picture in Excel Spreadsheet? I know it is possible through Macro Codes, an...
-
conditional formatting of a cell if another cell is blank [Closed]
Hello, All i am challenged in resolving the following problem I have and am hopefull that someone can help in Column E I have specific text "tier ...
-
trying to copy data from one sheet to another and rearrange [Closed]
I have an Excel sheet, and I need to clean the data and copy it to another sheet. The cells change by 11 between records. I tried creating the initial...
-
conditional formatting if a cell is blank and other has value [Closed]
Hello, in Column E i have specific text "tier 2" or "Tier 1" i would like to format the color column L if Column E = Tier 2 and the value in the cor...
-
Need to copy a whole sheet into another [Closed]
Working with 2 sheets, one as the invoice and the second as the master record. Everything entered into the invoice will be automatically copied into t...
-
Excel count sheets in a workbook [Closed]
how to count the no of sheets in my workbook, like a list or whatever, also get the sheet name against it,
-
excel how to change to value [Closed]
Please help me to change this data which is highlighted in Yellow color to the other cell in values.. i cannot do any calculations on it...
-
Excel if statement using time [Closed]
Hello, I am trying to do some conditional formatting using if statement. I have a spreadsheet that is supposed to flag targets based on a 24hr clo...
-
Nested And/IF Statments [Solved/Closed]
Hello and good day. I am in the process of putting together an annual bonus/vacation accural sheet and need some assistance with building a comple...
-
Excel worksheet auto generator [Solved/Closed]
Hello, i have a workbook with a names sheet that has all the info I need put onto timecard and a master sheet with the timecard that the employee wil...
-
conversion of excel files to dbf files [Closed]
need to convert excel (win 7) to dbf what software options are available
-
Formula to count if cells in consecutive columns are populated [Closed]
Hello, I need an equation that will return a 1 in column F if data is available (cell is populated) in 2013 or last two years (2012 & 2013) or las...
-
Need help with lookup? or if? command [Solved/Closed]
Hi Everyone, Can someone help me with a command or macro that will look up the price of a product in a country from a reference worksheet and then fi...
-
formula needed. [Closed]
Hi dear i am looking for an formula that can resolve the following issue. I have a table of: Actual...............................................
-
Compare cells of two columns excel 2007 [Solved/Closed]
Hello, I have two columns with identical cells and I need to find those that are not the same. For example: Column1 Cell1 = "a", Column2 Cell1 = "...
-
cap-locks [Closed]
Hello, Is there a way to make a spreadsheet only type in all caps? Configuration: Windows 7 / Internet Explorer 10.0
-
CONDITIONAL FORMATTING [Solved/Closed]
I need a formula stating that if cell R7 is blank, then Q7 is yellow. So if anything is entered in R7 then the cell Q7 is no color
-
Creating a new customised Excel workbook from a main workbook [Closed]
Greetings First it is nice to join you in this forum, hoping I can add value in the future to whatever endeavors you have been delivering till date...
-
Excel Enter Key [Closed]
Viewed your site to advise how to press the enter key and have the cursor move right in lieu of down as it is doing now. The instructions listed ...
-
Copying data into a master spreadsheet [Closed]
Hi i am trying to copy different worksheets on to a complete worksheet, i have recorded a macro but it doesn't collect any new information, how do i m...
-
Formula help [Closed]
I have a huge excel spreadsheet that I am needing to sort by type of loan (J3:J132) and then select the totals from that type of loan (D3:D132) and to...
-
Help With Major Excel Problem [Closed]
Please help with the problem if you can I have a single column of data numbering in 650k The Problem I have here is within this column I have com...
-
Need Macro- Copy Row and Insert 10 times [Solved/Closed]
Hello, I have a similar question as this previous thread: https://ccm.net/forum/affich-107673-copy-row-and-insert-n-times but I'm not sure which ...
-
Delete selected data in Excel 2007 [Closed]
Attached a link which will give the details http://speedy.sh/bQWZM/OutletsCode.xlsm thanks JS Desai
Subscribe To Our Newsletter!
DON'T MISS
- How to Get More Followers on Instagram
- Computer Boots to Black Screen
- How to Upload High Quality Photos to Instagram
- How to Create a Gmail Account
- Facebook Code Not Received
- How to Recover a Disabled Facebook Account
- How to Fix a Blurry Snapchat Video
- How to Disabled Write Protection on a USB
- How to Install a VPN
- How to Get Free Diamonds in Free Fire
- How to Recover Your Yahoo Account