Excel Forum
-
Using one value to populate multiple columns Closed
Hello, Hi sir am in need of urgent assisstance. I need to populate one value into multiple sheets in excel foe multiple rows... Ex if i enter a va...
-
Macro that extracts info from changing number of worksheets Closed
Hello, I'm trying to find a way to insert a summary of several worksheets (I'm calling them analysis logs), but want to make it in such a way th...
-
Drop down look up Solved/Closed
Hello all, I have a 40 sheet workbook. I want to hide 39 of the tabs and use one sheet as the "master" to pull all of the data. I have the tabs in ...
-
Automatically update master worksheet from other worksheets Solved/Closed
Okay, first I should mention that I'm a complete amateur when it comes to excel. No VBA or macro experience, so if you're not sure whether I know some...
-
Problem getting a sum of cells from one sheet to another Closed
Hello, I'm trying to create two spreadsheets, one with daily totals on it and one with weekly and I'd like for the weekly totals to automatically ...
-
Help- conditional cell formatting Solved/Closed
Hello, I am trying to do some conditional formatting and having a little trouble. Here is what Im looking to get. I have a column A (estimated ...
-
Transfer data to individual sheets from Master sheet. Closed
Hello, I am currently building a worksheet to track where cars are at a certain time. I have three places the car could be (west bullpen) (East Bu...
-
Sum a columns depending on pattern Closed
Hi, I need help in adding the mileage of cars. the rule is simple.. start adding the miles from cells that contains "Movement Start" until "Movemen...
-
Transfer data from one sheet to another sheet in designate area Closed
Hello, I'm working on create a hold record document for our company to label things we need to put on hold. In sheet 1, I have columns for Hold nu...
-
Copy Paste to another sheet with conditions Closed
Dear all, I wanted to copy all the data inside this "form" through the button "send". As you can see I also have two list boxes and I only wa...
-
Group Duplicates and move to new worksheet Closed
Hello, I have a data file and here's what i'm trying to accomplish as efficiently and automated as possible because I will need to repeat this dai...
-
date formatting Closed
Hello, how to convert dates between 1-Jan-17 to 7-Jan-17 single date as 7-Jan-17 using formula System Configuration: Windows / Chrome 62.0.3202...
-
If then statement for switching numbers Closed
How do I use the excel to basically score a survey! I want my code to say if qs: # 1 has score 1 then its 4 , if 2 then its 3 , if 3 then it's 2 , if ...
-
Trying to update date range every month Closed
We have a spreadsheet I'm creating for a recon that we can just input the new date every month (last day of each month) and end up with a description ...
-
Move Rows of Data into New Worksheets Closed
I have a data file and here's what i'm trying to accomplish as efficiently and automated as possible because I will need to repeat this daily. Move...
-
Consolidating Data Closed
Hello, I have an excel worksheet that I am attempting to publish easily by automating the recovery of certain data. My goal is to add the text of ...
-
auto populate from master to individual sheets Closed
Hello, I have an excel sheet that I would like to auto populate from a master sheet to individual sheets. Basically it is an assignment list that I ...
-
Make a macro run when data entered in a cell Solved/Closed
Hello, I have a macro that runs when the user clicks on a button. Instead, I want the macro to run when Cell D10 is populated. The data for D10 c...
-
Need help with #value! Closed
Hello, Hello, I need a formula that will change answer based on selection from drop down box (the formula that I used keeps giving me a #valu...
-
Conditional sum function in Excel Closed
hi, i have 2 sheets in matrix format ,One having travel time between different zones and other having values of number of trips between different zo...
-
Need help with #value! Closed
Hello, I need a formula that will change answer based on selection from drop down box B33 can be any number from 0-10, it has a drop down box w...
-
How to format text with a Macro? Closed
I have a simple event based "macro" that populates my header with information. The question I had was: How can I have the header populate thi...
-
Excel Formula/VBA Assistance Closed
Good Morning, I would appreciate some advice/assistance with formulas and VBA code. http://ge.tt/3wxXEJn2 I am trying to create an equipment ...
-
Worksheet_SelectionChange event not working Solved/Closed
Hello, I wanted to execute a Worksheet_SelectionChange event code. But its not working. I searched on net to find that if I change (General) to Wo...
-
auto populate from master to individual sheets Closed
Hello, I have an excel sheet that I would like to auto populate from a master sheet to individual sheets. Basically it is an assignment list that...
-
give a response by comparing 2 times (in different columns) Closed
I have a sheet which has a dispatch and arrival time in 2 separate columns. Our response time should be no more than 1 hour during office hours (7 AM...
-
import jpeg into cel Closed
Making database for artist archive. Best way to import image files? Sizing is part of issue - how to import a small jpeg and have it conform to cel?
-
Working out the difference in times between two columns Solved/Closed
I have various times in Column B (Departure time), and another set of times in Column C (arrival time). If the time in B is between 07.00 and 00.59...
-
How to load data from various sheets into one master sheet? Closed
Hi Guys, Hope for an expert in excel who can help!!! I have a spread sheet that contains: 1st sheet is master file with the number plate number...
-
Excel macro to insert two rows. Closed
Hello, System Configuration: Windows / Chrome 61.0.3163.100 I have similar problem as this. Just that, I wanted to insert row in different ...
-
Convert in to rs in word Closed
3456755332578097 convert in to rs in word
-
How to use the Spellnumber function in Excel? Closed
Hi. Please giud me how to use formula in excel for spell number for Indian currency .
-
Inserting day of week along with date Closed
Hello, I found an previous post with same question that is closed and it was helpful except for the format. I am looking for an outcome of: Su...
-
Multiple cell copy to a single cell Closed
Hello, I am trying to copy the contents of multiple cells in workbook A to a single cell in workbook B. This worked fine in the 2010 version but,...
-
How to copy columns to a specific column header and repeat? Solved/Closed
Hello all, am new to using macros in excel. i have data and i want to be able to columns and paste it under some specific columns repeatedly. Examp...
-
Auto populate data from invoice. Closed
Dear CCM.NET, Hope you are doing well. I am working for a yarn whole-seller company. I to keep record of various kinds of Yarn purchase, Yarn sell,...
-
Changing format of date in Excel Solved/Closed
Hello, I have an excel sheet which has lots of cells in a column with the date format as - day month date time year & I wish to convert that to dd/...
-
Auto populate text and add total from one sheet to another Closed
Hello, I am trying to work on a yearly spreadsheet that has tabs for each month. What we are trying to do is each month we update monthly tabs w...
-
Create new sheets, scrape in data, then create summary sheet Closed
Hello Everyone, hope you are all well. I am trying to create a database to manage reviews of research papers for a project I am working on. Any he...
-
Can the index function in Excel set a range in different sheet? Closed
Hello there, I need a small help. I need to know whether we can use the index function for setting a range in different sheets. I've u...
-
How to create New sheets by column with repeated values Closed
Hi Have lines with various tables in rooms. Rooms numbers are in column, but sometimes room have 2 or more tables so room numbers repeats. Code s...
-
Getting rows from one sheet to populate to another Closed
Hi, I am working in Excel 2016. I have several separate rows of data on one sheet (lets call it my mother sheet) that I want to automatically popul...
-
max(if..? Closed
hello, i have a table with 2 columns. the first column sometimes has text (any text), sometimes not! the second column contains the amounts. i wa...
-
calculation using alphabet instead if number Closed
Hello, Dear Sir, If I assumed A=1 B=2 C=3 D=4 F=5 G=6 H=7 I=8 J=9 K=0 For example Numeric column > 9949 = JJDK 9949 ...
-
Copying formula by changing only one rule. Solved/Closed
Hello Team, I want to copy the formula "=INDEX((Sheet1!B2:B99),MATCH(B24,Sheet1!A2:A99,0))" 1000 cells by changing only "B24" to "B25, B26" and so ...
-
How to use index function to match from different worksheets? Closed
hi there, please let me know how can i use index match from different worksheets. as i need to use index function for more than one worksheets...
-
Month and year format in forms in excel Closed
Hello, Hello sir I am using forms to enter data. In form i used drop down list function to select particular month from pre-entered months from Nam...
-
Use a macro to copy a value from one sheet to another Closed
Greetings, I'm looking for help modifying or creating a macro to copy the value of a specific cell on one sheet to a specific cell on another sheet. ...
-
Automatically creating sheets based on a Master sheet Closed
I am looking for an easy way to create new worksheets, based on a master sheet. The master sheet is basically a calendar for a week. It has a Mond...
-
Need copy data from specific sheet/cell to another Closed
I have a macro that successfully takes a value from one sheet, "Job", and copies another worksheet, "Entry", and names the sheet for the value in a ce...
