Excel Forum
-
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...
-
scheduling spreadsheet [Closed]
Hello, I am trying to make a scheduling spreadsheet where I can input a persons name and shift on a master page and it will auto populate to an as...
-
What is an alternative function for SpellNumber in Excel? [Closed]
if the function of ( SpellNumber) not available , then what to do
-
How to use the filter function on a column in Excel? [Closed]
Hello, I'm having the same issue trying to use the filter function on a column. I have tried the solutions suggested, but none seem to work. Thi...
-
macro related showing in a fixed cell [Closed]
Hello,greetings, I am running a macro, but it is showing in a fixed cell where initially the micro is created instead of in required cell. for ex: if ...
-
Autopopulating multiple sheets from main sheet by date [Closed]
Hello, My name is Ana and I have a situation. Every day we have hunďreds of rows with diffrent info about our customers. On column H we have cells...
-
Automatic add and sub [Closed]
Hello, Hi everyone,I need help from u regarding excel formulas and workout basics.My question is..If i add particular row or column it should be a...
-
Looking to enter a name and then want it to be pasted in x numbe [Closed]
Hello, Looking to enter a name and then want it to be pasted in x number of rows. Then enter a new name in the x + 1 row and want that pasted y n...
-
VBA macro loop [Closed]
Bare with me here, I just started learning VBA code so it may look a little ruff but what i am trying to do is to use a loop to copy and paste each su...
-
How to compare 2 sheets in Excel? [Closed]
Hello, I have to come 2 sheets sheet 1 Rev 0 Sheet 2 Rev 1 Sheet 3 diference between sheet 1 & Sheet 2
Subscribe To Our Newsletter!
DON'T MISS
- How to Upload High Quality Photos to Instagram
- How to Recover a Disabled Facebook Account
- How to Install a VPN
- Computer Boots to Black Screen
- How to Recover Your Yahoo Account
- Facebook Code Not Received
- How to Get More Followers on Instagram
- How to Create a Gmail Account
- How to Get Free Diamonds in Free Fire
- How to Fix a Blurry Snapchat Video
- How to Disabled Write Protection on a USB