Excel Forum
-
Excel - transfering information from sheet to sheet under condit [Closed]
Hello, I have one problem to solve. I have 2 work sheets in excel. In the first one I have few columns. 3 of them I want to transfer for another she...
-
Would like to Transfer Date from Sheet 1 to Sheet 2 Automaticaly [Closed]
Hello, Trying to Edit incoming data faster, would like to be able to input data lets say Sheet 1 A2 First Name B2 Last Name, then Take given informa...
-
Using IF formula for dates [Closed]
hello, i want to make a sheet for my job to track the allotments, i want it to count the days allotment sent for signature till it is back from sig...
-
Copying Cell Information (with moving filters) [Closed]
Hello, Please, please, please can I have your expert help with his matter I would like to copy + add up the numbers in the cells from a differe...
-
Grouping data in excel [Closed]
Hello, I have one excel spreadsheet with data in this form Country: UK France UK Spain Germany UK Spain France UK Germany data1: ...
-
Copying selected row from one sheet to another, [Closed]
I am trying to have Excel lookup values in Column A from Sheet A in Column B Sheet B, and then, copy entire Row (or just to the left from Column B), w...
-
Next Empty Cell [Closed]
Hello, I work at a fitness center. We have an equipment checkout system that we use Excel for. In my "Lockers" sheet, locker keys get checked out ...
-
Auto Sort New Entry [Closed]
Hi everyone! I'm sure you get asked this often but I can't find what I'm looking for on the internet so I'm asking and yes I'm a new-be! No laughi...
-
Data Validation If Then [Closed]
Hello, I have a "Yes" or "No" data validation list in cell C1 and manual input cells in D1, E1 etc. I would like to create a code that says (If C1...
-
Compare two columns in an excel [Closed]
Hello, How to compare numerical values in two columns and get their difference in an excel?
-
Need to copy data from one sheet to another [Closed]
Hello experts, I am new to excel, I have a requirement where I have multiple sheets and I need to create a master sheet..based on the surrogate ...
-
Search,compare,update,indicate data in excel sheet (macros VBA) [Closed]
Q) 1 core excel sheet with 10 to 15 thousands rows and around 150 columns. Another targeted sheet to be completed with using VBA which content same 10...
-
transposing data [Closed]
Hello! I need some help for data transposing. the data set above is the raw data and the data set at the bottom is the set I need to create. ho...
-
Help with a school Directory [Closed]
Hi all, I am creating a school directory. My columns are Last Name, First Name, Father/Mother, Phone, Email, Address, Zip, Teacher, Grade. I ha...
-
Urgent,,,custom database from one entry sheet to multiple sheets [Closed]
Hello, Thank's in advance...for helping in my problem I enter data in a sheet and based on that i print few page report that contains that variable...
-
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 informat...
-
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 worksh...
-
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 & disc...
-
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 every...
-
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 sheet ...
-
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 Twent...
-
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 (stored...
-
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 inspec...
-
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 > 1...
-
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 color, bu...
-
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 col...
-
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 prompt in...
-
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 me, b...
-
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 (A1: ...
-
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 or th...
-
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 them...
-
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. 5000+ r...
-
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 list: ...
-
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: C...
-
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 columns. ...
-
convert blank row data in colums [Closed]
Hello, how we convert blank row data in column Data Name 50 V10 V12 V3 V6 51 V1 V2 V4 V5 V7 52 V8 53 V9 55 V11 57 V13 58 ...
-
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 many r...
-
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 transpositio...
-
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, product ...
-
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 fina...
-
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 Data"...
-
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 column...
-
date range to division [Closed]
Hello, we capture birth date as date and we would like to convert to division Month/Year 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006...
-
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 do ...
-
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 sheet 1...
-
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 in w...
-
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 exa...
-
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 the co...
-
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 anoth...
-
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 1 ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Install a VPN
- How to Upload High Quality Photos to Instagram
- How to Create a Gmail Account
- Computer Boots to Black Screen
- Facebook Code Not Received
- How to Disabled Write Protection on a USB
- How to Fix a Blurry Snapchat Video
- How to Recover a Disabled Facebook Account
- How to Get More Followers on Instagram
- How to Get Free Diamonds in Free Fire
- How to Recover Your Yahoo Account