Excel Forum
-
Use a master worksheet to update/populate all other sheets [Closed]
Hello, I'll try to make this explanation as simple as possible but please ask questions to get a better understanding. I blew my team away...
-
columns data formatting [Closed]
Hi i have data in two columns in below format: 1 a 2 b 3 c 4 d And so on. I want my two cells data in single cell with...
-
Excel column formatting [Closed]
I have two columns 1 A 2 B 3 C 4 D My data is in two column like this and i want my answer...
-
Need help in creating macro to create new workbook [Closed]
Hoping someone can help me. I have a Microsoft Excel 2010 workbook that contains multiple rows of data. Row 1 contains my headers from Column A...
-
Find data and copy dynamic range [Solved/Closed]
Hello all, I would like to find text in one column and copy the range values which is adjacent to the text searched. I've attached the...
-
Resize the range [Solved/Closed]
Greetings, I would like to resize the range without keeping the starting position. I've attached the image In the above example, while...
-
how to compare data btw 2 sheets and identify the difference [Closed]
How to compare all info in sheet 1 and 2 and identify the difference SHEET 1 COL A COL B COL C COL D GF123 ...
-
Macro to Cut and Paste into next available row in another sheet [Closed]
Hello, I am very new to Macros and I am trying to write one that will cut the data in cells F3:H13 on sheet 1 and paste them in the next...
-
Comparing Two Sheets in Excel to Eliminate Date [Closed]
I have two lists in excel, one is a full list of data and one is the list of data that I need to eliminate from the first. How do I compare the...
-
If formula [Closed]
Hello, I have to keep track of utility bills for my company on a month to month basis; is there an "if" formula that I could use to alert me if I...
-
Excel 2013 Macro [Closed]
Holà! I am currently using this macro created by a former coworker to create & save as, a couple dozen excel workbooks. (This is just a...
-
Using the IF function for dates [Solved/Closed]
Hello, I am trying to figure out in Microsoft excel 2010 the appropriate IF formula to use. I am trying to calculate the number of working...
-
Number Conversion to Code [Closed]
Hello, Hello, I appreciate any and all who may give this issue some consideration. This is to change a number to a code of letters to...
-
How do I code using a cell.? [Closed]
I want to make a code that takes a phrase such as "hello" and change each letter to a number so it's says something like "50,41,62,62,60" how do I...
-
How do I code using a cell? [Closed]
I want to make a code that takes a phrase such as "hello" and change each letter to a number so it's says something like "50,41,62,62,60" how do I...
-
Look at two different cells, refer to a 3rd, return value in 4th [Closed]
Hello, I am working on a worksheet and want to return a value from a column entitled "Possible Points" depending on which column is...
-
Create a Table from data held in an existing table conditionally [Closed]
Hello, We have a job monitoring excel we have been using where we have an existing table that holds the status of all possible jobs we are...
-
Data entry [Closed]
Hello, i am working on two different excel sheets. in sheet 1 i have a similar types of entry suppose that students name of same student...
-
How to Separate the worksheet based on data [Closed]
Dear Sir. I had the data as mentioned below for your reference CODE EMPNAME EB HRA GROSS 175702 MAURICE J...
-
copy data without opening workbook using vbscript [Closed]
Hello all, Is it possible to copy data without opening workbooks using vbscript? Thanks in Advance!
-
Use certain words in two different cells to determine rate [Closed]
Hello, If cell A2 is word "Beachwalk" and cell B2 is word "hskp" i would like that cell C2 shows rate $13. Would like to make a formula that...
-
help writing a IF formula [Solved/Closed]
Hello, I need to write an IF formula for excel. Cell A2 will either say ''receive'' or ''deliver''. This formula works...
-
If a cell in column contains "x", return the value [Closed]
Basically I have a large spreadsheet and I want to pick out the values that I flag with an X. Not all of the rows have an x next to it, but the...
-
If statement formula [Closed]
I have to keep track of utility bills for my company on a month to month basis; is there an "if" formula that I could use to alert me if I have...
-
Inserting multiple images based on cell value [Closed]
Hello, I hope to find some help here as I would really like to find an easier way than just insert each picture manually. I have range of...
-
Formulas to Pull out text in Description [Closed]
Hello, I need a formula that will produce the following results: Actual: A1. Cash 10/2/15 A2. CC Application 10/4/15 A3. Check...
-
comparing changing data in 5 excel sheets [Closed]
Hello, I have a daily spreadsheet that I need to compare to the previous day and so on for the wk. In line A i have a list of products,in line...
-
Excel column comparision. [Closed]
Hey, I want to compare two tabs in separate columns with data which gives a match (Its okay if not exact) even though the words are jumbled or...
-
Excel column comparision [Closed]
Hey, I want to compare two tabs in separate columns with data which gives a match (Its okay if not exact) even though the words are jumbled or...
-
help with a formula [Solved/Closed]
Please help !! Looking to calculate totals based on the following... Entering the formula in the following field K4 I have rows (B4 thru...
-
Formula to add 1 with IF statement [Solved/Closed]
Hi, Here's the breakdown of what I'm trying to do: The formula is going in cell 'Y28' and I'm attempting to do two different things: 1) I...
-
formula issues with various variables [Closed]
Hello, I appreciate the time the forum are taking to view my message. I'd very much appreciate it if someone could help me, as I'm trying to...
-
Transfer data automatically from one sheet to other based in [Closed]
Title->Transfer data automatically from one sheet to other based in specific dates. Hello and sory for my long title. How can transfer data from...
-
Comparing two excel files of office 2010 [Closed]
Hi there I have two excel files. I am using office 2010 professional. Each file contains 15000 rows and 10 columns. I need to compare the both...
-
copy content from excel to another excel using command prompt [Closed]
Hello, Is it possible to copy content from one workbook to another workbook using command prompt. say, I have 2 excel named a1 and b2. I...
-
Use macro enabled workbook in macro enabled excel template [Closed]
Greetings, Is it possible to use macro enabled workbook inside macro enabled excel template? (i.e,) sample1.xlsm is the macro enabled...
-
How to Copy/Insert a worksheet, rename and populate with data [Closed]
Hello, I am new to writing macros in Excel. I want to automate the following tasks in an Excel workbook, using the following: 1. "Summary...
-
Updating Existing Worksheet [Closed]
Hello, everyone I hope everyone's holiday's are great. I want to thank everyone in advance for their help with this situation I am having in...
-
Figure Out Error [Closed]
Hello, I would like to solve this error in the given code which is I can't able to figure out what and where it has an error. The issue...
-
Not Pasting values in Excel file [Solved/Closed]
Hello, I would like to know that I have a Excel Macro Enabled File. it has macros, sheet vba code, modules and user forms code and no...
-
Translate or Convert Text in Excel to Consolidated Numbers [Closed]
Hello, I am quite new to Visual Basic for Applications, but I am trying to figure out if a specific part of what I am trying is possible/how...
-
AutoFill data from list [Closed]
Good evening, can i have your help please? In the sheet "ΟΧΗΜΑΤΑ" i have a range D5:AG5 which are the titles of 30 columns. In area D6:AG35 i...
-
Sort [Closed]
Hello, On Column A I have DATES Column B a code (D1111, D2222) Column C Vendor num Column D Client num I want to be able to identify...
-
Coping formulas to next row using a macro [Solved/Closed]
Hello, I am trying to make a macro to copy a formula to the next row in a spreadsheet. Then paste the absolute values back into the original...
-
VBA Code [Closed]
I dont know how but I managed to put together a macro that copies transposed info entered in a column of one sheet to a row in another sheet. The...
-
Restriction of @ and .com [Closed]
Hello, Thank you for your reply, I have another question, if you can help me with that too? I want to add a restriction in a column for suppose...
-
Compare data in two excel sheets [Closed]
Hello, I have huge data in two different excel sheets (same work book), approx. 10 columns & 5000 rows. I want to compare both the sheets and...
-
Excel sheet alphabet count [Closed]
Hello, How can I count alphabet on excel sheet. kindly send me the details Thanks & regards Pulakesh Medhi
-
Subtraction total [Closed]
Good evening, please anyone who can help me, i have in cell J5 all products eg. 20 parts. In cells L5:W5 add how many parts i have used. How i...
-
add a restriction to a column [Solved/Closed]
Hello, Can you please help me out, I'm stuck. I have to restrict the numbers 03 in a column that must contain 11 characters ( the number...
