Excel Forum
-
Excel Macro: combine selected rows [Solved/Closed]
Hello, I have source data in Excel looking like this: CustomerID SalesMonth SalesAmount 12345 Jan 15...
-
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...
Subscribe To Our Newsletter!
DON'T MISS
- How to Upload High Quality Photos to Instagram
- Facebook Code Not Received
- How to Recover Your Yahoo Account
- Computer Boots to Black Screen
- How to Get Free Diamonds in Free Fire
- How to Recover a Disabled Facebook Account
- How to Create a Gmail Account
- How to Install a VPN
- How to Fix a Blurry Snapchat Video
- How to Get More Followers on Instagram
- How to Disabled Write Protection on a USB