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...
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...
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...
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...
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...
Hello, If cell have specific text it give us alert message Configuration: Windows XP / Chrome 44.0.2403.157
Hello, pls give me one solution Configuration: Windows 7 / Chrome 44.0.2403.157
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...
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...
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...
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...
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'!...
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...
Hello, kindly guide me how this formula apply in excel for amount converted in words plz guide me plz help me reply on this id ***@*** Confi...
Hello, I have one problem to solve. I have 2 work sheets in excel. In the first one I have few columns. 3 of them I want to transfer for another she...
Hello, Trying to Edit incoming data faster, would like to be able to input data lets say Sheet 1 A2 First Name B2 Last Name, then Take given informa...
hello, i want to make a sheet for my job to track the allotments, i want it to count the days allotment sent for signature till it is back from sig...
Hello, Please, please, please can I have your expert help with his matter I would like to copy + add up the numbers in the cells from a differe...
Hello, I have one excel spreadsheet with data in this form Country: UK France UK Spain Germany UK Spain France UK Germany data1: ...
I am trying to have Excel lookup values in Column A from Sheet A in Column B Sheet B, and then, copy entire Row (or just to the left from Column B), w...
Hello, I work at a fitness center. We have an equipment checkout system that we use Excel for. In my "Lockers" sheet, locker keys get checked out ...
Hi everyone! I'm sure you get asked this often but I can't find what I'm looking for on the internet so I'm asking and yes I'm a new-be! No laughi...
Hello, I have a "Yes" or "No" data validation list in cell C1 and manual input cells in D1, E1 etc. I would like to create a code that says (If C1...
Hello, How to compare numerical values in two columns and get their difference in an excel?
Hello experts, I am new to excel, I have a requirement where I have multiple sheets and I need to create a master sheet..based on the surrogate ...
Q) 1 core excel sheet with 10 to 15 thousands rows and around 150 columns. Another targeted sheet to be completed with using VBA which content same 10...
Hello! I need some help for data transposing. the data set above is the raw data and the data set at the bottom is the set I need to create. ho...
Hi all, I am creating a school directory. My columns are Last Name, First Name, Father/Mother, Phone, Email, Address, Zip, Teacher, Grade. I ha...
Hello, Thank's in advance...for helping in my problem I enter data in a sheet and based on that i print few page report that contains that variable...
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 informat...
Hello, Dear Friends i m not good in english so sorry in advance for bad english. but i need to enable macro automatically when worksh...
Hello, I am creating an estimating workbook where I have multiple product sheets that list qty, part#, description, volume, lbs, list price & disc...
Hello. I enter data in a sheet and based on that i print few page report that contains that variable data I want to some extra work so that every...
Hello, I have got two excel sheets one master sheet that gets updated everymonth with the new employees joining that month. In the second sheet ...
Hello, Hello i want to know how to convert date into words(english) in excel 2003, 2007 or 2010 for eg. 22.04.2010 - convert it into Twent...
Ok - I know I said no more scripting, but ... Im still with Excel (VBA) macros and trying to find a way of inputting data from a html sheet (stored...
Hi, I am fairly new to Excel, especially when it comes to macros. I will be having a lot of files saved in a particular folder that contain inspec...
My question is in the comment in the code: Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next If Target.Cells.Count > 1...
Hello guys, Can you pls help me? I am beginner in VBA and I need to sort out one macro. I have table and need to have highlited row with color, bu...
Hello, Sir, i am using if condition with date function. my question is that I have two date in two column. dates are different. if 1st date col...
Hi everyone: Following policies is a difficult thing because it is open to interpretation. I was wondering if it is possible to create a prompt in...
Hello, how do I can convert the date in to month name and year ex. 01/05/2015 , I want to get month name as May and year 2015 pls help me, b...
Hello, Configuration: Windows 7 / Internet Explorer 7.0 I am new to Excel Macros. I situation is I have a sheet with 40000 rows range (A1: ...
Hello, I have a document in Excel, and has 5 different pages; all of them have the date on top. I need to know, how I can set up the formula or th...
Hello, I have written the following code which creates a variable # of additional sheets in my workbook based on how many rows have names in them...
Hello, I am in need of a way to create a order form from a table (product list) using Data Validation. The table is 8 columns and aprox. 5000+ r...
Hello, I am trying to create a macro to help the input in a complex excel file. I have created several dropdown menues to choose from a list: ...
Hello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: C...
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. ...
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 ...
DON'T MISS