Excel Forum
- Solved
-
Excel 2003 days before a certain date [Solved/Closed]
Hello, I am making a spreadsheet which has, for example, a given date of 1/1/2012. When I enter that number into cells A1, I want it to...
-
Insert Line Number for Two Columns Document [Solved/Closed]
Hello, I have a problem to do a process of line numbering in MS Office 2007 Word Document. I have a document, it has 2 columns and I have to...
-
Create drop down list on certain cells [Solved/Closed]
Good day, I wanted to create a drop down list from data in Sheet2. I have tried the following codes but the outcome seems to be incorrect....
-
Macro for finding dates [Solved/Closed]
Hi guys, Is there a macro that would give me the the cells in a column in which there are dates between 2012 and 2013. It can be easily...
-
Macro To Copy Data [Solved/Closed]
Hello, I have two excel sheet with three column on each sheet Sheet 1 Sr.NO Code...
-
How to build a macro that does this... [Solved/Closed]
Hello guys, I would like to build a sheet that contains several names and infomation pertaining to each name. The first tab would be the...
-
Separating items from columns [Solved/Closed]
Hello guys, Could you please help with this... Is it possible to do the following in excel: I have similar cells to this in one column: Ford...
-
A Macro to move data from rows to columns [Solved/Closed]
Hello, I have data in a single column and would like to copy it into a rows for every x rows, for example; The column of data varies in the...
-
How to match 2 row of data in excel ? [Solved/Closed]
Hello, brothers & sisters I have 2 columns of companies name say (column a=38900),(column b=1000) so how can i use a formula to do a match by...
-
Excel, comparing two sets of two rows [Solved/Closed]
Hello, I know the title may be a little confusing, and I apologize for that, but I really did not know how to phrase it. What I have is two...
-
macro to compare two excel sheets [Solved/Closed]
Hello, I need help to write macro to compare two sheets, sheet1 and sheet2 on same excel book and display the result on the third sheet....
-
Excel Help [Solved/Closed]
Hello, I have a schedule for the employees, and it contains seven columns as 7 days in a week. If any range of the columns contains...
-
Excel: Comparing two columns and output data [Solved/Closed]
Hello, I'm using Excel 2007 and am trying to figure out a way to analyze and sort some data. I have two sets of data in 6 and 5 columns in...
-
Problem with excel [Solved/Closed]
Hello, I was trying to write a formula in excel where IF A1 is greater than 7 then 1 would be substracted from it and if it is greater than 5...
-
Excel: Splitting of data based on calculation [Solved/Closed]
Good day, I would like to seek help to how to split and populate data based on the result of certain calculation. Here are the criteria for...
-
Excel 2007 IF function [Solved/Closed]
Hello, Need formula to say if cell has NA put 0 but if the cell has a date (yy,mm,dd) then subtract cell L1 from cell E1. Trying to determine...
-
VBA - Transferring select Data to new sheet [Solved/Closed]
Hey there, I'm trying to create a macro for an Excel 2003 spreadsheet that will take a record (a row (or rows)) that I've already selected into a...
-
VBA code to conditionally copy the data [Solved/Closed]
Hello, need help! see I need a vba code that can copy data from sheet1(raw data) to sheet 2,sheet3 and so on is certain condition...
-
VBA Macro Help [Solved/Closed]
Hello, I have a report that I am using for a customer of mine that lists there kits in a matrix for me. Once in a while I find an error where a...
-
split mutiple columns in sets of 40 [Solved/Closed]
Hello, I have data in 3 columns A,B,C and it goes to 1000 rows, I want it to be splitted in sets of 40 each . Like first 40 then next 40 and...
-
How to concanate two cells "line by line" [Solved/Closed]
Hello, I have one cell that has names separated with alt + enter. On the other cell, I have additional information on those names (also...
-
Text to n rows + copy row and insert n times [Solved/Closed]
Hello, I would appreciate your help with a macro I am trying to create in Excel 2007. My data is as follows: Column1 Column2 Column3...
-
Excel Macro - Set and Autofill a range? [Solved/Closed]
Hello, I recorded a macro for excel and part of the code is to create an index column that fills the cell with a row count (i.e. A2=1, A3=2,...
-
How to copy informations from Excel to EES [Solved/Closed]
Hello, I wanna know if anybody can help me to copy 2 columns (supply) from Excel to EES (another program if anyone used it before) and then copy...
-
Excel 2007 Activex Option Button Default? [Solved/Closed]
Hello, I have two activex option buttons, Yes and No. How do I get it to display "No" as marked as a default? I have created a process...
-
Excel date formatting into another column [Solved/Closed]
Hello, I want to check using IF function in one column and change the date format to another column from MM/DD/YYYY to has DD/MM/YYYY in excel...
-
Excel - transfer information from file [Solved/Closed]
Hi there! I have run into some problems when transferring information from one Excel file to another. I have a big Excel file with a lot of...
-
Add when multiple criteria is met in rows [Solved/Closed]
Hello, I'm trying to add numebrs when multiple criteria is met! I want to add numbers in B115:BF115, but only the ones that have an "A" in...
-
Sumifs in Excel 2003 [Solved/Closed]
Sir I was using System with office 2010 and deriving some values by using "Sumifs" function. Now i am using Office 2003 system. When i copied...
-
Create new worksheet & copy the based on date [Solved/Closed]
Hello, Can any one help me to copy the excel sheet data from one sheet to another sheet? -> I have one excel sheet (name: Test.xls, sheet...
-
Copy Worksheet to another Workbook (unopened) [Solved/Closed]
Hello, I want to copy a portion (A1:F54) of my current worksheet that I am working on, over to another workbook, that is not open. I want to...
-
Excel macro help needed to name ranges [Solved/Closed]
Hello, I have a 10 column x 500 row spreadsheet A1:J500 I would like to name ranges as follows: Range A1:J1 should be named with the...
-
excel related [Solved/Closed]
Hello, could you please tell me how I get excel to automatically use a color in a cell that I write something into? The blank ones can remain...
-
Macro to create worksheets [Solved/Closed]
Hello, I'm Mike, I'm new to Macro excel I need a Macro that read from a table the name of projects and create for each project a sheet...
-
How to make 2 VBA codes to work correctly [Solved/Closed]
Hello, How can I correct the following 2 codes (which written in the same sheet) in order to work correctly, other wise it gives me Error...
-
Auto-copy of select rows to another worksheet [Solved/Closed]
Hello, This is my first time asking a question, so I will do my absolute best to follow and respect the forum guidelines and it's...
-
Correcting VBA code in Excel [Solved/Closed]
Hello dears, I have the following VBA code : Private Sub Worksheet_Change(ByVal Target As Range) Dim cRow As Integer If...
-
Highlight unique or duplicate on 2 sheets [Solved/Closed]
Hello, I have a Excel file of 2 worksheets and have a list of Usernames on column B of both worksheets. Few of the usernames appear on both...
-
Excel dynamically fill cell with data [Solved/Closed]
Hello, I have worksheet ( AllUsers ) with two column A ( user id ) and B ( date ). Column A is a long list of user names and B is a list of...
-
copy text frm a cell n append it thru macro [Solved/Closed]
Hello, I am trying to create a macro where I want to copy a cell content from one worksheet and append it to a cell in another worksheet of...
-
Column comparation in different datasheet [Solved/Closed]
Hello, Hello, I have one excel column A in datasheet 1 which has a list of names. In Column A of datasheet 2 I have a much longer list...
-
VBA copy/paste cells then drop 1 row for next [Solved/Closed]
Hello, I am making a questionaire. When the questionaire is complete I want to copy the answers to another worksheet then reset the answers to...
-
How to determine cell value in Excel column [Solved/Closed]
Hello, Sorry the title is really vague, it's hard to describe with a limited number of characters. I have a column (C) which contains a...
-
Excel Macro [Solved/Closed]
Hello, I wonder if anyone can help me with a small (I think) problem, please? I'm trying to write a macro to manipulate a spreadsheet sent...
-
compare cell a1 to entire A col in sheet2 [Solved/Closed]
Hello, I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row...
-
Excel problem [Solved/Closed]
Hello, Hello, I am hoping that someone can help with the following problem, I have a list of numbers, golf staplford scores, located in...
-
Excel - copy data macro [Solved/Closed]
Hello, I am currently learning the tricks in excel but have become stuck. I have created an expenses sheet where employees record various...
-
how to move data in rows to columns [Solved/Closed]
The data now is in the below format 1 2 3 9 15 16 20 25 1 This has to come in this...
-
If, then statement in Excel [Solved/Closed]
Hello, This formula sounds easy to come up with, but I cannot figure it out. I'm trying to figure out how to add a certain amount of days to a...
-
Excel: Populate data based on criteria [Solved/Closed]
Hello, Good day. I would like to populate data from 1 sheet to another sheet based on certain criterias. With reference to the sample data...
-
Muslim Pro
-
Animal Crossing: Pocket Camp
-
Tacticool - 5v5 shooter
-
Resident Evil 3: Raccoon City Demo
-
Minecraft: Education Edition
-
Ukulele Tabs & Chords
-
Amigurumi
-
HEALTHLYNKED COVID-19 Tracker
-
COVID Symptom Tracker
-
Zoom
-
Houseparty