Excel Forum
-
How to enter a row when an "if condition" is met [Closed]
Hello, Would like to know how to add a row in a different sheet when an "if condition" is met. To illustrate, I have the following columsn...
-
compare two sheets and highlight the difference [Closed]
Hello, In sheet 1 i have some 10 rows in sorted order for eg say like it has two Sheet 1 Name Age Sam 9 Teena 10 Sheet...
-
Compare Worksheets return third result [Closed]
I Have two worksheets a) Warehouses Combined - this list all codes a to z b) Suppliers - list all suppliers with discount per...
-
Populating companies sheets from mastersheet [Closed]
Hello, Could someone help please. I have a excel file with a master sheet which contains invoice companies. The are alphabetical...
-
Transferring data between sheets with conditions [Closed]
Hello, I have a daily driver routing excel sheet that has driver fees. The sheet is for the month listed daily. I am trying to figure out how...
-
assigning values to a row [Closed]
Hello, I have a row with descriptions in the adjacent cell for example a1 sam b1 happy a2 Jessica b2 sad a3 max b3 angry then in row...
-
fetch data [Solved/Closed]
fist sheet Leader id Brand Status product S001 Maruti complete Maruti 800 s002 Toyota complete xyz s003 Maruti complete swift...
-
Need to find end row in Col which has data & format the col [Closed]
Need to check when the row is finished - by checking whether data is there in the cell or not and format entire column. Example Col A.. has data...
-
Comparing 3 columns [Closed]
Hello, Please help me get the correct formula for this: RETURN RED IF D1 lower than D2 and lower than D3 ...
-
how to populate data from master sheet to different sheets [Closed]
Hello, Configuration: Windows XP / Chrome 44.0.2403.130 i have a master sheet Q and i want to auto populate some companies name of sheet...
-
Comparing two columns [Closed]
Hello, I want to know the formula for the below If column A is having list of cities eg Chennai and column b is having list with extension...
-
Problem in comparing rows [Closed]
Hello, I want to compare two adjacent rows and highlight the difference; then I want to apply this to entire worksheet so that all adjacent...
-
multiple if and functoions [Closed]
Hello, I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the...
-
Conditional formatting [Closed]
Hello, I need dates to be highlighted if over 6 months but to clear again if marked Y (completed) in another cell? I can obviously get the 6...
-
Find text and add two different texts next to cell [Closed]
Hello, I have a sheet with contractor names(sheet1) on A1 and I have a separate sheet (sheet2) with contractor names (A1), personnel assigned...
-
Percentage [Closed]
Hello, I have Rs. 1.3 million divided to 35 peoples. Sô you can help me, i mean 1st prize is high, 2nd low prize, 3rd is more low. Please guide...
-
Conditional Format Restrictions [Closed]
Hi. Need a little help with conditional formatting. Basically need to build in a excel spreadsheet a rule where conditoinal formatting will...
-
Conditional formatting based text in another cell [Closed]
Hello, I want to conditionally format the cells in one column (in my case) D, if the cell in the same row but in column K contains one...
-
Creating New Spreadsheet based on column - Macro Help! [Closed]
Hello, This is my first time trying to use a Macro, so please bear with me. Anywho, I am using Excel 2007, if that helps. I have a...
-
Match cells in which only certain strings of text are the equal [Closed]
Hi everyone, I'm trying to find a way to use excel to match two columns of information. The problem is that those two columns do not contain...
-
Matching cells in which only certain strings of text are equal [Closed]
Hi everyone, I'm trying to find a way to use excel to match two columns of information. The problem is that those two columns do not contain...
-
Inporting images from folder to excel using a cell as reference [Closed]
Hello, I'm trying to produce an excel sheet where I display several images present on a specific folder in my computer. I'll have a...
-
Date formate in formula bar [Closed]
hi Tried to change the date format in the formula bar but its not taking for ex: 29/05/2015 is showing as MM/DD/YYYY in formula bar but in sheet...
-
Help with returning multiple values [Closed]
Hi, I have 3 columns in Excel. I need to search value from Column A in Column B and return value from Column C. For example I need to find...
-
looking up and adding the values fixing different criteria [Closed]
Hello, "A column" the name of items such as Tiles, Pipes, Tables etc (many times repeated) "B Column" the size of each item such as 10mm, 20mm,...
-
Comparing two columns with string [Closed]
I have two columns :A (shorter list) and B (longer list). Is there a way to find all instances of B which may have any string from A? For...
-
school [Closed]
Hello, Configuration: Windows 7 / Chrome 44.0.2403.125 if u enter new admit for a student i want a userform then click the insert...
-
Transfer from one worksheet to another with a codition [Closed]
Hello, all i have question I'm trying to populate a work book in order to organized my warehouse. on the first sheet i have 6 columns with the...
-
change vba code for unlimited next loop [Closed]
Hi, i have vba code that calculate 3 sheet data and paste in dashboard sheet with different row, now what i need to update next loop for...
-
Need to add next loop in code [Closed]
Thanks for this. i have little bit issue if you solve this Here is code, as you see i repeat code for next row and sheet calculation. i just...
-
Can I use a macro to copy information from one sheet to another [Closed]
Hello, I have an excel workbook that has a Master Job spreadsheet, Current Job spreadsheet and sheets A-Z that I use to track jobs by job...
-
Inserting Number of Rows based on Cell Value [Closed]
Hello, I have two sheets that I am working with. Sheet two only has one column of information, each row containing a different numerical...
-
disable a cell based on another cell value [Closed]
Hello, I'm very new to VB. I have a worksheet with muliple values that get manually input. But with Column D and E they can only enter one or...
-
Need VBA code to create loops Please [Solved/Closed]
I have done loops before but it has been a long time. I need to loop through rows of data and the rows of data changes. The value in column "N"...
-
short macro code and will be continue next row and sheet [Closed]
Hi Everyone, i have macro code that calculate excel sheets and paste answer in dashboard row, each new excel sheet data paste in new row after...
-
Need help copying to another tab . . [Closed]
Hello, I need to copy a row (multiple rows) if a cell in that row contains certain text. For example if C12 contains the word "expense" I need...
-
Common Part Numbers on BOM [Closed]
I have many many worksheets within an Excel file. Each one contains a list of components used to make a final product (assembly). This is called a...
-
Need to compare first 3 letters to all cells in the same column [Closed]
Help! I am trying to see if there are similar email addresses in column 1 rows, and I need to compare it to column two rows to see if the first 3...
-
vba [Solved/Closed]
I want to append the month name at the end of the tab names in my workbook I have 86 tabs which are named by employee name and every month I want...
-
Macros or Formula? [Closed]
I have a report to run for work each week. Simply said, I obtain the raw data and need to sort and filter it based on a certain criteria. Then I...
-
Excel macro to create multiple files from one file [Closed]
I have one excel raw data file. in that i have lots of country name from which i have to select data by country in new excel file means i have to...
-
Auto populate child sheet rows from Master Sheet Column ref [Closed]
Software Version: Microsoft Office Excel 2010 I have a Master sheet with all entered data for a Charitable Institution Exhibition. There are...
-
Formatting cells [Solved/Closed]
I'm stuck.... I am creating an invoice of sorts for a company who deals in different currencies. Q1. I have created a drop down list of all...
-
Cutting last 10 charecters of a cell and pasting to next cell [Solved/Closed]
Hi Guys - Im back again with another excel macro problem. I can find all sorts of advice when I google this, but none of it quite matches my needs...
-
Conditional formatting where 2 statements are met [Closed]
Hello, I'm trying to use conditional formatting in excel 2010 where if the data in column D is 'In Progress' and the data in column N is a %...
-
Filtering Error in Excel Online Pivot Tables [Closed]
Hello, In an Excel Workbook created with an online Excel Survey, I've suddenly begun getting the following error message, even when I have one...
-
Prepare summary sheet order by items from variuos sheets in work [Closed]
Hello, I need to prepare a consolidated summary sheet .(Basically Timesheet) The description of the summary sheet as below. 1. A master...
-
Need corresponding hourly values (24per day) daily from multiple [Closed]
I need a formula which will select data automatically from raw data sheet considering to near by (Corresponding) every hour duration. There should...
-
Search using formula [Closed]
I have around 10 sheets in excel say sheet name as 1 , 2 , 3 ..... I wanted to search a word in specific sheet and get the Number from the next...
-
spell currency [Closed]
hi i am using spell-currency function because i use to change ,Add, etc the numeric data it helps me in my work.but i need the same in my...
