Excel Forum
-
formatting a column with repititive lines of texts with same col Closed
Hi i have just completed a time and motion excercise and i have enetered the details into excel. i have also cleaned up my data, checked for inc...
-
How to Copy my all data in excel sheet1 to sheet 2 Closed
HI.. all I have a Question. I have some data in my excel sheet1 . i want same data move or copy sheet1 to sheet2 by formula. i wait response. ...
-
Making Buttons to direct to a certain cel location. Closed
Hello, I'm just wondering if its possible to make a button that redirects you to a certain cel information in EXcel. Sample: I want the button...
-
Auto Copy Closed
I have a spreed sheet set up to log information on (sheet 1). On this sheet, it is a dynamic work sheet that we enter names on that we are currently w...
-
Insert/Remove photos depending up on ref. cell value changing Solved/Closed
Hello, I designed a Student Profile in excel using LOOKUP function. In this profile, near the Student Name title I created one drop down list of stu...
-
calculate difference in date Closed
Hello all I have date column in following format- 21/09/2014 06:26 AM I want to calculate difference between above date and today. I tried doing ...
-
How to Create Macro to Search, Copy, & Paste? Closed
I have Two Excel sheets Sheet2: Database file(Row wise Data has been updated i.e only in A column- refer below A1: Name A2 : person nameA3: ...
-
Move multiple entries from main sheet to multiple sheets Closed
My First sheet is titled "D-4 listing" and contains all of the data for other sheets. I have columns F thru P that I put an "x" in if the information ...
-
Excel VBA copy and paste loop with logic condition Solved/Closed
Hi, I am new to VBA and would appreciate some help with a problem I am trying to solve. I would like a macro that is able to copy information f...
-
Excel workbook with two sheets Solved/Closed
Hi, i have an Excel workbook with two sheets and when i enter data in sheet #1 it automatically goes to sheet # 2. How on earth can i stop this fro...
-
Need help with formula if multiple cells are empty then another Closed
I am using excel 2010, I need help with a formula that i can t seem to get i know i am close. example. A1,B1,C1,D1 - if B1 is blank and C1 is blank ...
-
Keep rules & formatting intact when data is copied to cells Closed
Hi, I have an excel sheet made with few rules and formatting for cells but many times I have the requirement to copy values to these cells from tex...
-
How to copy data from rows with value to a new sheet using macro Closed
I have a massive excel spread sheet that I am using to keep track of sales. I would like a formula or function that will take both the headers along...
-
%age of numbers Closed
I have ten different numbers in a column. I want to calculate the percentage value of each number in next box to each number with respect to 350
-
Substitute text into x in excel Closed
Hi there, I'm nowhere to run related to the above subject, hoping you can help me to sort out this issue. In column/row A1 text is equal to "clo...
-
Copying the same format data from n number of sheets in 1 sheet Closed
Hello, Scenario : I need to monitor a particular type of transactions. For each transaction done I get a automated mail with an attached excel. T...
-
Excel to send email when a cell changed Closed
Hi, I'm totally lost, I'm new to macro world and would like to send email from excel when a cell changed, the sheet is very simple: Name Pr...
-
Shared File want to get a pop up message when the file is opened Closed
I am trying to share a file between 3 people. I found the share option but I want to get a pop up message anytime the file is already open & someone ...
-
convert from one Column using if function Closed
hi i have the information in one Column "A". This "A"Column contains 100 address .(Each line of the address has been typed in separate row) but eac...
-
Auto Transfer of a filtered item to a different sheet. Solved/Closed
Hello everyone, I would like to ask for some help regarding some EXEL problems. Example: I want some data from sheet1 E columns to transfer to...
-
Moving data in specific columns to another sheet Closed
Hi there, I have a workbook with multiple tabs. I need to move the first 3 columns of data in a row on tab, "MV Data" to another sheet labeled, "Campa...
-
Simple report reminder - email notification Closed
Hi, I would like to create a spreadsheet that list the dates of reports that I need to complete. The spreadsheet would be relativly simple, just a...
-
last row does not show. 44 names bt i see 43 Closed
The function below , leaves there the last name (in column) in excel Private Function GetNameList() As String() Dim names() As String Dim...
-
Re: Need to copy excel every Row data to Excel template file Closed
Good Afternoon, I am new to excel macro. I have a excel file with Row data . I want to copy specific cells data from each row and copy to a speci...
-
Sorting contents from columns to Rows Closed
Hi, I have data sets in particular file format. Total no: of rows : 3623 (Column A) Total no: of rate cards: 26 (Column E) Rates for each code...
-
Any way to keep the formatting when using a formula in Excel2007 Closed
I would like to copy the contents and format of a column of cells and paste them in another column using a formula. All columns are formatted as ty...
-
Comparing Data Between Two Spreadsheets Closed
I have two spreadsheets that includes account number, name, and a charge amount for one (positive number) and a waiver amount (negative number) on the...
-
How do I check for a blank cell in a range and replace them Closed
I am looking for a way to check to see if cells in a column are blank and replace the blanks with a character (in the case a ?) in an Excel 2010 works...
-
How to Cycle through 2 different workbooks and adding rows from Closed
Hello, i have 2 workbooks customer and Item customer has 1 sheet named custname which has a list of customer's name in column A (I. E. John, ...
-
color cells based on input Closed
I want to change color of my cells based on an input. eg: If I input 3 in a particular cell, 3 consecutive cells must be highlighted. Any thoughts?
-
Excel 2007 Using vlookup function in VBA Solved/Closed
I have a list of name and employee number in sheet 1 in column a and b.. Then what i want is to by simply typing the employee number in sheet 2 column...
-
Conditional formatting-color a cell based on the value of anothe Closed
Hello, I have 2 columns of cells: R1-R100 & S1-S100. The cells in column R are the sum of cells L2:Q2, etc are is labeled "Expected Time to Process ...
-
Comparing street address in two different worksheets Closed
Greetings collaborators! I would like some assistance with comparing street addresses in two different worksheets. The lists are quite long (thous...
-
I am trying to add 10 days to a "custom" date Closed
In the original cell I am using a custom date format of 00\/00\/0000 and in another cell I am adding 10 days to the date with the simple formula C1+10...
-
Strange problem with a macro Closed
Hi, I've been using an Excel macro for some time that opens another spreadsheet, selects all of the cells, copies them, comes back to the .xlsm wor...
-
automatically transfer data from Excel forms into worksheet Closed
Hello, I have a requirement to automatically extract data contained in Excel Forms, (there could be hundreds of forms) into a worksheet. Any assistan...
-
How to write vba macro in excel 2013 to delete cells in column Closed
I am analyzing data of two column A1-A310632 cell and B1-B310632 cells to check and delete the first 2 columns i.e A1-2,B1-B2 while keeping the nex...
-
hey may I ask you something please? Closed
i have two columns "County" and "County Code" i want to check country code not blank , and country code blank then return a value from a County to a n...
-
Macro for shifting contents of a particular cell Closed
I am trying to create a small macro which helps me copy the contents of a particular sheet (In my case the total of a long list of calculations) as an...
-
format a cell with a comment based on a comment in another cell Solved/Closed
Hi, I need to format a cell with a comment based on a comment in another cell. So cell A1 might ask a question like is the window clean? B2 will...
-
Macro to copy paste without having all the source books opened Solved/Closed
Hello Kioskea users. I hope you're all doing great. Today I have a concern that I'm not able to figure out. Any help will be really appreciated. I...
-
PDF overwriting previous PDF Closed
Hello fellow Kioskeans, When I generate an invoice from my invoice template, it is automatically saved to an "Invoice" folder as a pdf. However, I...
-
Automatically moving cells with data Closed
I have a column of times ie A1 = 00:25 A2 = 00:32 A3 = Nothing or it could be 0 or #N/A A4 = Nothing or it could be 0 or #N/A A5 = 00:27 an...
-
excel Closed
Hello, I have report which consist date 1-30 in that first 15 days different format. last 15 days different format. first 15 days i can change dat...
-
Delete Rows with no conditional formatting highlights Closed
Hi everyone! I have a quick query regarding tidying-up some worksheets I generate regularly that I've been unable to find a solution for despite se...
-
Suppress displaying True or False in a conditional cell Closed
=IF(J7>=$M$4, IF(J7
-
Auto Sort groups of columns Closed
Hello there, I (finally!) figured out the AutoSort macro, but I'd like to take it a step further if possible. I have columns A,B,C,D that I wa...
-
adding cells in excel from diff. sheets Closed
Hello, Is it possible to add cells from different sheets in a single workbook. If so what is the formula? Thanks
-
VBA Code Not working when modified Closed
Hello! I have the following VBA Code on an Excel worksheet, which has been working fine up until today, when I modified it slightly (just changing ...
-
how to convert Date to word in excel Solved/Closed
how to convert Date to word in excel e.g. 05/01/1992 to change Five January, Ninteen Ninty two