Excel Forum
-
Problem with Excel vlookup table array [Closed]
Hello, I did a vlookup which worked well however, when I opened the spreadsheet and it asked me if I wanted to update, of course I clicked yes. ...
-
Excel: If date changes [Closed]
Hello, Here's what I want to do. I have a Column where I change the date and I want certain cells in this column to extract different informati...
-
copy-paste to fixed cells macro searchvalue [Closed]
Hello, How are you? I've been looking for some help in the forums because I'm new to macro programming and have to develop some sort of line code...
-
Macro for copying data onto another sheet [Closed]
Hello, I have a workbook that contains 8 sheets of different states. These sheets have data of five differenct products' sales and achievements fi...
-
Split data from one sheet into many sheets [Closed]
Hello, I have extracted data from our accounting database (account code, journal number, reference, date etc). Now I want to split the data so tha...
-
Notifications on excel [Solved/Closed]
Hello, I would need your help to create a notification on excel. I've got a row of date's and when the date is 90 days prior to the expiry dat...
-
Excel cell search and enter value [Closed]
Hello, I need help constructing a formula in Excell 2007 that will do the following - search the spreadsheet for matching number - if it f...
-
Macro for extracting particular data [Closed]
Hello, I request someone to help in solving my problem. I have two sheets one is "cashbook" and another sheet is "transaction". In "cashbook" shee...
-
Unhide Tab in Excel [Solved/Closed]
Hello, I have a cell in excel that is either true or false. Based on that then it is linked to a check box. When ever I type the word "True" it ...
-
Excel drop down list [Closed]
Hello, My question is regarding drop down list in excel. If i have data of all 12 month. and i have created a drop down list in excel of all 12 mo...
-
Office for Mac sort columns into new workbook [Closed]
Hello, I am new to VB and need some help. I have sorted a spreadsheet by user ID in column"D" and now I need to move the data in columns E and F in...
-
Excel - Conditional Formating [Closed]
Hello, I want to highlight a row with a certain colour. I have 4 rows. The first one is physical stock the second one is qty outstanding , third i...
-
function data from web in MS excel [Closed]
Hello, I would like to import data from one webpage to Excel using function Data - From Web. The problem is that this web page has at the end .jsp (...
-
copy specific data to a new sheet and save it [Closed]
Hello, I am looking for a macro that will copy data based on a specific cell(group name) and paste it to a new workbook. I am also looking for th...
-
Macro/UDF to auto Transpose cells [Closed]
Hello and greetings! I am stuck in a list of my team members more than 2000 where details for every individual is not recorded based on fields/column...
-
Columns Matching... [Closed]
Hi, I have a workbook in which there are 3 sets of 3 columns names (Narration, Debit, Credit) (Doc. No., Debit, Credit) (Diff, Debit, Cre...
-
Macro for counting duplicates in raw [Solved/Closed]
Hello, I apologize in advance if even my search efforts have not found an answer to my question, believe me I've tried. Ok, I need ...
-
Working with time in a Rota Spreed Sheet [Closed]
Hello, I have a spreadsheet of a work rota, i have start and end time in seperate columns , i need to work out how many hours each persons shift...
-
Match data from Excell [Solved/Closed]
Hello, I have information in different spreadshits which I would like to match by the name and year of a company. How can I do that? Example: ...
-
copy data from 1 excel sheet to another by cl [Closed]
Hello, i am trying to copy data from 1 excel sheet to another by clicking on button. my code is: Sub Button4_Click() Worksheets("ManHour").Ran...
-
locating excel files and copying using macro [Closed]
Hello, I want to copy certain data on rows and columns of different excel file from one tab with the date as the identifier and put it in a new...
-
Excel/VBA2010-Select cells between 2 keywords [Solved/Closed]
Hi guys, Here's a tricky one. I'm trying to write a macro that starts from the active cell - goes up the column selecting say 20 cells and searches...
-
Matching Columns from different worksheet [Closed]
Hello, I am trying to match project codes in different work sheets and display the date. Column E5 worksheet Contract award to match worksheet ...
-
Cells ending in '0' [Closed]
Hello, Is it possible to use conditional formatting to highlight the cells in a column of sequencial numbers ending in '0'? ie 10, 20, 30 etc to ...
-
Excel 2010 Lookup Options [Closed]
Hello, I'm trying to compare a field with TODAY() against a range a fields that are sequential dates, and when it matches, I need to return the values...
-
help with excel [Solved/Closed]
Hello, does anyone kno of a formula that will automatically input the next month. for example if I am starting with 10/28/2011 what is the formu...
-
multiple rows and columns in a single row [Closed]
Hello, I have some data in excel sheet. Here is the example. AAA 10 0 0 0 0 0 0 0 0 0 0 0 ...
-
Copy rows by column match condition [Closed]
Hello, I want to copy the rows from one sheet to other sheet based on column name matching. E.g, ================================== EN...
-
Macro/VBA needed to find, match, copy/paste [Closed]
Hello, Ok so i've searched and searched and still haven't found code to do exactly what I need. The macro needs to be able to search hundrends of ...
-
Excel (Mac) opens docs when started [Closed]
Hello, Recently my Excel (Office 07 for Mac) program tries to open ALL the documents in a particular file whenever I start it up. It choses to open...
-
I need this excel formula urgently [Closed]
Hello, I have the values 2,3, 2, 4, 5, 7,5,1. I want a formula that will select the first five lowest values and add them thanks
-
Excel VBA [Closed]
Hello, Please, I face difficulties to come into solution on one issue about how to use vba & one cell of a sheet1 to enter data into cells on ano...
-
Excel Auto Populate [Solved/Closed]
Hello, I've created a drop down list as B, I and A. on one sheet I need it to calculate the count automatically. The next sheet has coulmns sa...
-
Excel Macro [Closed]
Hello, I'm trying to create a formula if I input an age range ex. 17-24 in one column then write a price, if another age range is entered ex. 25-2...
-
Help! Cells to follow "Scrolling." [Closed]
Hello! This is the situation that I am facing. I have already freezed the required panes on a spreadsheet however I am trying to get a table to...
-
Excel Charts / Graphs [Solved/Closed]
Hello, I need your help with regards to creating a chart on a different sheet in the same workbook. I've got employee names on top as a row , ...
-
Excel 2007 conundrum [Closed]
Hello, I need to sum rangeof prices in Q6:P143, based on a selection made from a range of calender months in I6:1143. The calender months that ne...
-
multiple rows in multiple columns [Closed]
Hello, I have a spreadsheet with two columns and 100+ rows. Data in column A, the category repeats, Data in column B is unique to what is in col...
-
Make multiple columns into a single column [Closed]
Hello, I have data in excel sheet with 3600 columns and each column has 6 rows.Suppose say Column 'A'...It has 6 rows.I want the Column 'B' dat...
-
Blank rows deletion [Closed]
Hello, Dear friends, I really appreciate your support and help all the time. I have another problem and I need your help once again. I have ...
-
[OOo Calc] Spreadsheet: IF / THEN ? [Closed]
Hello I would like to make a comparison calculation and tried to use an IF(), but I keep getting an error. I use Open Office Calc, here, but that...
-
Please help in Excel Data function making [Closed]
Hello, Am Ravi Kiran, Vishakhapatnam, Andhra Pradesh, India, I have a doubt in Ms EXCEL 2007, my doubt is that am having a client who is a small...
-
Searching in 2nd sheet for values in first [Closed]
Hello, I am looking for a macro to search data in col A of first sheet in col A of 2nd sheet and whereever there is a match copy the data in ColB ...
-
Macro to compare two sheet and return a value [Closed]
Hello, Can you please help me with a macro. What I am trying to get is a macro that will compare two names in two sheets (Sheet1, col AD and Sheet...
-
macros 2 columns info into 1 same wksht. [Closed]
Hello, I have two columns of information. One column is labeled description and lists a (numerical and text) description of and item. EX: 1/2" ...
-
Compare two cells and do another formula [Closed]
Hello, I need some help on this, i have three cells containing either the letter H, B or U. Next to these i will have another three cells with one...
-
Cells display a total or text [Solved/Closed]
Hello, I have an excel workbook that has cells that display a currency amount U43, U45, U47, U49, U51 and Q53. For example U43 would have $200 in...
-
Excel Table, lookup, match, index, array ?? [Closed]
Hello, Can anyone help, please? I have a table with manager names running down column A, and dates running along row 1. Inside the table fo...
-
[Excel] formula for this problem [Closed]
Hello, i'm so confused with excel formula. how to get data from other table and other sheet which comparing data in row and column.like shown in the...
-
POP up msg in excel when condition is TRU [Closed]
Hello, I want to get a pop up message in excel when a condition is TRUE. I am bringing in live data and want to notified through pop up when the nu...
