Excel Forum
-
formula for multi answers Closed
Hello, I'm not yet a member, first time user, however interested to be registered as soon. Hi looking for the right formula for the following....
-
Paste Values copied in alternate rows in a single column Closed
Hello, I need to paste some data from 1 column to another column but in alternate rows. for Example:- Data to be copied is as below. Cell Valu...
-
Autopopulate from master sheet? Closed
Hello, I've been making, essentially, copies of my and my husbands pay stubs. Currently I'm just copy pasting an "empty pay stub form" and manuall...
-
copy and insert rows Closed
Hi, Everyone! I just need help I need a formula or a macro code that everytime I will manually type something on column a,b,c it will be also ge...
-
Changing current font color based on other cell's value? Closed
Hello! I would like to change the default font color when entering text in Column B based on the text in a different cell. BUT, I would like to ret...
-
Removing FALSE from return Closed
Hello, I have this formula that returns FALSE, can someone tell me how to remove this? Thanks, Ed =IF(Tama!E8,+(Tama!C8))
-
Date with condition Closed
Hello, What could be the answer and how If function play Three or more condition applying in date formula? Problem A=Employment Type, B=Join...
-
Update sheet - may be by using a macro Closed
Hello, I am trying to make a kind of template file which will be used by different users, most of them even more simple excel users than me :-) The ...
-
VBA/Copy Paste Closed
Hello, I have a dataset with 300 rows and 10 columns. the first 4 columns have the metadata and then 6 columns with different values. what I want t...
-
Sum product and countif Closed
Hi, I'm trying to calculate the number of each type item on the column B that has the condition X on the column A and wich numbers on the column C ...
-
Move cells based on their values Closed
Hi, I did this a few years ago once but I can't remember how I got it to work. I have 2 sheets named BOQ and V.O. The BOQ sheet has a list of items ...
-
Update sheet by macro Closed
Once a month I want to import data from an external workbook to my excel sheet (let's call it "Master") and change some of the content in Master, both...
-
Paste two columns under each other for multiple columns Closed
Hello, I am new to VBA coding and trying to get things sorted for an excel document (work purpose). Unfortunately I am stuck in a [articular step un...
-
Paste 2 columns under each other for multiple columns with the s Closed
Hello, I am looking for a code to paste series of 2 columns under each other. Ex: Sheet1 1 Col 1 Col 2 Col 3 Col 4 2 ABC DEF GHI JKL 3 MON PQR...
-
Help with Excel Closed
Hello, I have two excel files. one is a staging inventory and the second one is the a delivery file. The inventory files has all assets number, seri...
-
VBA Paste based on Date Criteria Closed
Hello, I would be very grateful for some assistance with this spreadsheet I am attempting to create. I've Googled what I am trying to do several tim...
-
Possible to copy/paste row based on dates? Closed
Greetings, I would like to automatically copy rows from one worksheet into another based on dates contained in each sheet. The rows containing the da...
-
Paint cell based on another cell value with Macro Closed
Hello, I want to paint one cell, based on value of another cell using Macro. And i want Macro to do that for entire column. Example: COLUMN A ...
-
VBA Paste below row with Dates Criteria Closed
Hopefully someone can help me. I've Googled this several times and couldn't quite get the answer I'm looking for. I have data that I load and sort e...
-
Two excel sheets copy new data input on one sheet to new row on Closed
Hello, I have an excel spreadsheet that I have to update periodically overwriting old data. I have another sheet where I need to update the same inf...
-
i am mahi solve it Closed
Hello, =IF(ISERROR(SEARCH("*keyword*",A1,1)),"","keyword") it is only for one cell it perfectly ok for multiple cell its not ok this formula how...
-
Need To extract data from a column to another worksheet. Closed
Hello, I need code to extract all data containing a name from a column on sheet1 and copy it to Sheet2 and remove all blanks. The name is pulled fo...
-
Excel problem Solved/Closed
Hello, I want a formula in which, If I enter the number in cell, the name of that number should appear in adjacent cell. Ex: Emp No Name 1 ...
-
Populate a work schedule based on a matrix on a separate sheet Closed
I am trying to populate a work schedule on one sheet of a workbook based on a date matrix on a separate sheet of the workbook. I have a list of nam...
-
How to solve Date Format dd/mm/yyyy Closed
Hello, How to solve Date Format dd/mm/yyyy
-
Help with Index Match or VLOOKUP Closed
Hello, I have a worksheet with about 2000 rows. In column C and Column J i have a common Key. In Column K I have data that i want to write to Colu...
-
EXCEL: If number in 2 sheets match, transfer row to third sheet Closed
Hello! I have a question. I'm going to try to be as clear as possible. I have sheet 1 that contains all customers who are NOT on paperless billing. ...
-
Need help with storing data Closed
Hello Guys I am new to ccm.net and excel. My question is, how can i save one excel data to another .. Let me explain in detail... I want to make a ...
-
inches and feet and degrees Closed
Hello :) I have a same invoice which I need everyday to be printed out for me but it need to be upgraded each time with different information and date...
-
VBA; Copy data between workbooks where sheet name is same Closed
I have raw data (.xls) and using a macro I can tidy this up (adding header, text to number etc.) I then rename the sheet for the corresponding month a...
-
Copy sheet, change sheet name, change cell number, etc Closed
Hello, I am completely new to macros, so please forgive me upfront. Through online tutorials I was able to add a macro button and copy the sheet. H...
-
Highlight one value in a dropdown menu of three responses Solved/Closed
Hello, I have a template where we are asking for responses with a drop down that includes Y, N, and N/A. We want to highlight all N answers in yell...
-
Create new excel files based on the data in a column Closed
Hello, I've spent hours searching and trying different macros with no avail. I'm not new to excel, but new to macros and coding. I have a spreadshee...
-
Code to move rows into another sheet based on certain values Solved/Closed
I'm having trouble figuring out how to do something! I have a sheet (Sheet1) with customer details on it (columns A-D will have data in). I want to be...
-
Count only cells containing 2 given words Closed
Dear friends, I simply get mad trying and trying again to find the right function that may help me to count out of an array only the cells that conta...
-
Copy Data from Sheet 1 to Sheet 2 Closed
I need to copy data from sheet 1 to sheet 2 based on a Keyword or search criteria. However, the data is available in hierarchical format. I need a pr...
-
Cell to populate if other column has any text Closed
Hello, I'm struggling to find a formula to populate one column's cell based on another column's cell having at least one character of text. e.g. A1...
-
Change cell text based on another cell's color Closed
Hello, I need to prompt a cell to write text based on another's cell color in excel but not using VB. Can you help? System Configuration: Windows /...
-
Paste Values copied in alternate rows in a single column Closed
Hello, I need to paste some data from 1 column to another column but in alternate rows. for Example:- Data to be copied is as below. Cell Val...
-
vba code Closed
Hello, I need to compare 2 excel worksheets. sheet1 - col A, B, C sheet 2 - col A, B, C Compare Col A and B of sheet 1 and 2 --> if they match th...
-
add "only" at last after converting numbers into words ? Closed
Hello, how to put "only" at last after converting numbers into words ? thank you System Configuration: Windows / Chrome 56.0.2924.87
-
Merging Mutiple Sheets column data when if conditions passes Closed
Hello, I have excel book with multiple sheets. Rows count with data will differ in each sheets. And column C with have two data "Come" & "Out" Wh...
-
Insert picture in Excel macro which takes the file name refrence Closed
Hello Friends, Kindly help me! I am trying to insert a picture in excel macro which takes the file name reference from the D5 cell and insert th...
-
VBA code for deleting rows where a column does not correspond Closed
Hello I am trying to get a code that will delete lines where the column on one sheet does not correspond to the criteria in another (i.e. the date - ...
-
Formula for text in a cell and then total the amount on text Closed
Hello im trying to total the shfit allowance on timesheets eg: In cell k7 they will leave blank if not claim shift allowance, but if they are then ce...
-
Changing font color Closed
Hello, I need help, I want to change the font color to be black for cell A, if cell B is "done", else keep the due date in red in cell B. For exmp:...
-
Create a new Excel file based on data in column Closed
Hello, I've spent hours searching and trying different macros with no avail. I'm not new to excel, but new to macros and coding. I have a spreadshee...
-
Change Value of Subsequent Cells Once A Condition Is Met Closed
The simplified story: I have a user input "Start Month" that is between 1-12. I have Columns A:M labeled accordingly 1-12. The question: If the us...
-
Date change Closed
The interfaced data date from an EMR system to my system reported as an Excel has the date with Year, month and date, example 2017-01-15. I am trying...
-
Excel formulla Solved/Closed
Hello, I want to split cell of available qty in to multiple cell according to requirement. Input Sheet -1 Material PO qty Req. Qty ...
