Excel Forum

Linking value from one excel file to another

Hello, I have a small business (small convenience store) and wants to use excel to keep track of my sales and inventory on a daily basis. I made a si...

Change data from sheet1 to sheet2 by formula

Hello, how to change data from sheet1 to sheet2 by formula Eg : Sheet1 A B C 1 5 4 =A1+B1 2 1 5 =A2+B2 ...

Rename the sheet to the file name with date

Hello, I need to import text file to excel and rename the sheet to the name of the textfile using macro. I have the code for importing the text fil...

Macro to copy paste in excel

Internet browsing in pc with my smsung e250

Hello, I am having a problem in browsing internet on pc using my samsung e250 as a modem i don't have the pc suite.From which site i can download it...

Hw do i set my pc for free browsing

Hello, kindly help me on how to set my pc for free browsing,free dstv amd free mobile calls

Help on free pc browsing

Hello, kindly help me on how to browse on pc free,the software and configuration settings for effective software.please help.

Excell

Hello, i dont know about excel sheel , i want a fully notes of excel wiht formulas

Vba: search for a value then moving cusor

Hello, i need the code for the following please: Find a specific value in a spreadsheet Then move the cursor 5 cells/ spaces up thanks Ja...

Browser issues

Hello,i,m connect to the internet. have firefox and windows IE as browsers on my pc which is a compaq presario i have vista home premium i,m connected...

Excel vlook up help

Hello, i have a excel sheet where i have lot of columns in sheet 1 from a1-a100 there are different numbers say a1-0101, a2-103 so on on sheet ...

Copy/paste parts of files (excel marcos)

Hello, I'm trying to create a macro that will copy a section of another excel file into the excel file that I'm running the marco on, then continue...

I want to know about vbscript with macros

Hello, i have two excel sheet in that one is filled of details like empname and shifttype. with this information i want to fill Rupees colum in secon...

How to transfer data from one sheet to anoth

Hello, i HAVE A PROBLEM IN EXCEL.tHIS IS EXPLAINED AS BELOW-- I am entering cite details into my sheet.When i enter a cite details in main she...

Free internet browsing

Hello, i have a chaina phone sheco97 i want to connect it to my pc for free internet browsing. kindly assist me by sending me a guidlines or a code ...

Delete sheets in excel

Hello, I am looking for a VBA macro that can delete all the sheets in Excel the start with name "Sheet". Also if no such sheet name is found it sh...

Vba loop jumping ower values

Hello, i have created a loop witch is a part of a bigger macro i am creating the loop is runnig fine exept one thing, the loops pupuse is to compar...

Matching names in two columns of excel

Hello, Hi I have a huge list of names in excel sheet1. In the second sheet I have the same list but with differences in spelling. I need to match t...

Vba underscore trouble

Solved

Hello, I wrote a simple VBA code which is pretty long, so I want to use a underscore to continue on the next line. Here is an example of the cod...

Need some help whith vba

Hello, i have created a loop that loops thro column B and testing data up agenst seartan criterias, if they match it copys the data to a spesefied lo...

Find and move rows with empty cell

Hello, I am new to excel with regards to advance programming.I have an excel with 1000s of records. It have approximately 20 columns. I need to loo...

Free browsing

Hello, pls how can i configure my samsung E250 phone and my Acer Aspire 4710 laptop for free browsing using an MTN line.your responce quick would rea...

Excel - cell event (th formula in cell)

Hello, I want a cell event to run a small macro. Have tried the normal cell event code, it works ok when I type in a cell that runs the event, but...

Macro

Hello, I download information into Excel, then I run a macro to sort information. Sometimes the macro will sort the information into the wrong cells....

Finding insertion point in excel

Hello here is a challenging one.... I am trying to automate a spreadsheet used for processing and compiling large amounts of data, with the outp...

Excel

Hello, I'm using Excel and a barcode scanner program to update an equipment inventory. Currently I'm using the barcode scanner software to open a "f...

Multiple sheets with data

Hi I have a spreadsheet with 8 clients listed on 8 rows. There are 9 coulmns of information. I have the following formula at the very bottom of the sh...

Copy data from many worksheets to a compiled

Hello, I want to write a macro for some data in excel. I have multiple worksheets that I need to copy a column of data from each and paste them into...

New sheet using conditional formatting

Hello, I have a very basic table on Excel which I use to keep contract data. I'm currently using conditional formatting to highlight the row if th...

Userform for importing sheet from one excel

Hello, I want to create a user form in MS excel that will prompt the user for the file name. Once the user browses the file name it should copy th...

Vba: error 9; subscript is out of reach

Solved

Hello, Depending on the value of a specific cell (sheet "gegevensblad" cell L10), I would like to hide 1 out of 2 sheets (Either Overzichtsgrafieke...

Copying data into different cells using macro

Hello, I am trying to use macros to copy data from one cell into different cells in another sheet. My data is consisting of Organisation contact deta...

Compare and update excel sheet

Hello, I have got two excel sheets one master sheet that gets updated everymonth with the new employees joining that month. the other excel sheet nee...

Vba help needed

Hello, im having an issue, what im whant to achive is this. i want to be able to select ranges depending on the content of the cells in column A, a...

Macro excel 2007 help

Hello, hey guys i need help in excel.... assignment in my row F I have 2 data Permanent and contract. So i want to make it that when I type it in sh...

How to browse on my pc throug my phone

Hello, I want to connect my phone which is connected to the internet to my computer which is not connected to the internet so that I can browse on my...

Vba code in a excel form

Hi, I made an Excel form for colleagues to enter data in a sheet in rows. I made a second form on wich other colleagues need to find a 6 digit nu...

List month from any given year in excel

Solved

Hello, i 0got a spreadsheet (data) as below date status 1-jan-1975 approved 1-feb-1980 suspended 5-mar-1985 rejected 10...

How to deal cells with same content except on

Hello, hey i got lots of data in the B collum a lot of the data is the same, repeated in row after row but not all data is the same. waht i have trie...

How to create a macro

Hello, i am completely new to the task of creating macros.can you please tell me how should i create a macro so that all the cells under a particul...

Making sheet increasing#'s&but same letters

Hello, labels that must have same V33j on all as well as another group of numbers usually 3 or 4more that would increase or advance by 1 number as ea...

How to add a ready macro to excel

Hello, I have downloaded a macro from a blog to keep a track of time and date when a cell was modified last. Please help me how to add it to the exc...

Protecting excel sheet from copying

Hello, i want to know how to protect an excel file on my hard to from copying by others. regards, rajeev

Color rows after comparing

"Hello world", I have an excel file with three sheets. What I've done so far is to compare sheet1 with sheet2. Every new or updated record tha...

Activating macro

Solved

Hello, I have made a calender which I want to prepare for next year with the press of a button. Here is the file: https://authentification.site...

Browser problems??

Hello, My IE was working just fine. I went on vacation and when I came back, it all of a sudden stopped working. I didnt do anything to it nor did I ...

Comparing two excel sheets

Hello, I want to compare the rows in two excel sheets and find out true/false value. For eg: sheet 1 will be having 15 columns & sheet 2 will b...

Require help in excel

Solved

Hello, Pls help me by suggesting any formula or function for selecting two minimum values from range of numbers in excel spreadsheet. For exampl...

Vba excel 2007 question

Hi there, I have a slight problem I am currently dealing with making up time sheets on the one sheet for a number of members of staff. The probl...

Quickbooks excel export

Closed

Hello,I have been using quickbooks forever, and all of a sudden, with no change in software, QB stopped allowing me to export documents to excel. Has...

Excel Forum

Subscribe To Our Newsletter!