The discussions
Recover my deleted excel file
Solved/ClosedHello, i need or recover my deleted excel file. by mistake i use shift delete.plz help me out. Configuration: Windows XP / Internet Exp...
Excel macro - multiple columns into one
SolvedHello, I need a macro that combines multiple columns into one, but I'm terrible at creating macros! Essentially what I have is data that is sorted...
Select a subset of cells within a row
SolvedHello, I am trying to select a number of cells within a row - I want to use this in a macro. Whatever cell is currently active, I want to select c...
Copy to cell below the last entry in sheet 2
SolvedHello, I need to do the following 1.I have assigned a Macro button called Submit in Sheet 1 - done 2.Copy Cells E5,E7,E9 from Sheet 1 to Cells B...
Highlighting rows by date
SolvedHello, I have a spreadsheet in which the date in a cell has a large amount of impact on what needs to happen with that current individual. What...
Copy non-contiguous cells to another sheet
SolvedHello, I have the code below that only works for copying cells B2,B3,C3,E2,E4 from active sheet to the same identical cells on sheet2. Cells, B2,B...
Office -2003 short cut keys in excel
SolvedHello, How to merge cells in ex-cel-2003 by key board short cut key.
Calculations using two seperate spreadsheets
SolvedHello, I am wanting to gather a number value already calculated in one excel spreadsheet and bring that number to another spreadsheet so I can use...
How to match two columns
Solved/ClosedHello, I have 2 excel sheets with exactly the same format, in column A, I have the name of my customers and in Column B, the value of their sales. th...
Please help! excel formula needed!
SolvedHello, I have a spreadsheet with many columns: date issued, invoice number, gross£, net£, vat£, date due, date paid. until the invoice is paid ...
Complicated lookup in excel
SolvedFor me at least..... I have two spreadsheets that I am trying to use a lookup on. It's a little more than a VLookup. PTCI and TECI are the names ...
Copying data from one worksheet to another
SolvedHello, I have created a worksheet with 1000 rows of information that has 12 columns that vary with input information. Each row could have 1 or up ...
How to merge an excel file to database?
SolvedCould someone please instruct me how to merge an excel file to database (MS Access/FoxPro/Oracle)?
Excel formulas
SolvedHello, I am having difficulty copying fromulas on excell from different sheets to form an analysis page. I have 52 different sheets and need to ...
Excel - formula in text count
SolvedHello, I Need a formula in text count For Example P=1 P+P+P+P+P= 6 What is the formula in excel please defineConfiguration: Windows XP / ...
Copy / paste specfic date to other worksheet.
SolvedHello, I've got a few columns of data in which 3 columns contain dates (in date format : dd/mm/yyyy) . Now, I want excel to seperate the entire row ...
Find and replace cell value macro help pls
SolvedHello, i have these 20 formulas (1 per stock code) in my spreadsheet that come from etrade =PROStaticData(2, "mqg.ASX", "2010/08/10;2010/08...
Macro: watch a cell and copy if changed
SolvedHello, The problem in a nutshell is that I have 5 pivot tables on one worksheet, each with a field called "date" above the main text. Each day the...
Create a macro to format a column
SolvedGreetings, I am not a programmer but I know how to create basic macros that would perform simple repeated tasks in a fixed range within a sheet. ...
Macro to delete duplicate items -help please
SolvedHello, I'm trying to create a macro to delete the row that has a word at the biginnig and the same word at the end. Example: MIA/SFO/MIA ...
Excel, filling in cell values automatically
SolvedHello, I have two worksheets in Excel 2007 and am trying to automatically fill in cells in worksheet two based on values in the first worksheet. A...
Text help in excel
SolvedHello, i need to get 2 text cells on sheet 1 to list in 1 cell on page 2 any help would be cool with me since i am new to this neet thing called e...
Vlookup in other worksheet (date)
SolvedHello, Attached please find the reference file. https://authentification.site/files/23765947/sort.xls I am doing a VLOOKUP from sheet 1 to she...
Help with excel please
SolvedHi I have an excel spreadsheet with two columns in A is a list of codes, and in B a list of names containing the codes in a string A ...
Copy entry from each worksheet to new sheet
SolvedHello friends, After reading some very useful suggestions. I thought of posting my problem, hoping i'll find a solution I have a workbook which...
Excel absolute reference?
SolvedHello, Configuration: Windows XP / Firefox 3.6.7 I have cells A1:A5 as "5, 10, 15, 20, 25" respectively. I want to make cells C1:G1, ref...
Browsers all stop. router is fine.
Solved/ClosedHello, Recently, without installing any new software, my browsers all eventually stop. Firefox is my main, and would be the first to fall after abo...
Help with a conditional macro?
SolvedHello, I am trying to use VBA to check whether an M appears in column B and then, if it does, paste the information from that row (Columns A thr...
Go to next page in word doc using vba code
Solved/ClosedHello, Can any one tell me how go to next page in microsoft word doc using Excel Vba + macro code
Copy rows until meet given line
SolvedHello, I'm trying to split one spreadsheet into several spreadsheets. The splitting has to be done when a certain value is found. I need to mo...
Insert 2 rows, copy the formula.vba help pls
SolvedHello, I have a huge file to work on. Please help me with a VBA that does the following for the entire sheet (until the last row) 1) Whenever y...
Vba macro-move to cell underneath the button
SolvedHello, I want my VBA macro to move to the cell 'underneath' the particular button that is being pressed. (I have a series of buttons down the page, e...
Width & merge cells
SolvedHello, I Have 1 WorkSheet In Which There Are Too Many Sub Sheets. I Want The Width & Merge Cells Of Sheet1 In To All Sheets. But I Dont Need The ...
Matching 2 columns in excel
SolvedHello, I've got 2 columns of data- I'm trying to see if there's a match between the data in Column A with Column B- if the data is in Column B somewhe...
Excel help
SolvedHello, I have an excel worksheet with cells filled with strings of text like this... CAS [354-24-5], 99% I'd like to search a vertical c...
More than 3 conditional formats in excel
SolvedHello, I am working with an Excel spreadsheet, and need the cell background in one column to change to red if its value is within a range of numbers...
Excel 2003 - change row colour with vba
SolvedHi, hope somebody can help I've got a spreadsheet when I need to change the row colour dependent on the data entered into a particular cell. The...
Import webpage data into excel spreadsheet
Solved/ClosedHello, I am attempting to import the web page data from "http://bet1.hkjc.com/racing/pages/odds_wp.aspx?date=19-10-2008&venue=HV&raceno=1&lang=en" th...
Open excel file into worksheet of open workbk
SolvedHello, MS Excel 2000, VBA I'd like to be able to open a file directly into a new worksheet of an open workbook, thus adding the new sheet in the...
Excel formula
SolvedHello, I need a formula to accomplish the following. 5 + years => 15 10 + years => 20 15 + years => 25 20 + years => 30 eg. say I was h...
Match colums from sheets
SolvedHello, I have two sheets - S1 and S2. In S1 are colums A and B. In S2 are columns B and C. I want to join columns A and C using colums B (which is...
Shade the rows for different working days
SolvedHello, I need a VBA code that allow me to shade the row color in blue when the date in a cell is performed in the last 3 days of working days . Othe...
Combine columns in excel
SolvedHello, i have got two sheets of data and i have arranged them into ideal orders. Now i want to place data on sheet 2 behind data on sheet 1.( in the...
Problem with dates in excel 2004 mac
SolvedHello, I'm working in MAC OSX MS Office 2004 11.5.3 (081114) I have two workbooks opened at the same time. I copied 54K+ rows of data from o...
Macro to copy a certain cell onto another row
SolvedI'm trying to copy values from one cell to another excel via use of a macro, where E#99999 is the employee number to be put to column A until it reach...
Conditional formatting of a column of cells
SolvedHello, I am working on a task list/project sheet and I am trying to set a conditional format for a column of cells that is based on two (technical...
Problem moving records to another worksheet
SolvedHello eberybody I have a doubt, I know how to move records from one sheet to another, as this: Worksheets("Sheet1").Range("A" & i + 2).Resize(1,...
Transfer records to another worksheet
SolvedHello, I have tried everything to move these records to a sheet called "Data" , but I wasn't able to get any good results. what I have been trying...
Extra cells removal. excel
SolvedHello, Does anyone know how to hide unused cells in excel? I have got a program that does all the matching for me, but everytime when i finished ...
Link cell to another worksheet
Solvedhi there, What i want to do is to link a worksheet to another worksheet. Like, when I type data on cell in sheet1... then, same data will auto...
