Excel Forum
-
Macro to autogenerate sheets based on unique values of a list [Closed]
Hello! I would greatly appreciate if anyone could help me with a macro. I have a number of populated rows in one sheet (Sheet A) and one of the co...
-
copies and saved in a different column [Closed]
Hello, can you guys help me with this. I want to input a data in cell A1, then it automatically copied into cell B1. then if I input again anoth...
-
copy row from sheet 1 to sheet 2 with formula [Closed]
Hello, i need to copy a row from one sheet to another with formula and keep updating the data in sheet 2 every time i change the data in sheet 1 ...
-
vba for copy from sheet 1(form) then paste to sheet 2(database) [Closed]
Hello, newbie here. Please help me by giving a vba that could automatically make a database. I have a form(sheet1) detailed with various inf...
-
stack range of data to next empty row in other sheet [Solved/Closed]
Hello, I have a set of data in Sheet1 Range("D24:D50") and Range("AC24:AC50") would like to be copied and paste special value to Sheet2 Column A a...
-
Macro that kills a macro when a new workbook is opened. [Solved/Closed]
Hi All, I am still new at excel macros. I am using a command button to copy all work sheets in a workbook then pasting just the values into a new w...
-
Comparing 2 worksheets & extracting matched and unmatched data. [Closed]
Hey guys, I'm trying to compare one column in a worksheet with another column in another worksheet and also at the same time, extract matched value...
-
convert text paragraph to excel columns [Closed]
Hello, i have few pdf files that needed to be entered to excel columns. i have worked on a html software at my last work that could convert it to ...
-
If Or famula for finding word in a sentance [Closed]
Hello, Can anybody help to find ans for below question if sentances are " HEDgroup people are in bench" "evals making count" "nothing in MIL" ...
-
Nested If statement... [Closed]
Hello, Can anyone find any errors with this formula. I know it will never return a "N" because the vlookup will terminate anything that doesn't m...
-
auto fill [Closed]
Hello, im looking for a formula when i add a"XXXX" word to a cell K7 it takes the value of another F7 and auto populates to another H7. so "WOR...
-
Excel, how to use macros and conditioning. [Solved/Closed]
Hello, I have been looking up how to use excel to help sort data but ran into a few problems. First I have searched how to delete a row with certain...
-
Microsoft Excel Conditional Formatting [Closed]
Hi, I'm trying to make a cell display a number based whether or not another cell contains the words, "Sentinel", "Ramsden", "Goulding", or "Riverda...
-
Input Mask [Closed]
Dear Sir/Maddom. Hope to be fine and doing well. first of all i am thanks from your services in the filed of IT. I am working in Telecom Comp...
-
Transfer Comments [Closed]
Hello, Is it possible to transfer comments from one cell to another on a different sheet or workbook? I am able to transfer the contents of the ce...
-
Using 'rept' inside 'If' [Solved/Closed]
Hello, i want to do a rating..example.. Artist Rating(numerical) Rating(graphical) akon ...
-
Conditional formatting dates [Closed]
I have three date columns in a sheet, order date, approved date and received date. I want the ordered date to be green but going red if not approved ...
-
date formula [Solved/Closed]
Hello, Can someone please create a formula for these numbers to change to a date. 152030355A, the answer should be 7/22/2015. The first two nu...
-
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 in s...
-
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 2 Nam...
-
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 supplier. Warehouse...
-
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 ordered. Bu...
-
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 to e...
-
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 c it...
-
fetch data [Solved/Closed]
fist sheet Leader id Brand Status product S001 Maruti complete Maruti 800 s002 Toyota complete xyz s003 Maruti complete swift desire s004 Nisha...
-
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 upto...
-
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 Q t...
-
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 eg ...
-
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 rows (...
-
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 cell ...
-
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 month d...
-
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 to t...
-
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 me f...
-
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 pick up...
-
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 particular ...
-
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 spreadsheet th...
-
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 the e...
-
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 the...
-
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 reference c...
-
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 its ...
-
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 004 f...
-
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, 50m...
-
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 e.g. COLU...
-
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 buttion ...
-
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 follo...
-
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 calculation ...
-
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 want to...
-
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 number a...
-
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 value. Wh...
Subscribe To Our Newsletter!
