Excel Forum
-
Excel Logic [Closed]
Hello, I am trying to create a worksheet in excel that will allow me to add a certain amount if 2 conditions are met. So far I can only get it to a...
-
Insert row in excel by criteria [Closed]
Hello, Configuration: Windows XP / Firefox 10.0.2 I want to insert row in excel using formula because i have dates in the and there is da...
-
Copying value to another worksheet [Closed]
Hello, I am trying to copy a value for from one worksheet, do some math --> say I have three values that I want to subtract separately from cell i...
-
Excel conditional formatting row color [Closed]
Hello, Column A indicates what type of transaction I've made (ie POS/ATM/CASH/Bill Pay) Column D is the date the transaction has cleared my bank. ...
-
Excel Macro - Create new files from ranges [Closed]
Hi. I am trying to create a macro that will create new excel files for ranges of rows in a worksheet. I want to copy the range F5:S61 and paste i...
-
Enter sheet update other worksheet with text [Closed]
Hello, Can anyone help me with this problem. I am updating leave availability , As soon as I enter the name in one worksheet the other workshee...
-
How to determine cell value in Excel column [Solved/Closed]
Hello, Sorry the title is really vague, it's hard to describe with a limited number of characters. I have a column (C) which contains a full li...
-
Macro - Sort Range Error [Closed]
Hello, I've created a Macro within Excel that is supposed to Delete, Formulate and Sort data.. I've managed to get the Macro to the point where it...
-
Worksheet_Change from a data validation list [Closed]
Hello, I want my pivots to rebuilt when a value in range("Book_Select") is changed. This range is a drop down data valiation list. What is wrong w...
-
Comparing values of 1 excel cell with column [Closed]
Hello, Please can you assist me with this excel formula? In sheet 1 I have business rules specified in column A and all the requirements that exe...
-
Excel Macro [Solved/Closed]
Hello, I wonder if anyone can help me with a small (I think) problem, please? I'm trying to write a macro to manipulate a spreadsheet sent to m...
-
Pull data from one tab/sheet to another [Closed]
Hello, Configuration: Windows Vista / Internet Explorer 9.0 Reading all of these posts I get a lot of ideas, but since I am a novice at this ...
-
Hide rows without conditional formatting [Closed]
Hello, I'm creating an Excel spreadsheet and want to give it a cleaner look by hiding the contents of a row based on the value of a cell in that ro...
-
Macro Help [Closed]
Hello, I am new to VB and Excel. I've got the following code: I've got everything working fine, but need the entire row to change colors...
-
Excel search and save problem [Closed]
Hello, I'm a total Excel noobie so I hope you can help me, I will try and be as brief as posible. Each week I will be getting an Excel CSV of 4...
-
Excel Copying Columns [Closed]
Hello, I have a spreadsheet for labor hours - Reg & OT columns per employee for 26 pay periods. I have the spreadsheet sorted by employee. Each ...
-
How to make secondary cells color of primary [Closed]
Hello, Is there a way to make cells automaticaly change to the color I chose for another? Example: I decide to make cell A1 red. When I do this ...
-
filter-cut-paste to other sheet [Closed]
Hello, Could you please help me on this one, i have a data sheet and i want to filter then cut the data if the criteria is met (Adhoc,Chaser,Excep...
-
compare cell a1 to entire A col in sheet2 [Solved/Closed]
Hello, I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to ...
-
Excel problem [Solved/Closed]
Hello, Hello, I am hoping that someone can help with the following problem, I have a list of numbers, golf staplford scores, located in cell...
-
Macros and histograms [Closed]
Hello, I want to create a histogram on sheet2 while the data required is on sheet1 using a macro. everytime I try, it either says no data availabl...
-
Excel - copy data macro [Solved/Closed]
Hello, I am currently learning the tricks in excel but have become stuck. I have created an expenses sheet where employees record various expenses...
-
transfer value between cells [Closed]
Hello, i am maintaining attendance on daily basis per day per sheet. but sheet 1 contains only number of present on that day. how to auto up...
-
excel question [Closed]
Hello, I am trying to find out how to get the following working, I have a list of numbers located in cells D-AN, these random numbers are loaded we...
-
Excel Macro-Pasting on next available row [Closed]
Hello, I am having issues with my macro, I hope someone can help. I have a list, where I would like the macro to see if the value in Column J "Paid...
-
read data from one excel and write to other [Closed]
Hello, I am a newbie. I am trying to find out if we can achieve the below scenario using macros. We have 2 excels in our case. Excel1 contain...
-
Copy the data from this sheet to other sheet [Closed]
Hello, I have a problem about macro excel as: I have the data in file excel: Exam: Vendor account Date Invoice Due date Amount c...
-
Convert rows to cols [Closed]
Hello, I have an example as below A cac 20 A dwp 22 B cac 15 B dwp 22 B erp 20 I want output as A CAC 20 DWP 22 B ...
-
Conditional Formatting Based on 2 cells [Closed]
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 [Closed]
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...
-
how to move data in rows to columns [Solved/Closed]
The 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 [Solved/Closed]
Hello, 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...
-
VBA code in excel to work for many sheets [Closed]
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...
-
Copy data from one sheet to a master sheet [Closed]
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 [Closed]
Hello, 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 [Closed]
Hello, 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...
-
Excel: Populate data based on criteria [Solved/Closed]
Hello, 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 [Solved/Closed]
hello, 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 [Solved/Closed]
Dear 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...
-
Excel HELP [Solved/Closed]
Hello, 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 [Closed]
Hello, 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 ...
-
Delete rows that don't match another data set [Closed]
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...
-
Excel [Solved/Closed]
Hello, 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...
-
VBA Code to copy row based on dates [Closed]
Hello, 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...
-
VBA code in excel [Solved/Closed]
Dears 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...
-
Compare 7 colums of data in 17 worksheets [Closed]
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? [Closed]
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 [Closed]
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...
-
Macro or VB in Excel 2007 [Solved/Closed]
Hi. 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...
-
To get cell contents into Excel file property [Solved/Closed]
Hello, 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 ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover Your Yahoo Account
- How to Get Free Diamonds in Free Fire
- How to Recover a Disabled Facebook Account
- How to Create a Gmail Account
- Facebook Code Not Received
- How to Fix a Blurry Snapchat Video
- How to Get More Followers on Instagram
- How to Upload High Quality Photos to Instagram
- Computer Boots to Black Screen
- How to Install a VPN
- How to Disabled Write Protection on a USB