Excel Forum
-
Convert date to the English spelling [Closed]
Hello, My date of birth 1-3-1995 Please convert to the English spelling System Configuration: Android / SamsungBrowser 2.0
-
VBA - how to repeat a set number of values X times [Closed]
Hi, I am having an issue with a code I am writing. I want to insert 1,2,3,4 down an empty column X times ( where X will be inserted by the user)...
-
Mac VBA & Excel, auto change image based on a cell [Closed]
Hello, I'm trying to produce a simple excel spreadsheet on my Macbook which automatically changes the image in cell B3 when I change the name in A...
-
Auto populate when changing from quoted to sold? [Closed]
Hello, I am working on a work book in excel for work. On one page, I am tracking quoted / sold cases when a case sell, I have it change colors. ...
-
How do i install excel on my pc [Closed]
how do i install excell on my pc
-
Birthday [Closed]
Hello, 17/03/1996 in word
-
Scale Tab in Format Axis in Excel 2000 Charts [Closed]
Hello, Using Excel 2000 charts, in some files, when I right-click on the horizontal (Date) axis, select the Scale tab in Format Axis, I get a "Time ...
-
Macro which copies formula down to end of row [Closed]
I am new to this this and would be grateful for any assistance with a macro which copies the formula from the cell above and continues in a loop till ...
-
When the field is =N, want to subtract that field [Solved/Closed]
Hello, This formula works, but when the field is =N, I want to subtract that field. What could I add to this formula to make that work? =(COUN...
-
Conditional formatting across multiple columns [Solved/Closed]
Hi there, I have two columns which if equal(unless blank), I wish to fill in with a colour. I have defined the range as the two columns(BX3:BY3) an...
-
MS Excel file error message [Closed]
Hello Folks, There is something wrong with my Excel file. It was working fine on last night. Today, I opened it anf got the following error: S...
-
Conditional formatting across columns [Closed]
I have two columns which if equal(unless blank) I wish to fill in with a colour. I have defined the range as the two columns(BX3:BY3) and specify the ...
-
Data transfer from master to other sheets by type [Closed]
Hello, I'm trying to create a workbook with a master sheet and four subsequent sheets. Ideally the master sheet will be where my admin assistant w...
-
Highlight blank cells if data present within row [Closed]
Hello, So I know it's using conditional formatting but I can't find a formula for what I want. I only want the blank cells highlighted, not the en...
-
Master sheet populating data to other sheets [Closed]
Hello, I'm trying to create a workbook with a master sheet and four subsequent sheets. Ideally the master sheet will be where my admin assistant ...
-
Convert date format [Closed]
Hello, May 1, 2018 Wanted to convert the above date into DD/MM/YYYY in excel. Pls help
-
change data to Date [Closed]
Hello, I am copying data from Access to Excel; the data in Access is a Date, but when it is copied to Excel it is 43190. I have tried to data cha...
-
pasting data in row keeping blank rows [Closed]
Hello, How can i paste data in between three rows ie first 1 copied to next 4 th row (3 rows to be leaved blank)f or a whole work sheet. Sys...
-
Copy conditional formatting for an entire row based on one cell [Solved/Closed]
Hello. I'm working on an Excel sheet, where the entire row is colored based on the values of two cells in the current row. If one of the cells in t...
-
Formula which will highlights the cell in master s [Closed]
Hello, I have a workbook with 30 worksheets and a master sheet. I hyperlinked the worksheets with master sheet. I want to know is there any formul...
-
Copy and paste data from different sheet using vba [Closed]
Hi, I have spent a lot of time to copy data from different sheets to a destination sheet using excel VB by selecting a region from a dropdown list....
-
Transfer data to sheet w/ condition met [Closed]
I have a 4000+ row data set that is continually updated. I need to write a VBA code to ensure that when Sheet1 column A = "N," Sheet1 columns B-G tran...
-
Duplicate rows from multiple worksheets [Solved/Closed]
Hello, I have a workbook that I'm hoping will be the template for a monthly log. It is almost done, but I cannot figure out the best way to perfor...
-
Auto-generate/Populate Excel Worksheets from Data [Closed]
Hello I wonder if anyone could help me. I need to separate a list of data into separate worksheets based on the data in the first column. For examp...
-
Data from one master sheet to 100 other sheet [Closed]
Hello, I have this kind of problem that i have serial numbers xxx-xx-xx listed in 1200 rows in A column of master sheet. I have already macro for ...
-
Look up tables across workbook [Closed]
Hello there! I am currently working on a spreadsheet for my organization. As far as the data is concerned, it is collected by another part of the o...
-
Move that tab to a new workbook [Closed]
Im relatively new to excel macros and have done half of what i need to do. I created a macro that takes data from one tab (which contains a pivot tab...
-
How to insert pictures in Excel using Macro [Closed]
Hi, I'm facing 2 issues in using below code. 1st, suppose the image names are in column B from B2 to B11. Now, if the image against the image name ...
-
Resize cell to match picture size [Closed]
Hello, Using above codes pictures are getting sized but the cell remains the same. pictures are overlapping each other. please help
-
Failing to sign in to excel [Closed]
hie can you be of assistance im failing to sign in to excel it keeps telling me that there is a problem with my account. i have tried resetting the pa...
-
Excel "IF" function w/ date in test cell [Solved/Closed]
Hello, I am trying to use the IF function with a date in the logic test cell; If the logice test cell has a date then I want the word "DONE" to sho...
-
Updating a sheet name in Excel without macros? [Closed]
Hey everyone, I've been working on a project and in order to do it how I was planning, I need to update sheet names dynamically without using macro...
-
calculate how many times member A visit the cafe [Closed]
Hello, member A register at cafe on a date 12 april 2017. He visited the cafe every times started from the registed date when the cafe opened at ...
-
transferdata from 1 sheet to other sheets criteria [Closed]
Greetings! I have been trying to look for vba codes and formulas but am still at a lost as to how to even start. Am a total newbie at this whole vb...
-
Auto Update a workbook with multiple sheets on one sheet of the same workbook. [Closed]
Good pm. I need your help in order to enable me carry out update in ms excel. I have a workbook with multiple sheets (namely, creche , nursery1, ...
-
Table Values used to auto calculate and return val [Closed]
Is there a way in a formula to have Excel continually look in a table, and insert a value in a cell , so that the value in another cell will never be ...
-
VLookup formula gives error [Closed]
=VLOOKUP(A29,'I:\Vending Reports\2018\3. March 2018\[March 2018.xlsm]Crews'!$A$1:$H$370,8,FALSE)+G29 This is my formula. It is supposed to look f...
-
Copy data from one sheet to another [Closed]
How can I copy data from one sheet to another on the basis of value in cell G10, say if value is DELHI then set of column corresponding to delhi will ...
-
Concatenate columns in Excel [Closed]
Hey actually i have a prob, i have 4 columns in my excel sheet, among them based on 2nd column i have to concatenate the contents of 4th column...
-
Pulling in missing data between spreadsheets [Closed]
I receive a spreadsheet every week that has a list of IP addresses of servers that need updates. Not all servers need updates every week so this sprea...
-
Salary calculator in Excel [Closed]
I want to make a salary calculator( in excel ) in which I want to add 3% increment in "basic". My columns are :---- 1. "Month"=march 2017, April 2017 ...
-
Auto populate specific data from sheet to another [Closed]
Hello, I'm trying to auto populate data from one workbook to another, or sheets if that makes it easier. In the sample I've included I'm trying to...
-
Adding fields to formula at one time [Closed]
Hi guys, Not sure if there's a quick way for this: Do you know if possible to do this: Sheet 1 A1 field contains formula: sheet 2 A1 plus sheet 3 ...
-
Excel date conditions [Closed]
I have to go in every 2 weeks to update a spreadsheet, based on whether the date in the row is current or in the past. Is there a way to set it up s...
-
Leaving a Copied Cell Blank if no data [Closed]
I have several spreadsheets containing different information on the same patient. Patient is ID a number. The ID has to copy over to several different...
-
Copying non blank cells from one sheet to another [Closed]
Hi all I have some code here that works great but I am looking at adding in some additions. I am currently struggling and I hope that maybe someone on...
-
Extract missing word from text string [Closed]
Hello, Hello, i have data in 2 columns, for ex: Column A: Bearing, Ball, 1/2 in, Cast Iron Column B: Bearing, Ball, Cast Iron by s...
-
Change color for specific number of cells by value [Solved/Closed]
I have a excel sheet with data of planned and pending projects. In column "I" it states number of weeks required for completion of the project. Each r...
-
Auto populate from master file to other [Solved/Closed]
Hi Good afternoon!! I have a master data file that comprises of data of overall activities of the project including sales,contract value, wo...
-
VBA Copying cells based on if there is a value [Closed]
I have this code which works great thanks to help I received here. I am looking to see if it is even possible to add in some addition functionality. C...
Subscribe To Our Newsletter!
DON'T MISS
- How to Disabled Write Protection on a USB
- How to Recover a Disabled Facebook Account
- How to Recover Your Yahoo Account
- How to Get More Followers on Instagram
- Facebook Code Not Received
- Computer Boots to Black Screen
- How to Get Free Diamonds in Free Fire
- How to Upload High Quality Photos to Instagram
- How to Create a Gmail Account
- How to Fix a Blurry Snapchat Video
- How to Install a VPN