Excel Forum
-
Compare two price guide. [Closed]
Hello, So i am looking for an ongoing updated answer. Every 3 months we receive a new price list from our suppliers. Column A is an item number that...
-
Transfering the numbers with some calculations inside [Closed]
Dear, i want to reformulate some data from an excel sheet to another with other columns titles. the order of the rows are different also. i added ...
-
how can I filter data from two work sheets by matching values [Closed]
Hello, I have two Excel sheets. I want to copy name and address on D and E columns of sheet 1 from sheet 2 if both sex and age match.The first one h...
-
ICON SETS in Excel [Closed]
Hi, How to create icon sets K Column. how to create formula for icon sets ("K" COLUMN). I want Icon sets Green, Yellow, ReD.
-
Transferring data between sheets using macros [Closed]
Hello, I am having difficulty getting this to work. My original intention was to use a For Loop with an If check, but here is what I am trying to ...
-
ICON SETS [Closed]
Hi, How to create icon sets K Column. how to create formula for icon sets ("K" COLUMN). I want Icon sets Green, Yellow, ReD.
-
100-1=99 then 99+1=100 [Closed]
Hello, Good day. I want to ask something because i can't do this on my own. i want to minus D18 - D21 = H20 (100-1=99) ...
-
UCopy the data from Sheet1 to one Master file in to Diff sheets. [Closed]
Hi, My first question ! Ok. I am trying to find a macro which can help me in coping the entire Sheet1 from one work book and copy it to another ...
-
MACRO to COPY DATA from Master Worksheet to new sheets [Closed]
Hello, I hope everybody here are doing fine! Please, if anyone could help me with a macro for one of my Master reports. I don't really know muc...
-
change date format in excel 2007 [Closed]
Hello, I want to change date format in excel 2007 as given below please help me. now it is 09/01/2015 but i need (ddd mmm yyy 01/09/2015) like ...
-
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...
