Excel Forum
-
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...
-
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 the ot...
-
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" is t...
-
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 calcula...
-
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 the...
-
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 BOM...
-
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 val...
-
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 to ...
-
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 need ...
-
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 cre...
-
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 child s...
-
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 products ...
-
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 so ...
-
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 % betwee...
-
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 or ...
-
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 wor...
-
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 be ...
-
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 cel...
-
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 language ...
-
VBA Copy and paste range to next empty cell(s) to right Closed
Hello! I'm fairly new to VBA, and I'm new here, so please bear with me as I try to explain what I need. I have a set of data that will be updated on...
-
Conditional text based on text in another cell Closed
Hi, I'm trying to format a cell (D2) on Excel 2007 so that when the cell next to it (E2) contains "LFC-0.3", it will say "Downregulated", but if the ...
-
date Closed
what is the formula to convert numeric date into words in excel
-
Excel formula needed to count a list of names Solved/Closed
Hi This is probably an easy one for the pro's, basically I have a list of names that will change as reports are generated. The report will inclu...
-
Automatically Copy New Survey Data to Another Sheet Closed
Greetings, I'm trying to copy certain cells of data received via an Excel Survey to another sheet. Trouble is, when new data is received, the row num...
-
Conditional formatting: Find text and highlight from other cell Solved/Closed
I have a table with names and number values alternating in a table. I add all the numerical values and highlight based on the total value for each nam...
-
Create new excel file and name sheets in it from existing list Closed
Hello, I' m new here and my question is about creating new excel file and sheets in it from existing list in other excel sheet. Macro has to create ...
-
Selecting Specific range of data using Macro Closed
Hello, I have made 20 sheets for a single Excel File. I need to select only specific data and display(for ex; I have two Macro buttons called 'DEBUT'...
-
Finding a particular row title and editing the value in next col Closed
Hello All, I have excel data sheet in following format Row Heading Row Value name XYZ address ab id 11 Now I need to write a macro which can ...
-
How to find a row heading and replace the data in the next col Closed
I have excel data sheet in following format Row Heading Row Value name XYZ address ab id 11 Now I need to ...
-
EXCEL/VBA copy multiple cell from other workbook into 1 workbook Closed
Hello, I would like to copy couple of cell from multiple workbook into 1 workbook using Marco/VB. Example: Source C:\temp\A.xls. Cell needed ...
-
macros to add numbers Closed
Hello, I need to create a button and on every click of that button it should add 1 to it. For Eg first click it should take data as 1 and second ...
-
change date format Closed
Hello, I Want to change date format dd.mm.yyyy to dd/mm/yyyy in MS Excel 2010 Please solve my problem urgently Configuration: Windows 7 / Chr...
-
Macro to cut & paste a row on same excel sheet Closed
Hi, I have a list of values. You can consider them as text. These values are listed in a different sheet (in one column) on same particular Excel fil...
-
Comparing values from different sheets Closed
Hello, I want to Compare Values from 2 different sheets and if duplicate. I am thinking of values on Column A & B of sheet1 to columns D & E of sh...
-
Need a macro to searched data in another Excel Closed
Hello, I have a requirement , where in in one excel sheet i have data with 5 columns (A, B , C , D , E) now i want to search the excel on data wit...
-
Date format Closed
Hello, In my system date is in dd/mm/yyyy but I required in this format dd-mm-yyyy how it will possible pl let me know Configuration: Win...
-
automate vlookup Closed
two sheets.in one excel sheet columns are name, isbn, qauntity and many so.... in another excel sheet columns are only three columns are sku, isbn, q...
-
Excel info Closed
Hello, I am trying to enter data in one sheet and the total should be recorded in the other sheet. I want the total to be recorded in next cell a...
-
Date Interval within a specific span Closed
Hello, I need some help with calculating the time difference between two time stamps within a specific span (like 12.30 PM to 22.30 PM). For Eg ...
-
Apply Autohide Rows VBA code to entire workbook in Excel 2013 Closed
Hello, I want to apply this code to all worksheets: Private Sub Worksheet_Calculate() Dim LastRow As Long, c As Range Application.EnableEvents...
-
Autorun different macros dependent on dropdown and cell value Closed
Hello, I have 4 macros activated by 4 buttons these are macros stage2, stage3, stage4 and stage5. If I enter values into fields D7, D8 and D9 then...
-
Macro needed to find A and look at B Closed
Hi this is my first ever post! I am setting up a userform in VBA that allows data capture. This form currently copies the information entered to ...
-
Condition formatting on changing cell color based on another cel Closed
hi, wanted to check if it's possible to do condition formatting on cell color based on another cell's text. For example I have cell A1 with Text Pa...
