Excel Forum
-
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...
-
how to read the file from shared PC in same work environment [Closed]
Hi all can anyone please guide me on this. I want to open the file which is stored in shred system in our work environment. those will be accessible...
-
to copy data to other workshet by suming the value based on co [Closed]
Hello, I am having table like below with large data in DATA.xlsx file Pls see attached file for table details My requirement is to selec...
-
Auto - input box/date timestamp [Closed]
Hello, I am creating an inventory spread sheet. I am using Excel 2013. I have data from A2:O1243. I have several macros running. My macros are as ...
-
Autorun Macro on various cell changes [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 the...
-
compare filename1 sheet1 with filename2 [Closed]
Hi all, i need help, i want to compare filename1 sheet1 with filename2 sheet and result in filename3 sheet as pass or fail. filename1 sheet1 insert ...
-
Autofill on excel or formatting? [Closed]
I have two separate worksheets. When a customer calls in I will fill out there name, address, phone number, and email address in worksheet 1. I was th...
-
Excel / CSV query [Closed]
I will be receiving a weekly CSV data set of holiday information that I need to do the following with: Save into XLS format Create 3 identifier ...
-
auto populating from one spreadsheet to another [Closed]
HI there, this is my first question and I am hoping someone can help me please. I am setting up a database in excel and I am an basic to intermedia...
-
need formula to populate total sales for each employee by month [Closed]
Hello, Im working on a spreadsheet and i cant come to a formula that works for me. I want to total the amount of apples each employee sold e...
-
get data present in Row1 of Sheet1 copied into row1 of Sheet2 [Solved/Closed]
Hello, I need to get data present in Row1 of Sheet1(Central OPD) to be copied into row1 of Sheet2(Departmental OPD) based on Department Column of Sh...
-
spellnumber function [Closed]
Hello, Spellnumber function which was working in excel version earlier than office 7, does not work from office 7 onward versions. I can not get t...
Subscribe To Our Newsletter!
DON'T MISS
- How to Disabled Write Protection on a USB
- How to Get Free Diamonds in Free Fire
- How to Upload High Quality Photos to Instagram
- How to Get More Followers on Instagram
- How to Create a Gmail Account
- Computer Boots to Black Screen
- How to Fix a Blurry Snapchat Video
- How to Install a VPN
- How to Recover Your Yahoo Account
- How to Recover a Disabled Facebook Account
- Facebook Code Not Received