Excel Forum
-
How to create auto populating multiple sheets based on cell [Closed]
Hello, I'm currently creating a building condition assessment form. I would like to know how to create auto populating multiple sheets once I sele...
-
custom sorting & calculating average based position [Solved/Closed]
please help me with this. i want to get the position based on average. but when i put all these in a table, all are getting jammed. please can u h...
-
Extracting Data of new Entries to another Sheet or Workbook [Closed]
Hello, I currently have a large matrix of data that I use to index work with a lot of categories. I would like to create some metrics based on t...
-
search word from list, match it copy values next to it [Solved/Closed]
I have a list of product part numbers in one excel document. Now I need to pull the description and pricing from another document which is attached in...
-
Sum value of one column if in another column there is a text [Closed]
Hello, I am trying to sum values in column A if in column B there is a certain number. So, Column A 10 20 30 40 50 Column B E45D...
-
If cell have specific text it give us alert message [Closed]
Hello, If cell have specific text it give us alert message Configuration: Windows XP / Chrome 44.0.2403.157
-
how to get the database values in excel ? [Closed]
Hello, pls give me one solution Configuration: Windows 7 / Chrome 44.0.2403.157
-
Extract the number A1-A10 like a A1,A2,A3,A4,A5,A6,A7,A8,A9,A10 [Closed]
Dear Team, I Need extract the Number like a below in excel sheet Cell A1 have a character is "A1-A10" Cell B1 need to extract A1,A2,A3,A4,A5,A6...
-
Transpose data in single column into 4 columns [Closed]
Hello, I have data in a single column and would like to transpose it into a row for every 4 rows. I have about 7000 rows in the 1 column. I'd l...
-
Compare 2 columns choose answer in third [Closed]
Hi all, First of all thank you for reviewing this. I have a data dump from a survey. Column A shows the survey #. On other sheet (sheet1) I have...
-
Macro-Copy data from one workbook to another [Closed]
All, I need to copy data from one workbook and append the content to another workbook (WB). Ex: WB1 (source) has 1 2 3 4 5 WB2 (target) al...
-
A macro to change the values on a specified cell [Closed]
Hello, I am searching a macro code on excel to set a value on a cell that is found by using such an excel function =ADDRESS(MATCH(N7,'Sheet1'!...
-
Copying 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 informatio...
-
amount in words Excel formula [Closed]
Hello, kindly guide me how this formula apply in excel for amount converted in words plz guide me plz help me reply on this id ***@*** Confi...
-
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 ...
Subscribe To Our Newsletter!
DON'T MISS
- Computer Boots to Black Screen
- How to Install a VPN
- 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 Get More Followers on Instagram
- How to Disabled Write Protection on a USB
- How to Upload High Quality Photos to Instagram
- How to Fix a Blurry Snapchat Video
- How to Recover Your Yahoo Account