Excel Forum
-
Please help in getting data clubbed in one cell Solved/Closed
Please inform how to get the following information clubbed in a row Data as follows Required data in a ...
-
master sheet to work sheet, Solved/Closed
I have been getting help at this site and I am not able to get into my messages to respond anymore. I am not sure if it is just a work computer issue ...
-
Macro to Copy Data From Multiple Sheets onto Single Sheet Closed
Hello, I have multiple sheets that contain basically identical data and I am trying to extract certain parts and place it onto a single sheet. The ...
-
vb averaging random fields in Excel 2007 Closed
Thanks very much for help on this . . After finding a row based on a field value, I need to get the value from a different field in that row . . ....
-
using partial text in a field, color the row Closed
Thanks for help on this . . . Using the last 2 characters in a string in field GFi, color that row . . next row Example: for all rows with...
-
Accounts data requires automatic analysis Solved/Closed
Five columns headed Value, Type, Food, Household, Medical. The data is in Value and Type listed alongside each other. I wish to have those transfer...
-
how to autogenerate a new daily report Closed
I have a daily report made up in Excel containing daily (manually entered) data, and "to date" (computed in Excel) data. I would like to be able to...
-
how to get data from another sheet in many rows? Closed
Hello, Im helping my dad out with some office software of his. so im basically trying to make it in excel. There's a monthly sheet and a daily sheet...
-
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...