Excel Forum
-
adding a loop to macro to insert pictures [Solved/Closed]
Hello, Could someone please help me in writing a loop in this macro in excel : I have an excel sheet where it contains the name of the pictures in c...
-
I want to label specific cells with numbers in a sequence [Closed]
Hello, I am trying to write a script that has the below functionality: - From top of sheet, check cells with a value in a specific row - Replac...
-
Color Coding variable Pivot Row Label Interior [Closed]
Hello All I have a coding problem I have tried numerous ways to solve with no success. I have a macro generating a pivot table for weekly data tha...
-
Problem with adding and updating comments from value in VBA [Closed]
Hello and Greetings, Thank you for taking the time to read my post; I do appreciate it. I have been struggling with a trying to write a specific VB...
-
Entering a range of data in an IF formula [Closed]
Hello, I am trying to write a formula where: if any of the values in colum B are equal to the values in column M, then an email address in N1 will po...
-
using if condition in excel sheet. [Closed]
Hello, I need the Formula in Excel sheet If A2 is having a date. I need the date on C2 After 2 days. If the second day is Saturday it should b...
-
excel assistance [Closed]
Hello, Can i PLEASE get some help with this problem? 5KM or more and less than 15km, the cost will be 5... Thanks to everyone in advance
-
transfer 5000 records to a new spreadsheets with 50 records in e [Closed]
I have a excel file which contains 5000 recores, i want to transfer 5000 records to a new spreadsheets with 50 records in each new spreadsheets i.e to...
-
Help in Duplicating Row Info based on adjoining Cell Response [Closed]
Hello, I am seeking assistance in determining the best way to complete a worksheet wherein I need to create a new row which duplicates some inform...
-
A Macro to repopulate a row into a new row based on the response [Closed]
Hello, I would like a macro that would repopulate a new row based on the results of a cell within that row. Example: Project A Complete...
-
How to export data from different tabs in Excel [Closed]
Hi, I need help with a spreadsheet that has 4 tabs. My tabs are: Manager, Analyst_1, Analyst_2 and Analyst_3. I need a formula that can t...
-
VBA code to update excel comments when the cell value changes [Closed]
I have a workbook with several worksheet tabs. One of the worksheet tab contains a column of percentages (that are composed of a VLookup formula from ...
-
Change calculated to a hard date [Solved/Closed]
I used a +1 formula to create dates in column A. Now I want to make these "hard" dates so they don't keep changing every time I add a row. Thank you...
-
VBA : Copy "Pivot like layout" to "data dump layout" data [Closed]
Hello, I am looking for a solution to my challenge. I have a spreadsheet that looks like this. Name - Column Name 1 - Column Name 2 Column...
-
Create a search box and then copy to new worksheet. Please help [Closed]
Hello, this is what I have so far by searching online and it is not working :( It keeps sending me a message " Variable not defined " Please help me ...
-
Macro creation [Closed]
I need to combine data in two different Excel worksheets. 1. list with user names and their ids and groups and to input this data to the list with j...
-
Excel-Changing calculated dates to "hard" dates [Closed]
Hello, I used a simple +1 formula to create dates in column A. Now that I have the dates, I want to make them "hard" dates so they don't change eve...
-
Changing cell color with either conditional formatting or macro [Closed]
Excel 2003 or 2007, 3 preferred. I have a column 'E' that contains either 2 or 4 digit text codes (MR, SP, BA SC, EU WO, etc), up to 50 unique codes....
-
Auto Fill Form? [Closed]
Hello, I have a spreadsheet on which I have formulas for all my recipes. I have a column that I enter the amount of each recipe I want to mix. I h...
-
If function with date [Closed]
Hello, The concept is "If the days exceeds 30, the entire cell should be applied with some color or highlighted". Please respond Configurati...
-
VBA code to copy "Pivot like layout" to "data dump layout" d [Closed]
Hello, I have a spreadsheet that looks like this. Name - Column Name 1 - Column Name 2 Column Name 3 - Column Name 4 Johnny - 5 - 0 - 0 - 4 ...
-
Macro is not working [Closed]
Hello, The first time the macro worked, I was so happy! (I used it once) Now is not working anymore, no idea why. Can someone help me? I rea...
-
Filter according to 'typed' value [Closed]
Hello, I need an autofilter to change according to a 'typed' value on another worksheet. I have found this code, which works when the typed val...
-
conditional replication of cell data [Closed]
I am using Excel 2013 I am using a spreadsheet for a TO DO list. The column headings are: "Item" (with rows numbered from 1, 2....) "Task Descri...
-
move data from one wrksheet to another using submit button [Closed]
hello im working on a project and ive create a workbook in which I place data into a worksheet known as "processing" which serves as a main page in w...
-
changing of number into word [Closed]
Hello, Can you please help me how to change number into word in Excel 2007 Configuration: Windows 8 / Chrome 40.0.2214.115
-
Transpose convert columns to rows macro for excel [Closed]
Issue I have huge data in a single column & each data group is seprated by single empty cell For Example : Company Name 1 Address ...
-
Transferring numbers to new worksheet automatically [Solved/Closed]
Hello, I'm making a spreadsheet showing weekly costs. I've set it up so that each worksheet is a week, with totals using =SUM. I want to transfer th...
-
Notification [Closed]
Hello, I was wondering if it is possible to create a popup when a user has a shared excel spreadsheet open preventing others from using it. The popup ...
-
convert number into words [Closed]
how i can convert numircal in words
-
Excel Picture Inserting Macro [Closed]
Hello, I found the forum on how to insert a picture into Excel with a macro by Rizvisa and it does exactly what I want. However; I'm new to VBA code...
-
nested IF(and()) from a drop down list [Closed]
Hello, Using 2 drop down toggle lists. Both lists are of the same names but I want a different cell to return a value if list one has a few specif...
-
Macro to create tabs and populate from other worksheets [Solved/Closed]
I already posted this on the programming forum but have not had any responses as yet so I am trying here as it may be more appropriate. Current Set...
-
how to change the date of weekends in excel? [Closed]
Hello, how to change the date of weekends in excel? pls help me.. thanks! Configuration: Windows XP / Internet Explorer 7.0
-
Macro to complete date form [Closed]
Hello, I've got a spreadsheet with the Month in the top left "A5:B7" merged cells, the numerical days of the week (only Mon-Fri) on the right "L9:...
-
Calculate the number of days in any given year [Closed]
Hello, I am trying to determine how many days in each year so I can calculate costs based upon the number of days. I have the following columns ...
-
how to insert rows in excel, when criteria is met ??? [Closed]
Sir, how to insert rows in excel, when criteria is met ??? Regards
-
Excel 2013 cursor icon direction [Closed]
Hi, When inserting text in left to right language icon direction is changed as expected to the right direction. However, when changing language ag...
-
Single line macro required [Closed]
Hallo I have data in this format: Please help me with a macro that will convert it to this format : This macro should run until all the da...
-
How to automatically change a cell using Macro's [Closed]
Hello, I have a spreadsheet that has a whole bunch of "½" in it that excel doesn't recognize as the number "0.5". Currently I have to manually cha...
-
How to transfer lines of txt from one sheet to another sheet? [Solved/Closed]
Hello, I have an excel file that has 2 sheets of relevant information that I need excel to logically determine line up and from there automaticly ...
-
vba to auto insert comment (by vlookup list) on cell data entry [Closed]
I have built an accounting program three columns of which are named Vat Number, Debit, and Credit I need that each time I make an entry into any cel...
-
Dates in Excel [Closed]
I am trying to format the dates in Excel. The spread sheet is used for pay roll and as an example in row 4, column c and column f, I would like to hav...
-
transfer full row based on one column on multiple sheet to one [Closed]
I am new to this, and never did codes for Excel. But I need help. I have a workbook with 4 tabs: Summary, Project A, Project B, Project C. On Project ...
-
Please help me these extremely difficult exercises [Closed]
Hello, Hello everyone, I have an exercise about if function in excel. Honestly, I did pretty well the previous assignments but this one is much com...
-
How to copy Conditional Formatting [Closed]
Hello, This is my problem. Example: A1:E1 contain multiple text & number If F7=0 then A1:E1 change to RED If F7=1 then A1:E1 change to G...
-
covert numbers to words [Closed]
Hello, how do we convert numbers into words in excel Configuration: Windows 7 / Chrome 40.0.2214.115
-
convert numbers into word [Closed]
How do we convert numbers into words format in excel
-
Colour code Pivot Row labels - number of labels variable [Closed]
Hi I have a macro in progress of development to create pivot table based on a constantly varying number of row labels eg "A1", "B16", "B32", "C18" et...
-
Solver Macro [Closed]
Hello dears, I will be glad if you help me in resolving the below brain challenging case An excel sheet with 1000 rows for unique names and wha...
Subscribe To Our Newsletter!
DON'T MISS
- How to Fix a Blurry Snapchat Video
- How to Install a VPN
- How to Get More Followers on Instagram
- How to Recover Your Yahoo Account
- How to Upload High Quality Photos to Instagram
- Facebook Code Not Received
- How to Create a Gmail Account
- Computer Boots to Black Screen
- How to Disabled Write Protection on a USB
- How to Recover a Disabled Facebook Account
- How to Get Free Diamonds in Free Fire