Excel Forum
-
Date Function using if_ else statement [Closed]
My requirement is while writing a function using if statement : In a range of cells in say: P10: P20, containing dates, I want to...
-
Require Formula [Closed]
I want to type only 1 in excel cell but require to come 100 and the same that 2 for 200, 3 for 300, 10for 1000, 50 for 5000, 100 for 10000 and so...
-
How can I add blank line to the record using macro [Closed]
Hi There, I am having difficulties with macro, I would like to have macro which checks the records in each row and if they do not match than it...
-
Returning Text from Excel [Closed]
I have customer names located in Column B Rows 12-56; I have dates that they returned letters to me in column J rows 12-56. My question is...
-
how to auto copy/past info from one cell . [Closed]
Hi , I am trying to create a sheet that when i press a name it will ask me to where i want to copy it in a different sheet. For example If i...
-
Transfer data between sheets in excel [Closed]
I currently have a sheet that sorts my data by customer, such as Part#, Qty ordered, Qty Shipped, Due date and so on. I would like to be able to...
-
Script :Scan Excel Sheet for Validity Date & Send Reminder Mails [Closed]
Hello, I have a training manager in Excel that has different training records of about 100 employees. Each training has a certain validity....
-
Excel IF argument [Closed]
Dear All, I'm trying to use IF argument in a excel document for a calculation. But it is not working. I'm using more than 8 IF argument. My...
-
How to move data to different sheets [Closed]
I need to enter data into several different sheets and then would like some of the data to transfer automatic to a log sheet so I can then sort...
-
moving data from rows into columns for every [Solved/Closed]
Hello, I have data in a single column and would like to transpose it into a row for every three rows with a space delimiter, for example; The...
-
Transfer data from one workbook to another. [Closed]
Hello, I am having a problem with the getting the form to transfer data. The post previously placed on this forum is not resolved. Please help...
-
Excel VBA [Closed]
Hi, I have a VBA data entry user form where in 200 people will be updating it and updating different excel sheets and will be saving it. All...
-
copy rows with date as criteria [Closed]
Hi i have a workbook with 3 sheets. sheet 2 has data that changes constantly and column A has the date entered when the change was made. sheet...
-
Macro to sort worksheets by a value in a cell, least to greatest [Closed]
I need a macro to sort my worksheets by the value in their cell "J65", least to greatest. The formula in cell "J65" is: =Sum(J35-H62). It is a...
-
how to check replicated data [Closed]
Hello, I have a set of data ranging from column A to AW. They are shown in several sheets and there are 289 items in each sheet. Since the...
-
Change Cell Data by Format Conditioning [Closed]
I need to how to used format conditioning to change a cell's data Example If Cell A1 = "F", then A3 background is Green (this is normal Format...
-
Combine Multiple Rows into One Row [Closed]
Hello, I am in need of major help with a large spreadsheet that have over 500 rows. I need to take multiple rows and combine them into one...
-
Comparing columns [Closed]
I have a list of 77 names in column B and need to compare them to a list of 156 names in Column C- My objective is to determine if any names in...
-
Excel Macro: combine selected rows [Solved/Closed]
Hello, I have source data in Excel looking like this: CustomerID SalesMonth SalesAmount 12345 Jan ...
-
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...
-
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...
-
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...
-
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...
-
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...
-
Combine rows using condition [Closed]
Hi, I Have spreadsheet like this: Col A Col B...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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? ...
-
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...
-
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....
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
