Excel Forum
-
macro to rename sheets based off cell value [Closed]
Hello, I have a workbook that I copy each month with dated sheets I would like to be able to rename each sheet based on the date.
-
Apply one macro to multiple rows [Closed]
Hello, So I have a question ragarding VBA. I have a sheet in which there is a column of dates and a column of values. When I input a date it retur...
-
Students Package Payment control [Closed]
Hello, I have the following columns then on SHEET 2(Students Sign Up control) I have a Sign up sheet I enter the student information like na...
-
Copy paste in excel sheet with macro based on matching column [Closed]
Hi, i have two sheets. sheet1 and sheet2, i want copy data from sheet1 in to sheet2 based on one matching column.i have one column called index w...
-
numerical into text [Closed]
I have 2.35 figure but i need to see two dollars and 35 cents in english
-
Need a formula to count the duplication of a value in a range [Closed]
Hello, I need a formula that can count the number of duplication of a particular value in a range of cells. Example: I need to know the count of ...
-
Spreadsheet [Closed]
Hi everyone, I have a question regarding this problem. I want when I enter in one cell code example: C.1.1.2., C.1.1.3, C.1.1.4. ..., that my other...
-
copying data one excel sheet to another with transposing columns [Closed]
We have a spreadsheet with rows and rows of data. Let's say column 1 is name, column 2 is address, column 3 is phone number, column 4 is rep name. L...
-
Select Cells from Column A which are hyperlinked to Sheets [Closed]
Hello, I would like to do the following: 1.Select Cells from Column A in "Index" Sheet which are already hyperlinked to Tab Sheets in the curre...
-
A macro to create new spreadsheet and copy data [Solved/Closed]
Hello, I m a University student and currently learning VBA programming. I have a VBA coursework where i have a file with 63 sheets. is any macro w...
-
Showing the $ value difference [Solved/Closed]
Hello, I am using Excel 2016.. and need some help. I am doing a budgeting sheet and cant figure out how to do the following; Column A - Budget $ ...
-
Formula does not stay the same! [Closed]
Hello, I am using Excel to keep records of different Projects. I have One general Worksheet and a good 20 Worksheets that follow for each individu...
-
Subtotal [Closed]
Hello, Im using subtotal and it isn't changing when i hide values. =SUBTOTAL(109,A42:GA42) Configuration: Windows 7 / Chrome 46.0.2490.86
-
Tell excel where to look [Solved/Closed]
Hello, I am trying to make a cell return a word when you tell it which cell to look in for that word. If i type J2 in a box i want a cell to then l...
-
Copying rows when inserting a column [Closed]
Hello, everyone I have a problem with my database I am inserting new columns when there is a new company added and the go between two existing columns...
-
Copying Conditional Formatting to Several Cells Then Editing [Closed]
I'll start off by saying I am a novice (at best) when it comes to using Excel. WHile I have figured out some things I am sure I am probably not doing ...
-
Excel: If Date =, then enter a value [Solved/Closed]
I am using this formula and it works well: =IF(A8=DATE(2015,3,27),"1","--") How do I now create a string to check a number of dates (company holid...
-
Auto Copy based on Condition [Closed]
Hello, I have developed an Auditing sheet in Excel in which the results are copied into a Word document to create an audit summary report. How d...
-
Adding two non-adjacent cells (number and text) [Solved/Closed]
Hello, I seem to be having a problem with a nested IF(statement) I am on a separate worksheet that I use to calculate my formulas for my summary page....
-
Connecting Excel database to the company's website [Closed]
Hello everyone and thank you for any help on this problem that I have. My boss just asked me to connect the excel database I am finishing up on cre...
-
Drawback of Copy and Clear code [Solved/Closed]
Hello, I have requested that please solve this issued if it could be solved. I have found major drawback (May be I am wrong) in the code of Copy ...
-
Macro to create list from master sheet [Closed]
Hi! I need to create a macro that will generate individual lists for employees based off a master sheet. on my master sheet (that is what the sheet...
-
changing a frequency into a list [Closed]
Hello, I have a list of names and numbers and I would like the list in full i.e. jane 4 chris 2 result jane jane jane jane chris chri...
-
Dynamic Hyperlinks [Closed]
Hello, I'm currently working on a spreadsheet which has links to external files for example A1 - link 1 - file1.pdf A2 - link 2 - file2.pdf A3 - li...
-
how to copy a data of a workbook to another work book [Closed]
Dear All, i have a folder namelly dealer1 which is having 20 excel file & each excel files containing 10 sheets, now i want to copy all the exc...
-
Find which stock #s are on both spreadsheets [Closed]
Hello, I have two excel spreadsheets. I want to know how I can find out which stock numbers are on both spreadsheets. Do I use VLOOKUP and if ...
-
Transfer of data to other sheet [Closed]
If I put a name in cell AC4 then I want to transfer value of cell A4 & Y4 to other sheet. Can some some help me in this matter. Thanks Musharaf
-
Compare data in 2 spreadsheets [Closed]
Hello - I have two 2 spreadsheets. I want to find out which stock numbers are on both spreadsheets. Should I use VLOOKUP and if so - can s...
-
Positioning in Excel [Closed]
I have aproblem with positioning in excel and i have been doing this but i have failed can you give me an assistance like by positioning them lyke 1s...
-
Excel multiple IF conditions [Closed]
Hi I have 9 different descriptions of trailer loads in Column D (they are programmed so I can choose them from a drop down list). Then in Column F ...
-
bring back a value (customer Id) [Closed]
Hello, I need to bring back a value (customer Id) into Column J if column A from that workbook and Column A from another workbook are a match. T...
-
Conditional formating with If statements [Closed]
I want to do conditional formatting. But my numbers change if a certain box is checked..... how do I accomplish this??? i.e. A regular clean would...
-
Return header if word within cell matches word within any array [Closed]
Hello guys, I'm trying to classify a cell [G1] based on particular words found within 2 columns [D1 & E1]. This classification copies down from [...
-
how to extract target value from other cell [Solved/Closed]
Hello, I would like to request that Suppose this line of code is working for Column B MsgBox "You entered is Invalid" this will show the m...
-
excel is automatically changing dates to a numeric code [Solved/Closed]
Hello, I'm using Excel and when I put a date in a column it changes to a numeric code. For example: 4/5/15 now reads 42099. I've tried highlightin...
-
Excel Macro [Closed]
WPS require an automated process for adding new suppliers into the "Resource Management" workbook. There is data for three new suppliers (Agenda Corpo...
-
Formula for Date Comparison [Closed]
Hello, Configuration: Windows 7 / Internet Explorer 9.0 I am looking for a formula that will compare two columns with dates. It would be co...
-
Copy data to a different folder [Closed]
Hi All.. i need a macro to copy data from one sheet to another in a different workbook and folder. There are 2 folders which contains files of same...
-
Cut Copy Paste Option [Closed]
Hello, I would like to request if user copy data from "ExcFileB" Sheet1 to "ExcFileA" Sheet1 then it always Pasted as Values. Is this possible i...
-
Protecting your formulas in multiple worksheets [Solved/Closed]
Hello everyone, thank you in advance for any help I receive with is question. I have multiple worksheets in a workbook that have formulas in them b...
-
Data Validation Formula changes to VBA Code [Closed]
Hi The Below formula =IF(OR(D2="Best",D2="Worst"),FALSE,TRUE) used in Data Validation for Column E I would like to request that it could changes t...
-
Fix The Code [Solved/Closed]
Hello, Its being requested please fix the code given below the problem in this code is that any one of the given condition execute and once ...
-
Date format changes when editing it [Solved/Closed]
Hi, I'm using Excel 2007. I've changed the date format to dd/mm/yyyy with no problems. However, as soon as I begin to edit a date, it changes to...
-
Copying entries from multiple sheets to new sheet, then summing [Solved/Closed]
I run a weekly pub trivia and I use a spreadsheet to keep track of cumulative scores. There are 6 sheets in the file... Week 1 Week 2 Week 3 W...
-
Merge two macros of 2 diffrent workbooks [Solved/Closed]
Hello, I have 2 macros in 2 different workbook Currently i have to run 1 st macro(!st work book),then open 2nd macro workbook then have to run...
-
Macro needed that looks up part id and returns part id [Closed]
Hello, I need a macro that looks at 13+ sheets and locates the part id that is on the master sheet and returns the value under the Parent ID that ...
-
Remove or Clear Data [Solved/Closed]
Hello, I am grateful if this query be solved. If user Enter any value in C2 and also user enter "Best" or "Worst" in Cell D2, how it may clear th...
-
enter data to run command button [Closed]
Hello, How can I prevent a command button from running before data is entered into a cell? I have a workbook that refreshes data based on when a...
-
Multiple If in Data Validation [Solved/Closed]
Hello, Its being requested please help in the below multiple IF function used in Data Validation =IF(ISNUMBER(E2),AND(E2>0,E2
-
formula - if (text), "text" [Closed]
If a column has a number entered into it, the second column needs to auto populate with corresponding text. eg column I: User enters "22" co...
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover a Disabled Facebook Account
- How to Fix a Blurry Snapchat Video
- How to Upload High Quality Photos to Instagram
- How to Create a Gmail Account
- How to Install a VPN
- How to Recover Your Yahoo Account
- Computer Boots to Black Screen
- Facebook Code Not Received
- How to Get More Followers on Instagram
- How to Get Free Diamonds in Free Fire
- How to Disabled Write Protection on a USB