Excel Forum
-
Only partial return of search for copy and paste rows [Closed]
Hello, I have a workbook with multiple worksheets with same format that has data in A4:K15 that I would like to search by any field and have the r...
-
copy paste cells to another sheet when criteria met [Closed]
Hello, I'm new to Macros and can't figure this one out. The data (numbers) read top to bottom, left to right, row by row. Some of the cells are h...
-
Activate Cells after Data Entry @A1 or Cell 1 [Closed]
Hello Guys, Would you mind to help me on how to disable the rest of the cells unless upon inputting data on the first blank cell. (e.g., I input cha...
-
VBA Color cell in workbook based on value in other workbook [Closed]
Hello everyone I needed a little help with a VBA macro. I have multiple sheets with data and I was wondering if a Macro could be written to pick up...
-
VBA Macro Help [Closed]
So i have multiple sheets with data and i was wondering if a Macro could be written to pick up values from one excel file and color the cell in anothe...
-
Create Macro to insert the editor's name, date and time [Closed]
Hello, I would like seek some advise from expert to do the following: To create a macro box in excel. While I click on the box, the specific ce...
-
Search workbook and copy row results to worksheet [Closed]
Hi, brand new to the site, but saw multiple posts that seem very close to what I am looking for. I have a workbook with 31 sheets that contain info i...
-
If a cell A contains X then display cell B value [Closed]
Hello, How to get the cell B value when Call A1 is X the display what ever is there in Cell B1 as in Cell C. If not the leave the column blank or ...
-
Macro for the sheet where the master details are available. [Closed]
Hello, Configuration: Windows 7 / Firefox 44.0 I would like to know how to create a Macro for the sheet where the master details are availa...
-
Checking Spreadssheet against Raw Data [Closed]
Hello, I'm fairly new here. Let me thank you for your input in advance. I've created a master workbook with spreadsheets of the different system...
-
If cell equals text, then value/Formula [Closed]
Hello, BACKGROUND: I am working on a budget and I'm paying down debt using a waterfall. I have a list of debts on a "Data Entry" tab, and I have ...
-
Formula in Excel [Closed]
If I have a master document with alpha numeric values in column A lets say for example Sku001 through sku099, in column B is the corresponding value ...
-
use date to return value of 1 [Closed]
Hi, can anyone tell me how to use the entry of a date field to return a value of 1 in Excel? I need to tabulate items where a date is the entered reco...
-
formula [Solved/Closed]
Hi please I am looking for a formula to get difference between 2 sheets example sheet 1 sheet 2 ndc quantity nd...
-
i need a difference between 2 colums in diffrent sheets [Closed]
Hi example sheet 1 sheet 2 ndc quantity ndc quantity ...
-
Code that allows User to Input Begin, End Date, and Team Number [Closed]
Hello, I am looking for VBA code that will allow a user to input the begin and end date they are looking for, as well as team number. For exam...
-
Table Updates between worksheets [Closed]
Hello, I have 3 worksheets, each with a range formatted as tables. All the tables have 2 columns in common 'ID' and 'Vendor'. When I add a new ID...
-
how to convert date of birth in word [Closed]
Dear Sir, With reference to the above mentioned subject, I want the solution in excel for change the date of birth in words. For Example :- if I wi...
-
2 rows into one in excel [Closed]
Hello, I would like to sort 2 rows of excel into one A B 2 4 5 6 To C 2 4 5 6
-
Need cell value copy to defferent -2 work sheets within a Excel [Solved/Closed]
Hello, hi all i need to maintain a MIS on daily basis. in this, i need to enter same values multiple times on individual worksheet within a excel...
-
Excel / comparing data [Closed]
Hello, my name is Malwina. I would very much appreciate your help, please. I was trying to compare the spreadsheets but really have no idea ho...
-
Transfer data from an old report to a new one [Closed]
Good evening everyone. I'm trying to develop a macro that will compare data between two versions of the same report. The old file, contains a list o...
-
Identify Value "O/B", If True search column for "/" [Closed]
Hello, Im trying to make a break list to be active on a daily basis in a workplace, currently it works immacutely but i have hit a speedbump in co...
-
excel function to Check neighbour cells match for all [Solved/Closed]
Hi, I need to check if (each) cell in column A is having a match in column B, Example as below: Column A is phone numbers list, column B is mes...
-
How to Map 2 different columns in from 2 different excel files? [Closed]
Dear All, I am trying to Map values from 2 different columns from 2 different excel files. I am unsure as how to invoke the sheets and print the re...
-
Multiple IF functions [Closed]
Hello, I am trying to built a multiple If condition. I want excel to search for 2 words in an array "Lose" and "Tie". If it finds "Lose" then i want r...
-
A1 draws amount from other cells by live date. [Closed]
I'm stumped. I need the value in cell A1 to change automatically the first of each month. Column A2:A13 has dates for the first day of Jan through D...
-
To change cell value automatically [Solved/Closed]
Hello everyone here, this is my first question in this forum. In Excel 2013, If I type 1 in cell A1, then it should automatically change as Apple in s...
-
Help with IF STATEMENT / VLOOKUP (I think) [Solved/Closed]
I work for a planning company where we submit lots of applications to do with housing. Different application types have different lengths until decisi...
-
Help w/If Statement [Solved/Closed]
Hello, Let us say I have 3 columns, column A is home email, column B is work email, and column C is other email. On column D, I want to return th...
-
multiple options for if in a drop down menu [Closed]
hello, i trying to make a drop down list in which u can select food and it has a price so in the drop down list there is a3,a4 AND a5(in the drop do...
-
Searching for a specific values on multiple sheets using Macro [Closed]
Hello, I have multiple different sheets, for example I have 4 sheets now. first sheet,second sheet, third sheet, forth sheet. each sheet has 5 ...
-
Macro Help [Solved/Closed]
Greetings fellow users! I am in need of some assistance: Recently, I have created a macro in which I need to copy 100+ variables from one sh...
-
The perpetual question: Auto-populating sheets based on criteria [Closed]
Hello, I realize this question has been asked in a million iterations, but my understanding of programming is so nonexistent that I can't confiden...
-
VBA single click to get current date [Solved/Closed]
Hello, I'm brand new to VBA and the code that bhargav posted on Feb 6, 2013 10:48AM worked perfectly to get current time in a range of cells with ...
-
Macro to Create, Name and Fill New Sheets Based Data Set [Closed]
Sorry, I realize this question gets asked all the time. What I'm looking for seems different enough that I will need some specific help. The post righ...
-
Moving view, not moving selection [Closed]
Hi there :-) Is there a way to keep the selection, e.g. multiple cells, but move the view to the top of the sheet? Of course another way than scrol...
-
How do I get a value in a cell based on another cell [Closed]
Hi, How can I get excel to fill in some information for me? I want the value in column A to be filled in based on the value in either column B ...
-
How to compare two Excel sheets with varying data [Solved/Closed]
Hello, Before I start let me just say Thanks in advance. So I am looking for an ongoing updated answer. Every 3 months we receive a new price lis...
-
I need to copy the Hyper link as well as the text in the followi [Closed]
I am new to VBA, This code looks in one sheet and pastes it in a new sheet, but does not copy Hyper link, can this be done. Range(wsO.Cells(1, 1...
-
Need VBA to send the invoice through outlook [Closed]
Hi All, I need help with VBA code to send the PDF copies from the folder through outlook using the Excel Distribution list that when I run, would l...
-
Conditional Formating [Closed]
Hello, I am using Excel 2010. I have a call that contains Week number which has filter from w1,w2,w3,....., Also I have the list of week values in...
-
How to use Range function with variables? [Closed]
HI, I need help in running a macro with VB Script. I am trying to select a range with the help of a variable. I have comup with the below code. ...
-
Ranking sorting problem [Closed]
Hello I would appreciate some help on the following formula problem. I have a game where some teams have wins, losses and draws. My problem arises wh...
-
Copy & pasting the data into excel from an SQL Database file [Closed]
Hello, We have setup a database which inserts the data from an batch file and the data is extracted into an output file. The output file needs t...
-
Differences in two excel sheets [Closed]
Hello, I am trying to see if I can compare the first column in two different excel sheets to see if there are differences. Column A Book 1 ...
-
VBA code for duplicating Excel Workbook [Closed]
Hi all! My company use delay logs where we record delays everyday for different customers. At the moment every morning we're having to manually ...
-
Formula that can automatically classify monthly expenses [Closed]
Hello, i need a formula that can automatically classify monthly expenses. I want the amount to be transferred to the similar subhead automatically as ...
-
One million and two hundred thousand only [Closed]
I have try edit vba code in Excel for spell cu1,200,000 = One million and two hundred thousand only change in to One million and Two San only. please...
-
downloading [Closed]
Hi, can yoy help me how to download excel or spreadsheet using open office. I need it for my job. Thank you very much
Subscribe To Our Newsletter!
DON'T MISS
- How to Upload High Quality Photos to Instagram
- How to Recover a Disabled Facebook Account
- How to Disabled Write Protection on a USB
- How to Install a VPN
- How to Create a Gmail Account
- Computer Boots to Black Screen
- Facebook Code Not Received
- How to Get Free Diamonds in Free Fire
- How to Recover Your Yahoo Account
- How to Fix a Blurry Snapchat Video
- How to Get More Followers on Instagram