Good day, I would like to seek help to how to split and populate data based on the result of certain calculation. Here are the criteria for the...
Hello, I need help... how show my programme result from macro to worksheet in excel? please give me some example? thank anyway Configuration: ...
Sorry for the confusing title! An example should clarify. Here is a link to an image of the excel program I reference in my question: http://i.st...
Hello, I am trying to write a formula for the following situation and for some reason anything I come up with is not working properly: if R2=...
Hello, I am trying to create a row in a separate sheet with the data that was inputed in the original sheet. Can you help? Configuration: Windo...
Hello, If the text of any cell in column-A matches with the text of any cell in column-B, copy entire row to next sheet. Like Column-A ...
Hello, I just need a little help. I'm trying to use the CountIf formula to reference two columns of data. I've been using this formula: =COUNTI...
Hey - created a speadsheet - has 13 sheets. A "Master" and one for each "month" of the year. Master containes rows of information: Unit numbers, date ...
I wrote a macro to search for a value in a different file/workbook, copy the row (if the value is found), then paste it back to the original workbook....
Hello, Need formula to say if cell has NA put 0 but if the cell has a date (yy,mm,dd) then subtract cell L1 from cell E1. Trying to determine how ...
Hello, Hey Experts, I recently tried to use macros to make graphs. I have more than 15 tabs on my excel. Each of them have a similar data with ...
Hello, I want to search for a word in the format eg.ABC-2012-123( where only ABC is fixed and the other numbers after hyphen keeps changing) in ea...
Hi guys, These threads are really helpful but i still cant get mine to work. I have created a knowlege base on excel for all the fixes on my serv...
Hello, I am having 2 worksheets in a workbook sheet1 consists of a data like this: Country name Site engineer Name Contact Details Ben...
Hello, I am in of help! I've tried searching the forum for a code that will work but sadly i've not found one. I am try to create/code a macro or b...
Hello, I want to create a macro which creates files based on contents in column AJ. and I want the macro to copy the data from original sheet...
Hello, I am trying to create a macro to search for a number from one workbook in another workbook, and then either copy the entire row or copy the ...
Dear friends, Plz help me to do the below requirement Current situation sheet one PTS invoice# status amount proc.date 1234...
Hello, I need my stock checker to pick up data from our suppliers spreadsheet which they change daily. So what i need for example is: To mat...
Hey there, I'm trying to create a macro for an Excel 2003 spreadsheet that will take a record (a row (or rows)) that I've already selected into a new ...
Hello, I need to create a date formula that only includes weekdays. I want to have a formula that does (=previous date+1) for 5 boxes and then...
Hello, I am using excel 2003 and pl help me to solve the below issue I want to compare two cells from one worksheet to other to write value ...
Hello, So sorry for my continuing inability to get my head around macros! I'm trying to workout a new spreadsheet and would really appreciate any...
Hello, how do I copy data from worksheet 1 into worksheet 2 (i know how to do this part), AND 1) delete the 4 digits at the end (i know how to do...
Hello, I have a 7 sheet workbook which contains a part number in column A of each sheet with details following it. I am trying to write a VBA code...
Hello, When presenting raw of data into a chart there is an option to present empty gaps as zero, gaps or connect the dots. none of teh option is wor...
Hello, in using Microsoft Excel 2007, I'd like to paste data from one column into a another column that has some data in it along with some blanks ...
Hello, Iam trying to do more or less a copy paste Macro in excel. The date comes out in the following format: Entity-----Account1----Account2 ...
Hello, I have a worksheet (Excel 2007) that has two master pages with data, Weekday, and Saturday. Every month the tab Weekday is copied and renam...
Hi all, I am (VERY) new to macros, and I am trying to create one that searches the cell in Column D in workbook 2, cross references it by the same...
Dear Friends, I am having a bug report. In that different developers will have a bug for each module. And each modules are in different sheet. ...
Hello, i have a imported text file into exel and i want to delete some specific number of rows after specific number of row say i want to delete ...
Hi, I am looking for comparing calues of sheet1 with sheet2 if the fileds in sheet1(coloumn A) is matching with filed in sheet2(coloumn A). If the ...
Hello, need help! see I need a vba code that can copy data from sheet1(raw data) to sheet 2,sheet3 and so on is certain condition matches..exam...
Hello, Is there a way to pull specific data from one cell and then put that data in multiple cells following the original cell? For example, her...
Hello, I want to make a file in infopath where we capture the service complains and generate the case id for different customer, every customer ha...
Hello, I have a report that I am using for a customer of mine that lists there kits in a matrix for me. Once in a while I find an error where a kit...
Hello, thanks foryour attention.infact I am working in a company where I have to enter the data on the daily basis.So sheet2 is changes.bu sheet o...
Hello, In sheet 2 ,I have these fields and in sheet1, I have these plus some more. Order # PO # Item # Description Lease Rate Rental Serial ...
Hello, I am working with a mid sized spreadsheet (around 500 rows) and Am trying to set the formatting so that if a date is earlier than today, it w...
Hello, I want to create a macro that will take a record (a row (or rows)) that I've already selected into a new sheet (I'll call this spreadsheet ...
Hello, i want macro for copy data for only two same column in all worksheets to one new worksheet in a workbook , column name like B or F . in all t...
Hello, I have data in 3 columns A,B,C and it goes to 1000 rows, I want it to be splitted in sets of 40 each . Like first 40 then next 40 and so on...
Hello, One thing that I have not been able to figure out is how to Duplicate a cell and its current Highlighted color. For example: Shee...
Hello, I have a Workbook that contains a number of worksheets related to estimating costs. On one worksheet I have a several sections that use dro...
Hello, I have a date a visa was issued. The visa expires 1 year from that date. I wish to highlight the relevant column in Red to mark that is d...
Hello, Dear All, i am running a small business of mine and i want this working, let me tell you first all about it There are 100 people t...
Hello all, I'm using Excel 2007 and I'm having trouble figuring out a way to move complete rows from one workbook to another. Currently I am utili...
Hello, I'm back again. I'm trying to determine if a worksheet exists in a workbook. If it does, I want to skip to the end of the code and do...
Hello, Really the help of a pro here.... I have a master data sheet which details all payable items in our finance system and the user they are...