Excel Forum
-
Macro to Copy [Closed]
I am new to writing macros but need help in creating one to copy data from one cell to another with conditions. I have two spreadsheets merged from t...
-
Copy and Paste Multiple [Closed]
Hi I'm looking for away to be able to copy a single cell from multiple sheets (tabs) for example cell a1 and list it's contents on a separate summ...
-
Auto Populate record from one sheet to another [Closed]
Hello, I'm working on a commissions spreadsheet for my company and would appreciate some assistance with a question I have. There is a separate ta...
-
Data Link [Closed]
Hello, I'm needing help please, I'm trying to figure out how to either: Link an Access database to an Excel Spreadsheet where it has a templ...
-
Copy data ranges from multiple excel worksheets [Closed]
Hello, I have a series of worksheets all with identical formats but different data information. I want to take information in cell ranges e30..k...
-
Search for text and copy [Closed]
Hello, I have two columns, A contains the list of a company and C contains emails. I would like to search the email column for emails containing ...
-
conditionally format a cell so it turns a certain colour [Closed]
I was wondering how to conditionally format a cell so it turns a certain colour when it goes past a certain date. Thanks
-
Conditional formatting colour fill [Closed]
Hi all, I want to set up a cell in Excel with solid fill depending on % completion of other tasks. The data bar conditional format will do it, but ...
-
If, and question [Closed]
Hello, I'm trying to work a formula that will change a given value in one based on dates going into several different cells. Example. If I pour a co...
-
Column to vlookup [Solved/Closed]
I am trying to write a formula that will give me the value in a cell, it needs to come from two sources. I must be able to locate the column based on ...
-
IF function with Time duration [Closed]
Hello, I dont understanding why this can't work : =IF((g2=timevalue("0:30"));"25) G2 has a time duration time unit in it which equals 0:30. ...
-
Disable a cell in excel using VB code [Solved/Closed]
Hello, I am looking for a VB code to disable a cell based on the value of another cell in excel. Example:- Need to disable Cell B1/C1/D1 based o...
-
Create a button with some conditions [Closed]
Hello, please if anyone can help on this it will be gratefull. I need a button to create a new sheet, but when you press it, which ask you assign nam...
-
Formula cross work book [Closed]
Hello, I am trying to write a formula to automate a stock spread sheet so when a product is sold it deducts from the stock holding, all stock items...
-
convert date into word [Closed]
please send me code of conversion for date to text i.e. first jaunary nineteen seventy six instead of 01/01/1976
-
conditioning formula to convert "x" into another cells value [Closed]
good morning, I have a spreadsheet I am trying to create for a chili cookoff, I am trying to find a way to type an "x"(or any text) in a box showin...
-
Data Transfer [Closed]
Hello, I'm trying to get a spreadsheet that I've set up as a template for Commercial invoices to have particular fields populate with other data suc...
-
User Friendly Code for Admission No [Solved/Closed]
Hello, I would like to request to Code for Admission No Range is started from B11 to B510 If user enter a123456789 or a-123456789 it always conv...
-
Excel 2013 Format Time cells not to include date [Closed]
Hello, I am trying to create a simple time sheet with cells formatted as h:mm AM/PM. I have formatted the cells through this option in the Custom ...
-
Days of the week conditions [Closed]
Hello, I am trying to create a template for my work. I have a table sorted by dates but need to reference the day of the week that date falls on....
-
If one cell G4 has value 12345 then cell F4 will have.... [Solved/Closed]
I need help with a basic excel formula. Please :) If cell G4 equals 12345 then cell F4 equals USXX but also if cell G4 equals 54321 then cell F4 w...
-
data export [Closed]
Hello, I made a questionnaire generator for various kinds of products according to an advice from this forum. The original topic is here: https://...
-
How do i Convert a value in a cell to english string? [Closed]
Hello, Would like to know is there anyway that I can convert the value in a cell to english string? eg "1,220.76" in a cell and convert it to a...
-
Insert data to the empty cell below [Closed]
Hi, I need a macro to insert data from one cell to another below (empty cell/the same column) for ex: I need to insert data from A1 to A2 then data...
-
Fill in blank rows [Closed]
Is there any formula or Macro that I can use to fill in blank rows from the last cell above that has data in it. For example, I have a spreadsheet wi...
-
Auto Copy Row from one Sheet to another via Info in first Cell [Solved/Closed]
Hello everyone, hope you all had a great New Year. I am in the process of exporting a BOM out of Inventor and then opening it with Excel. Once I ha...
-
Copy Data from main sheet to next first 5 consecutive Sheets [Closed]
Hello, I would like to request a macro that copies data from any Main Sheet (Sheet Name could be in Numeric) Main Sheet range is specified i.e. B1...
-
Creating A Summary Sheet [Closed]
Hello, I have a worksheet that is recording customer interactions, and I would like to create a seperate sheet to summarize all the customers that ...
-
if Font color is red then.... [Closed]
Hello, I would like to request that if the font color of cell A is red then how to apply the conditional to cell B that it changes to as per our r...
-
Look up a word, then input a word from cell adjacent [Closed]
Hello, Im looking for a way; in excel, to search for a word, find the word then take a value from the cell directly adjacent to that cell. For examp...
-
Copy value from sheet 2 to next blank cell in sheet 1 [Closed]
Hello, I have a worksheet that works out golf handicaps from the score entered, what I need is a macro that copies the score from sheet2 A1 to the n...
-
Button to copy sum to next row on another sheet [Closed]
Hi, I think i have almost go this (pretty new with vba). On first sheet 'comparison' i have a few variables which can be changed then the sum of...
-
excel 2103 [Closed]
Hello, I am having trouble I have 1 workday starting on 2/19 and ending on 2/19 the value comes back as 0 when I enter the workday formula how do ...
-
Barcode Help!! [Closed]
Hello, I am making a barcode system and I want to be able to display the information given in the barcode in the cells next to it. For example I a...
-
Auto Populate record from one sheet to another [Closed]
I'm working on a commissions spreadsheet for my company. There is a separate tab for each sales rep as well as the Sales Director. For every record ...
-
How do I exclude a value when using COUNTA? [Closed]
Hello, I am currently using the following formula to count cells that are not empty =COUNTA (D4:D17) However in this range there are certain...
-
automatically send lines of data to sheets from a master [Closed]
Hello, i have a master sheet of over 2000 entries, one of the columns is "category" based on this category i want to send the whole line of data t...
-
Cant get vba code to work as desired... [Closed]
Hi, Looking for a solution to the following issue with some vba code I was kindly given. 1) I have a scenario where if a user leaves one or more...
-
Automatic transfer of data [Closed]
Dear CCM, I have a sheet with combined values for different units and I manually sort into the different units manually by copying and pasting into ...
-
excel [Closed]
Hello, if the column a and column b are equal, i want to put "-"(minus sign) before the data of column b for further technical purpose. eg. it lo...
-
How to compare data between two excel files [Closed]
Hello, I want to know the easiest way to compare data between two different Excel files.Both the files are same in structure but data can be diffe...
-
VBA: Creating new Sheets based on copy, Nameing them the Cells [Closed]
Ok, i am gonna try to be so clear i can. on Sheet 1 (Start Sida) i have a list from cells A9 to A500 with names. atm only A9-A52 have names in them. ...
-
Average a range of data with leaving out one value each time [Closed]
Hello, I'm trying to write a macro to calculate the onset time of LRP. I need to average 30 columns with leaving out one column each time. For exa...
-
How to copy values in sheet 1 to sheet2 based on column name [Closed]
Hi, please help with the query here. I have set of data in sheet 1 and sheet 2. Sheet 2 is the source data. Sheet 1 contains the data after it's confi...
-
Need the number of rows with exact criteria from 2 columns [Closed]
Hello, I'm trying to create a formula that tells me how many rows fit the specific criteria. I have my data on my first tab. The first crucial infor...
-
how can I multiply a numeric value and alphabetic value in exce? [Closed]
Hello,plz answer as soon as possible
-
Difficult Query [Closed]
Hello, I would like to request for a difficult query that may be not solvable logically. If user enter az123456789 or az-123456789 it always co...
-
autofill a column according to values in another column [Closed]
Hello, I need to autofill a column according to certain data in another column It goes like this Column B contains various data including a ...
-
Automatically transfer data from one worksheet to various others [Closed]
Hi, I am trying to figure out how to automatically transfer data from one excel worksheet to another worksheet but only when a specific cell(s) ar...
-
Automatically transfering data after generating new worksheets [Closed]
Hello, It has been a while since I have worked with code and would appreciate any help. I have one code already working which is gathering all ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Install a VPN
- Facebook Code Not Received
- How to Recover a Disabled Facebook Account
- How to Create a Gmail Account
- How to Get Free Diamonds in Free Fire
- Computer Boots to Black Screen
- How to Fix a Blurry Snapchat Video
- How to Get More Followers on Instagram
- How to Disabled Write Protection on a USB
- How to Upload High Quality Photos to Instagram
- How to Recover Your Yahoo Account