Excel Forum
-
Copying to cell information [Closed]
Hello, I would like to copy + add up the numbers in the cells. However when I change the filters, the numbers brought through change. The...
-
Enable Macro Security Via Macro Or automatically [Closed]
Hello, Dear Friends i m not good in english so sorry in advance for bad english. but i need to enable macro automatically when...
-
Transfer data from multiple sheets to sheet 1 based on criteria [Closed]
Hello, I am creating an estimating workbook where I have multiple product sheets that list qty, part#, description, volume, lbs, list price &...
-
Creating custom database from one entry sheet to multiple sheets [Closed]
Hello. I enter data in a sheet and based on that i print few page report that contains that variable data I want to some extra work so that...
-
Pop up setting [Closed]
Hello, I have got two excel sheets one master sheet that gets updated everymonth with the new employees joining that month. In the second...
-
convert date to English words [Closed]
Hello, Hello i want to know how to convert date into words(english) in excel 2003, 2007 or 2010 for eg. 22.04.2010 - convert it into...
-
Concatonating within commands??? [Solved/Closed]
Ok - I know I said no more scripting, but ... Im still with Excel (VBA) macros and trying to find a way of inputting data from a html sheet...
-
Automatically populating master excel sheet from other files [Closed]
Hi, I am fairly new to Excel, especially when it comes to macros. I will be having a lot of files saved in a particular folder that contain...
-
why the type mismatch error? [Closed]
My question is in the comment in the code: Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next If Target.Cells.Count...
-
format row based on text length [Closed]
Hello guys, Can you pls help me? I am beginner in VBA and I need to sort out one macro. I have table and need to have highlited row with...
-
using if condition with date function [Closed]
Hello, Sir, i am using if condition with date function. my question is that I have two date in two column. dates are different. if 1st date...
-
Step by Step Instructions [Closed]
Hi everyone: Following policies is a difficult thing because it is open to interpretation. I was wondering if it is possible to create a...
-
get month name and year from date [Closed]
Hello, how do I can convert the date in to month name and year ex. 01/05/2015 , I want to get month name as May and year 2015 pls help...
-
Copy & paste Data and increment to next cell having data [Closed]
Hello, Configuration: Windows 7 / Internet Explorer 7.0 I am new to Excel Macros. I situation is I have a sheet with 40000 rows range...
-
Change date automatically on the sheets [Closed]
Hello, I have a document in Excel, and has 5 different pages; all of them have the date on top. I need to know, how I can set up the formula...
-
VBA Copy Issue [Closed]
Hello, I have written the following code which creates a variable # of additional sheets in my workbook based on how many rows have names in...
-
Data Validation dependant lists, Excel 2010 [Closed]
Hello, I am in need of a way to create a order form from a table (product list) using Data Validation. The table is 8 columns and aprox....
-
Help MSB (microsoft visual basic) code for an Excel Macro button [Closed]
Hello, I am trying to create a macro to help the input in a complex excel file. I have created several dropdown menues to choose from a...
-
Comparing columns and returning value [Solved/Closed]
Hello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: ...
-
search,compare,update,indicate data in excel sheet (macros VBA) [Closed]
search, compare, update and indicate data in excel sheet with macros VBA Q) 1 core excel sheet with 10 to 15 thousands rows and around 150...
-
convert blank row data in colums [Closed]
Hello, how we convert blank row data in column...
-
Auto update data from one sheet to other sheet [Closed]
Hello, I would be very grateful if some one help me this issue! I have two sheets with similar format. In the first sheet, I will input...
-
data transposition [Closed]
Hello? I need to transpose my data and need some help. First picture is an example of my raw data and the second one is the data after...
-
beginner in VBA. I have following problem statement [Closed]
Hello, I am a beginner in VBA. I have following problem statement: I have a workbook i.e WB1 which is having a unique id in A column,...
-
Financial tracking made easy - I hope! [Closed]
Hello, I am trying to develop a finanical transactions tracking worksheet. I want to reduce the amount of data entry so Im downloading my...
-
Word "False" kept on Appearing? =IF function [Solved/Closed]
=IF(ISNUMBER(A1),IF(ISNUMBER(B1),IF(ISNUMBER(C1),IF(AND(A1,B1,C1),SUM(A1,B1,C1),"Incomplete Data")))) How is it happen that I put "Incomplete...
-
conditional formatting [Closed]
Hello, I'm trying to write a conditional format formula populating one cell (column of cells) based on the text content of cells in 2 other...
-
date range to division [Closed]
Hello, we capture birth date as date and we would like to convert to division Month/Year ...
-
sumproduct based on relative cell [Solved/Closed]
Hello, I can use sumproduct based on information contained in the same range of rows of a column adjacent to it, but I can't figure out how to...
-
Macro to copy data from one sheet to another with >1 variable [Closed]
Hello, I have been using macros to copy data from one sheet to another without issue, until my data has become a little more complex. I have...
-
Updating values automatically [Closed]
Hello, I have an issue. I have 2 workbooks. I need to copy data from one work book to other workbook dynamically. That is if a value is changed...
-
Conditionally format cells based on text contained in other cell [Closed]
Hi - I am running Microsoft Excel for Mac 2011 and want to conditionally format an array of cells based on the text contained in another cell. For...
-
Macro to autogenerate sheets based on unique values of a list [Closed]
Hello! I would greatly appreciate if anyone could help me with a macro. I have a number of populated rows in one sheet (Sheet A) and one of...
-
copies and saved in a different column [Closed]
Hello, can you guys help me with this. I want to input a data in cell A1, then it automatically copied into cell B1. then if I input again...
-
copy row from sheet 1 to sheet 2 with formula [Closed]
Hello, i need to copy a row from one sheet to another with formula and keep updating the data in sheet 2 every time i change the data in sheet...
-
vba for copy from sheet 1(form) then paste to sheet 2(database) [Closed]
Hello, newbie here. Please help me by giving a vba that could automatically make a database. I have a form(sheet1) detailed with various...
-
stack range of data to next empty row in other sheet [Solved/Closed]
Hello, I have a set of data in Sheet1 Range("D24:D50") and Range("AC24:AC50") would like to be copied and paste special value to Sheet2 Column...
-
Macro that kills a macro when a new workbook is opened. [Solved/Closed]
Hi All, I am still new at excel macros. I am using a command button to copy all work sheets in a workbook then pasting just the values into a...
-
Comparing 2 worksheets & extracting matched and unmatched data. [Closed]
Hey guys, I'm trying to compare one column in a worksheet with another column in another worksheet and also at the same time, extract matched...
-
convert text paragraph to excel columns [Closed]
Hello, i have few pdf files that needed to be entered to excel columns. i have worked on a html software at my last work that could convert it...
-
If Or famula for finding word in a sentance [Closed]
Hello, Can anybody help to find ans for below question if sentances are " HEDgroup people are in bench" "evals making count" "nothing in...
-
Nested If statement... [Closed]
Hello, Can anyone find any errors with this formula. I know it will never return a "N" because the vlookup will terminate anything that...
-
auto fill [Closed]
Hello, im looking for a formula when i add a"XXXX" word to a cell K7 it takes the value of another F7 and auto populates to another H7. so...
-
Excel, how to use macros and conditioning. [Solved/Closed]
Hello, I have been looking up how to use excel to help sort data but ran into a few problems. First I have searched how to delete a row with...
-
Microsoft Excel Conditional Formatting [Closed]
Hi, I'm trying to make a cell display a number based whether or not another cell contains the words, "Sentinel", "Ramsden", "Goulding", or...
-
Input Mask [Closed]
Dear Sir/Maddom. Hope to be fine and doing well. first of all i am thanks from your services in the filed of IT. I am working in Telecom...
-
Transfer Comments [Closed]
Hello, Is it possible to transfer comments from one cell to another on a different sheet or workbook? I am able to transfer the contents of...
-
Using 'rept' inside 'If' [Solved/Closed]
Hello, i want to do a rating..example.. Artist Rating(numerical) Rating(graphical) akon ...
-
Conditional formatting dates [Closed]
I have three date columns in a sheet, order date, approved date and received date. I want the ordered date to be green but going red if not...
-
date formula [Solved/Closed]
Hello, Can someone please create a formula for these numbers to change to a date. 152030355A, the answer should be 7/22/2015. The first...
