Excel Forum
-
Help Please For Auto Fill [Closed]
Hello, Hi I have one sheet with 100 row and every row have 3 cell i want crate auto sheet with copy in first sheet set a1 from row 1 cell 1 a2 c...
-
Function has too many arguments... [Solved/Closed]
Why is excel telling me that this formula has too many arguments? =IF(TODAY()>=B9+15,"PAY NOW","HOLD",IF(u9="PAID","PAID")) I am stationed on ...
-
Search for multiple substrings and return different values [Solved/Closed]
I have a cell I2 which contains long string. I want to find out the following: If string in I2 contains "month", then return "Monthly", If string ...
-
Need help with data sorting [Closed]
I have 2 columns , one which contains values ( the invoice amount) i send.. The other column will have another list of values ( funds credited to me)....
-
Search for multiple substrings and return different values [Closed]
I have a cell I2 which contains long string. I want to find out the following: If string in I2 contains "month", then return "Monthly", If string in...
-
Spreadsheet Data [Closed]
Hello, I would like to know how to set up a formula so when I enter a certain value or text into a cell i.e "C" all of the information in that row ...
-
If condition [Closed]
Hi I need to do use IF condition for multiple cell check in a column E.g, of my data as below . I need the answer in Column Z like if the data ...
-
comparing sheets [Closed]
Hello, I need help comparing data in Excel 2007. Here is the situation, I'm using an aging report and in sheet 1 column A I have the invoice numbe...
-
Filers [Closed]
Hello, I added filters to my excel spreadsheet and saved, however, when other people open it sometimes the filters are no longer there. What could ...
-
Deleting tables with macros [Closed]
Hello, I've got a long dataset. At some point in the sheet there are tales that start with a row with a text in the first cell "Please specify"...
-
Data storing by click. [Closed]
Hello, I'm working on excel which has assembly numbers. I've assembly names and corresponding numbers by side for each assembling we do. I'm looking...
-
Creating a macro that does not copy amount of rows from file [Closed]
Hello, I am trying to create a macro that does NOT copy the amount of rows in the file the macro was recorded in. For example: The macro is sp...
-
Formula for correction [Closed]
Hello, The date is 12-July-2015 but in Excel the same is showing as 7-Dec-15 please suggest for the correction Configuration: Windows / Chro...
-
SUMIFS function [Closed]
Hello, I am trying to sort the formula below =SUMIFS(Sheet3!$AI$15:$AY$22,Sheet3!$B$15:$B$22,$A142,Sheet3!$AI$4:$AY$4,D$2) the criteria_rang...
-
Clicking data in one sheet..Saving all those clicked in another. [Solved/Closed]
Hello, I'm working on excel which has names(Col A) numbers (Col B). I'm looking to create a sheet, who by clicking on the number, stores the number ...
-
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...
-
Creating new sheet when got into some event [Closed]
Please help me built macro like this : When i write name at "C7" and pressing Enter Button it will create new Sheet with the C7.Value.And it will d...
-
Same Date in Column A on Mutiple Lines in seperate worksheets [Solved/Closed]
Hi, Not using FILL with copy/paste....Is there a way to create a date range in Column A (IE: 9/1/15) from line 1 going downward when entering multi...
-
Require macro to convert horizonatal to vertical [Closed]
hey this is my data ITEM DSA SUL SBM SAN RIF RAM ISM BCC ENM 220 PDB till 163 + 262004189001 7 3 6 3 3 3 3 3 3 3 0 262004189002 6 3 6 3 3 3 3 ...
-
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...
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover a Disabled Facebook Account
- Facebook Code Not Received
- How to Disabled Write Protection on a USB
- Computer Boots to Black Screen
- How to Create a Gmail Account
- How to Get More Followers on Instagram
- How to Get Free Diamonds in Free Fire
- How to Upload High Quality Photos to Instagram
- How to Install a VPN
- How to Recover Your Yahoo Account
- How to Fix a Blurry Snapchat Video