Excel Forum
-
Pictures keep pasting over each other when vba code executes [Closed]
Credits to TrowaD in this Forum I was able to use his VBA Code for what I wanted but it just need a touch more to make it complete....The code below p...
-
change date format [Closed]
Hello, I Want to change date format DD"MM"YYYY (1/2/2016) TO 1/FEB/2016 MS Excel 2003 Please solve my problem urgently Shatrughna unquote
-
Spell Number [Closed]
I do not get the above function in my Excel 2016
-
If Function with Multiple statements including Vlook up [Closed]
Hello, Id like for my formula to read if vlookup is found (H:H is found in the freedom report and column x matches text in AV1, say registered. ...
-
Rearranging analysed historic data into a new coding structure [Closed]
Hello, I'm trying to rearrange historic data into a new coding structure. I have an excel spreadsheet, showing nominal codes analysing rows of...
-
How to transfer specific data from one sheet to another [Closed]
Hello, I am not an expert in Excel and I would say that I am a beginner on this program. I am working on an enrolment spreadsheet. On Shee...
-
What and where is the "orb button" as mentioned in help? [Closed]
Requested help on changing default action when entering info in Excel - response was "open excel and press the orb button". I can't find anything tha...
-
Copying values in cell based on a number/identifier in excell [Closed]
Hello, I'm working on an excel file and need to copy several values from different cell in the same row to another sheet based on unique number/ident...
-
Date if function [Closed]
Hello, I am looking for the formula to show the date if. Ex: I have been provided with the start date (10/4/2016) and i need to add 28 day's (=...
-
Find words within cell & put text and color in adjacent cell [Solved/Closed]
Hi there, i'm trying to search for certain word(s) (i.e. "reply??" or "remind") in a cell with a sentence in it, and place a specific text on a diffe...
-
Multiple If Function with priority [Closed]
Hello, I want and If function to have 2 criteria. Where one segment takes priority, I dont know how to do that. Currently I have =IF($R145="...
-
Conditional Formatting based on other cells [Closed]
I'm relatively new to Excel and I was wondering how exactly to do the following: A1=BALL A2=CAT How do I make it so that when B1=A1, then B1 is...
-
Formulas [Closed]
I'm trying to calculate my wages by entering the hrs worked each day, after 8hrs it is T.5 and DT after 10hrs. If I end up with a total of 3.2 or .2 ...
-
Copy certain cells from multiple sheets [Closed]
Hi, I have lots of sheets that I need to copy specific cells and copy them to a summary sheet. I currently have this macro: Private Sub Command...
-
Find Partial Text Match between Two Columns of data [Closed]
Hi Everyone, I am relatively new to Excel. I am in the process of comparing two columns of data to determine whether the data in each column relate...
-
Copy multiple rows from multiple sheets if certain cell is x [Closed]
Hello, I have a purchase order document in excel that can have from 30 sheets to 500. In cell B14 on each sheet there is a code, if it is equal t...
-
Macro to copy paste columns of excel data to a new workbook [Closed]
Hello, Consider the attached image. I have data like this for about 15 columns. I want to copy paste each column for 2 to 3 times in a different o...
-
Macros: Copy Invoice Details From One Sheet to Another [Solved/Closed]
Would be very grateful for help with this one I have set up a macro that will print and generate the next reference for my invoices raised in excel, ...
-
Auto Populate and Edit Spread Sheets [Closed]
If Intersect(Target, Columns("H:H")) Is Nothing Then Exit Sub Range(Range("E" & Target.Row), Range("R" & Target.Row)).Copy _ Sheets(Target.Value).Ra...
-
Copy a row of data from one sheet to another [Closed]
Hello, Trying to copy a row of data from a roster on a sheet into a new sheet when a cell states Line 1 ie When i type Line 1 etc i want excel to...
-
dates come in 2 different formats [Closed]
Hello, I have a csv file which imported to excel gives me dates in 2 different formats. I need to have one single format so that we can analys...
-
Conditional Format Cells Based on Another Cell and Own Cell [Closed]
Hi, I'm trying to conditional format cells based on text in another cell and it's own cell. In Column A, the cells would contain either "hit" ...
-
Different Calculation Based on Cell Text [Closed]
Hello, I am self-employed and currently doing my taxes. I'm trying to set up my spreadsheet to make it as efficient as possible and am wondering if...
-
Help needed with VBA code [Closed]
Hello, I have a unique situation here. I have got a sheet of data and in column F, there are duplicates values containing letter & Numbers like "O...
-
Populate Master Sheet from another sheet [Closed]
Hello, I want to create a simple entry sheet/report master sheet where records would would be typed into a single row (entry sheet) and the data w...
-
Add incrementing number to multple items in transaction (VBA) [Closed]
Hello, I am a new member and relearning Excel (2013). In this, I am also trying to get my head around VBA. I have VBA code that processes 'split'...
-
Macro to split the workbook in different worksheets [Closed]
Need a macro for Excel that will copy rows from my spreadsheet into a new one if it meets certain criteria. In the example below, I want to copy a...
-
how to insert any word in a cell after a word [Closed]
Hello, i wanted to insert a word for e.g "and" in a cell which after a word. Can someone help me with it Configuration: Windows 7 / Chrome 50.0...
-
EXCEL Formula Functions 2 (?) [Closed]
I am intriuged by the conditonal and the if functions. Does this mean I can record data that has a higher probability factor than an actual approxima...
-
Excel Revision (?) [Closed]
Hello, There is a prompt that states where a member is to record where two lines are accurate, yet I don't understand how or why one would need to e...
-
Copy Paste Data from one Worksheet to Another using macros [Closed]
Hello, I'm trying to have a macros run to copy paste from one workbook to another, however, I need the macros to recognize the last empty row to p...
-
How to copy names from one sheet to another with just a click [Closed]
Hello! I am tasked with creating an employee assignment spreadsheet. I cant seem to figure out how to easily formulate clicking names (around 10) ...
-
Summary Workbook [Closed]
Hi, I have the following requirement in a workbook and I was wondering if anyone could help me? (I am pretty much an Excel rookie) I have a summar...
-
Calculation of positions in excel [Solved/Closed]
Hello Hello, sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...
-
Data Validation refers to Sheet Name [Closed]
Hello, I would like to request for solving my problem My workbook contains many sheets, some ends with the "-E" (Hyphen Symbol and Alphabet E) S...
-
insert filename.csv into the *.csv file [Closed]
Hi Trowa I'm having 3000 files in *.csv format. I want to insert filename.csv into the *.csv file of 'A' column. Is it possible? I'm unable to fin...
-
Excel Macro's copy data from one sheet to another [Solved/Closed]
Hey Everyone ok, so, I have a document with multiple sheets one of the sheets is a reporting sheet what i am trying to accomplish with not much l...
-
Seeking Help with a Formula [Closed]
Hello, First, thanks for taking the time to read this. I'm not great at this and not sure this will even work. Ok, here goes; In a certain cell I i...
-
Need Help with Formula [Closed]
Hello, I'm not great at this and not sure this will even work. Ok, here goes; In a certain cell I input manually a productivity number daily. On c...
-
Copying an adjacent cell text from another sheet, if cell exist [Closed]
Hello, I have 2 excel sheets with lists (+5000 rows) of unique parameter names (text) on each row starting from A2. Sheet 1 has only the param...
-
formula for copying figures onto another sheet when value is >0 [Closed]
Hello, I would like to create a formula that will only show figures from another sheet that are greater than 0. This is for an invoice template. T...
-
Excel Macro [Closed]
Hello, I am trying to create a macro that will insert 2 blank rows into an existing spreadsheet after each category. I want the second blank row t...
-
COMPLICATED EXCEL FORMULA [Closed]
Hello Friends, Can any one help me to sove my problem. I have two excel sheets . i want to comapre column A and B with other sheet and if both cell...
-
Macro Copy & Paste same Cells Down [Closed]
Hi all, First off, I'm new to macros so just a warning. I am currently working on a simulation, and trying to create a macro that will record th...
-
Copy from one sheet to another based on value [Closed]
Hello, I am a newby to excel macros but here goes. I have a sheet where raw data is being entered in rows called DATA (How original) :-) I have...
-
Compare two Excel Sheets which have Duplicate Values (Advanced) [Closed]
Hello, I'm trying to compare two excel sheets which have duplicate values in the matching column. In both sheets the number of row count is dif...
-
Fetching of data from number of other sheets to a master sheet [Closed]
Hello, respected consultant, I have created a Excel Sheet for student class attendance. in it i have made a provision for over all attendance of ...
-
Cut-Paste from 1 Workbook to another-based on cell - del columns [Closed]
I have a master workbook and a template workbook. Master workbook has 6 col - Vendor / Rep / ST / Code / Amount / Name. Template has 5 col - Vendor ...
-
Moving Entire row from one sheet to another [Closed]
Hey, I have a list of job orders listed in excel. One job takes one row. One of the columns reads heading as "Job status", the value under job status...
-
Urgent Copy Vertical data from One sheet to another horizontally [Closed]
Hello, I am trying to copy cell data from one sheet to another, the data in source sheet is vertical and i have to copy horizontally in destination...
Subscribe To Our Newsletter!
