Excel Forum
-
search,compare,update,indicate data in excel sheet (macros VBA) Closed
search, compare, update and indicate data in excel sheet with macros VBA Q) 1 core excel sheet with 10 to 15 thousands rows and around 150 columns. ...
-
convert blank row data in colums Closed
Hello, how we convert blank row data in column Data Name 50 V10 V12 V3 V6 51 V1 V2 V4 V5 V7 52 V8 53 V9 55 V11 57 V13 58 ...
-
Auto update data from one sheet to other sheet Closed
Hello, I would be very grateful if some one help me this issue! I have two sheets with similar format. In the first sheet, I will input many r...
-
data transposition Closed
Hello? I need to transpose my data and need some help. First picture is an example of my raw data and the second one is the data after transpositio...
-
beginner in VBA. I have following problem statement Closed
Hello, I am a beginner in VBA. I have following problem statement: I have a workbook i.e WB1 which is having a unique id in A column, product ...
-
Financial tracking made easy - I hope! Closed
Hello, I am trying to develop a finanical transactions tracking worksheet. I want to reduce the amount of data entry so Im downloading my fina...
-
Word "False" kept on Appearing? =IF function Solved/Closed
=IF(ISNUMBER(A1),IF(ISNUMBER(B1),IF(ISNUMBER(C1),IF(AND(A1,B1,C1),SUM(A1,B1,C1),"Incomplete Data")))) How is it happen that I put "Incomplete Data"...
-
conditional formatting Closed
Hello, I'm trying to write a conditional format formula populating one cell (column of cells) based on the text content of cells in 2 other column...
-
date range to division Closed
Hello, we capture birth date as date and we would like to convert to division Month/Year 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006...
-
sumproduct based on relative cell Solved/Closed
Hello, I can use sumproduct based on information contained in the same range of rows of a column adjacent to it, but I can't figure out how to do ...
-
Macro to copy data from one sheet to another with >1 variable Closed
Hello, I have been using macros to copy data from one sheet to another without issue, until my data has become a little more complex. I have sheet 1...
-
Updating values automatically Closed
Hello, I have an issue. I have 2 workbooks. I need to copy data from one work book to other workbook dynamically. That is if a value is changed in w...
-
Conditionally format cells based on text contained in other cell Closed
Hi - I am running Microsoft Excel for Mac 2011 and want to conditionally format an array of cells based on the text contained in another cell. For exa...
-
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...
