Excel Forum
-
Copy rows to other sheets based on value in column Solved/Closed
Hello, I have worked through this topic and the have modified the code for my worksheet, but I am having a problem with the F5 function. It works...
-
Copying time fields down Closed
Hello, I am attempting to put the time starting at 12:32:44 AM for 128 rows and click up the time by one second to 12:32:45 AM for the next 128 rows...
-
How to change date format in Excel? Closed
Hello, Sir I want change date format in 25-06-2018 to 25th June 2018 How can change 25 in Th letter in upper case Please tell me any one
-
Make userform Solved/Closed
Hello, I need to make a userform and list all sheet names and for each sheet name i need all named ranges from book. Is that possible? Thanks in ad...
-
Copy Cells to Separate Workbook Using VBA Closed
Hello, I am attempting to take a range of data, in this case A1:I42, and copy it to a separate workbook. So I want to copy A1:I42 from Sheet 1 in ...
-
Find in column and Copy it's row code for Google s Closed
Hello, I have created code in MS Excel for finding particular text in column and after finding text the entire row should be copy and add in next sh...
-
VBA code for create a copy of one excel file Closed
Hello, I want a VBA code for create a copy of one excel file that contains all the contents without macros and also I want to send that work...
-
Copy command button in message box Closed
Hello, I want to create copy command button through message box in VBA. In message box the information which is going to reflect should be copie...
-
VBA code for copy & paste items for multiple times Solved/Closed
Hi, I'm a very beginner in VBA and would need this problem solved urgently. I'd like to copy each line item and paste them in a new sheet 9 times. I t...
-
Create sheets for additions to list on sheet one. Solved/Closed
I have a running list of names in a workbook that are kept in alphabetical order on sheet one. Those names are updated daily with new additions. Eac...
-
Overwriting data during transfer Solved/Closed
Sir, I had created vba code to transfer data from one workbook to another. it's working 1st time . but second time when I'm tapping the command butt...
-
Date Formula counting days Closed
Hello, If anyone could help me, I would greatly appreciate it, I need help with counting days if there is not an end date on the report. Ex: Count...
-
How to find the total tax? Closed
The excel sheet below, shows different Items that are either purchased and paid up front, not paid or purchased through layby from AGRIQUIP. If Column...
-
Change date format in Excel Closed
hi there i just need to make 1 cell for a date but with auto population of slashes so if i type 21062018 in the cell it comes up like 21/06/2018 ...
-
Comparing two columns in Excel Closed
Hello, I have to compare the following 4 columns; Code Amount Code Amount 100 213 101 25 101 465 ...
-
Numerical value to appear in D31 automatically Closed
1) Hi there, I'm trying to do a formula in a cell and need some help please. For the sake of this example, I'll be typing certain text into C31 and I'...
-
Autopopulate info from Master to individual WS Closed
Hello, I have a series of data that are categorized by a prefix (P, UR, A, CAPA, etc.). I want to pull only the CAPA record information into a secon...
-
Populate cells in worksheets from an updating list Closed
I have a club workbook with 150 member Worksheets that need to be populated from the members list. First Member is starting with A2 Second A3 etc....
-
VBA code for command button Solved/Closed
hello everyone, i had created a macro enabled workbook (abc123.xlsm)which holds about 10 user forms and every user form complies data to separate wo...
-
Multiple text in a cell Closed
Hi Please can someone help I have text in columns that uses multiple words example, annual leave, sick leave, maternity leave and i want to add...
-
Compiling data in excel Closed
Hello, I am working with a large spreadsheet of contact information for people in my industry. I have columns titled with different interest areas...
-
looking for VBA code. Closed
HELLO EVERYONE, I HAD CREATED A MACRO ENABLED WORKBOOK (ABC123.XLSM)WHICH HOLDS ABOUT 10 USERFORMS AND EVERY USERFORM COMPLIES DATA TO SEPERATE WO...
-
Auto update of data from one sheet to other Closed
Hello, Pls guide me regarding how to update data from one sheet to other in excel. In sheet1, if i update the details of the student it sho...
-
Creating Excel Email Alert For Expiring Dates Closed
Hello, all I want to do is to create a code that will send me an e-mail when one of my docs will be expiring or expired. The problem is that there...
-
Copying and looping data from one file to another Closed
In one tab I have information, where I have made it output the information on a second tab (It's more in depth than this but I tried making this as si...
-
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
-
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...
-
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...
-
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...
-
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...
-
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....
-
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...