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...
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...
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 ...
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...
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...
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...
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...
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 ...
Hello, Can anybody help to find ans for below question if sentances are " HEDgroup people are in bench" "evals making count" "nothing in MIL" ...
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...
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...
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...
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...
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...
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...
Hello, i want to do a rating..example.. Artist Rating(numerical) Rating(graphical) akon ...
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 ...
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...
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...
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...
I Have two worksheets a) Warehouses Combined - this list all codes a to z b) Suppliers - list all suppliers with discount per supplier. Warehouse...
Hello, Could someone help please. I have a excel file with a master sheet which contains invoice companies. The are alphabetical ordered. Bu...
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...
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...
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 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...
Hello, Please help me get the correct formula for this: RETURN RED IF D1 lower than D2 and lower than D3 ...
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...
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 ...
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 (...
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 ...
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...
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...
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...
Hi. Need a little help with conditional formatting. Basically need to build in a excel spreadsheet a rule where conditoinal formatting will pick up...
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 ...
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...
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...
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...
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...
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 ...
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...
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...
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...
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 ...
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...
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 ...
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...
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...
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...