Excel Forum
-
Print if Statement ??? Closed
I would like to build a inventory spreadsheet that prints a requisition. ie: Qty reuired : Stock # : Description : etc So the list is 4-5000 i...
-
Excel If statement for dates Closed
Hello, I was wondering if there was a way that I could set an if statement that would change the color of box to red if it's 2 months ahead of tod...
-
How to use recorded macro in different cells Closed
Hello, Kindly help me to resolve this issue, I want to insert data in 4 different cells each i run my macro sample data: Sub Insert() '...
-
excel fiasco Closed
I'm trying to auto create salary slips. I have a list with the information ect of the employees and have created the first payslip in the next sheet. ...
-
Conditional Fomatting with range values Closed
Here is my scenario: Column A has ranking from 1 to 5. Column B has zone/ classification from 1 to 7. Column C has ratings. These ratings are bas...
-
Combine rows using condition Closed
Hi, I Have spreadsheet like this: Col A Col B 02003SM TB4 02003SM TB5 02006SM TB1 07017SM C461 07025SM C462 07128SM C479 07139SM ...
-
Conditional formatting multiple rows in Excel Closed
Hello Community, I need to create conditional formatting in Excel separately for a number of rows (e.g. high lighting highest and lowest values in ea...
-
varible column (a,b,c etc) within a formula Closed
I have a sheet 1 with raw data inserted. Each Sheet 2,3,4 within the same workbook has another spreadsheet that needs to read the raw data from sheet...
-
Help with a formula please! Closed
Hi. New to this but it seems like a good forum. I NEED HELP PLEASE! I will try to explain my dilemma. In Excel if there is a specific day/date in a ce...
-
how to learn macros Closed
Dear All Please suggest how to learn macros
-
Conditional Formatting with Multiple Drop Downs Closed
I have a spreadsheet that has multiple drop downs. I'm trying to get Excel to highlight errors made in one column if a particular option is chosen ba...
-
Macro to create Worksheets from a main file Closed
Hey guys, Nice work going on here,have been a regular follower. I seem to have come across a problem with my MACRO for excel. I have a Excel ...
-
Copy worksheet misc data in sheet 1 to new row in Master Sheet 2 Closed
Hi, I'm a complete newbie to Excel macros.. Sheet 1: Sheet 1 is my work sheet where i manipulate data. Upon completion of fine tuning the data, ...
-
Vlookup across multiple values to return only one Closed
Bit of a long one to explain, but im sure there is a quick answer. I have a barcode scanner which is used to input data. This data goes into column...
-
Need help with sorting and copying from multiple worksheets Closed
I need to copy a report from several sheets, Workbook 1 First i Have a report Sheet with a fixed header in the first several rows A Sequence of O...
-
If...allow text Closed
A1 has a drop down list with HM01 and Off Spec, B2 = text depending what is selected from the list in A1. So B2 =if(A1"HMO1",'DISHCODES'!B3).....whe...
-
compare 2 lists of names Closed
Hello, I have 2 lists of names with last name and first name. However, one on list there is a comma and a middle initial on the other there is jus...
-
Auto Populate Sheet 2 basis data on Sheet 1 Closed
Hi I have raw data on sheet 1 one of the column is "group name". Data is related to 150 groups, however I need data for only 24 groups. Is it possi...
-
sum ifs function in excel Solved/Closed
Is it possible to have a criteria range for a range of dates and have it add for a date less that the specified criteria? 11/1/...
-
Invoice No Solved/Closed
Hello, After Long period i came here to ask some thing to my friends that is i want to raise the invoice as per the cell value i have given some e...
-
How to change text in a cell based on another cell Closed
I am working on an asset tracking sheet and I want to use conditional formatting to change the text in one cell based on the text in another. Refe...
-
Worksheet problem in excel 2003 Closed
I have a worksheet that I have a yes,no drop down menu. I then have 4 cells below that, that currently have conditional formatting to them that change...
-
Delete Worksheet from List Macro Closed
Hi All, I am trying to delete some worksheets within a workbook from a list containing the names of worksheets to be deleted, listed in column B2:B...
-
Bank Reconciliation Solved/Closed
Hi Am trying to automate bank reconciliation Any ideas as what the code is. In the work book i have 12 worksheets for receipts and 12 worksheets ...
-
tally problem Closed
dear all i want to create a bill in tally erp9 and when i enter the date suppose 24/11/13 then cursor can't go on next text and if i enter 2/11/13...
-
how to merge data of excel sheet with c programming Closed
Hi Sir, what i want , i have the data in three diffrent sheet & the chart i have to show in one single sheet in excel with the help of c programming....
-
How to copy cell to workbooks selected. Closed
Hello friends, please help me with this problem: I want to copy cell(A1) in book1 to cell(A1) in book2 or book3 or book4, etc. Here book1 is for d...
-
Column Combinations Closed
I have a table that has numerous columns. I need to calculate the total number of units used when the combinations of Cells A and B Appear. For exampl...
-
adding a day to the date Closed
I need a formula to add a day to the date. For example, today is Nov 22, 13; I want to add one day to have Nov 23, 13 in another cell. I saw a number ...
-
VBA Macro to calculate values in cell(s) from multiple sheets Closed
Greetings to the greatest trouble shooting team we have around, I am stuck in a situation where I have multiple sheets in a workbook, say this work...
-
Macro for linking two workbooks, comparing one document ID with Solved/Closed
Hello, I need help in creating a macro for linking two workbooks, comparing document ID's in one workbook with the status of that Document ID's in ...
-
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 ...
