vba & excel 2007

I have created an excel that is to be used as a template for my co-workers. I created a digital signature that is installed on all of the other computers that will be using the excel. I used a signature because I don't want to have every set their macro security to always allow the macros to...

I am trying to populate an End Date for my table based on the Start Date and the Duration stated by the user. My table are as shown as below: <tbody> Task Start Date Duration (day(s)) End Date 1 5/12/2016 5 2 7/12/2016 7 </tbody> I have tried to run a VBA code as follows but it...

Using Excel 2007 and VBA. I need to enter formulas into multiple cells of a worksheet referencing cells on another worksheet in the same workbook. The cells in the source worksheet are not contiguous, so copy/paste an existing formula on the destination worksheet will not work. I recorded a...

*I’m very new to VB, so I apologise in advance! I’ve created my first userform for excel, want participants to enter their data, click ‘submit’ and excel will store the data on one of the sheets. Made drop down lists with a combo box, but when the user form opens automatically with the excel...

Hi, I have a stop watch running in my Excel spreadsheet, I need it to running continuously throughout my session. Currently it stops when I input new data into cell. Can anyone help to make this run no matter what? Here's the code: [Code] Public StopIt As Boolean Public ResetIt As Boolean...

Hi there I am currently in the process of trying to set up a master table based upon two tables I already have and to formulate a code that will allow any new data added to the two tables to copy into the master table. All tables are in the same workbook and are set out as follows: Sheet one =...

Dears, I need some help to find matched numbers. I have a sheet and there are two columns; column A has few cities name upto 2828 (with duplicates) and the next one is in column C which contain unique values of cities available in column A (495 records - suffixed with some extra alphabet). So...

<code>I am pulling the data which is on table format from a website based on from date, I am giving the date by using input box so that it goes and sit in the form for from date box which is in website and search for results but not unfortunately the date which i am giving is not sitting in...

hi Guys, I am currently using the below code for a holiday request form it takes the values on sheet 1: Employee Name : B7 Employee Number : B9 Team : B11 matches them against a reference on their team holiday sheet (determined on sheet1 B11) To Book Holiday in on dates determined in ...

I as receiving a run time 28 error when I use a loop to fill a collection of class objects. The error occurs on line .Profit = ActiveCell.Offset(0, 3).value. I have tried many references about this and they do not seem to apply to my code (I am not calling excessive Subs, I do not believe I have...

Hello. In row 3 (Sheet1) I have products names (every second column) and list of their prices (below product names). New obtained price for each product is also in row 3 and always in "right" column. I need a VBA to check whether this new obtained product's price is different from the last...

Hello. I'm receiving data from external source (on every 5-10) minutes for analysis and I'm interested only for last five samples. Data range is a quite extensive on two Sheets (Sheet1 , row 3 columns A-EN and same for Sheet2). I would like to avoid all those annoying and time consuming...

Thank you for taking the time to read this thread. Please help me keep this thread neat and useful to others by not posting anything that detractgs from the objectives It is about Accounting programs and systems being created in Excel VBA. It covers file management fundamentals; Double entry...

Hello. I have a problem with code which runs periodically (every 30 seconds). Basically, the code compares data from two Sheets (at the same Workbook) and then paste data (under certain conditions) from Sheet4 to Sheet1. However, when I open some other Workbook (window on that "other"...

Hello. In Sheet2, Column B (B3:B50) I have a strings which I need to copy in Sheet1 , Row 3 in cells B3,D3,F3, ... V3 and X3 (12 in total). In Sheet2, Column G is so called "markers" Column because it contains markers/numbers for each product and those markers define copy position for each...

Hello. I need some assistance with my VBA code which extract numbers under certain conditions (every 2 minutes) to Sheet4 from data report in row 1 - Sheet5. I'm not very proficient with excel-vba but I'm open to suggestions and willing to learn to get this to work properly. Basically, my...

I need help trying to figure out how to copy and paste certain columns from one row and pasting them into a separate workbook row. It is a total of 24 columns, but they are not necessarily in order. I would also like the data to be pasted as text, if possible. I am very comfortable in Excel...

Hello. I have a report in row1 Sheet2 (columns A-EQ). I need to extract number of column(s) which contains strings/substrings: lines and shop. Column A = 1, Column B = 2 ... Results should be placed only in column B in Sheet1 (starting from B3 cell). Example. Sheet 2 <tbody> A B C D...

Hello. I need some assistance with an excel spreadsheet which contains very raw output report in row 1 (Sheet2) columns (A-NO). I'm not very proficient with excel-vba but I'm open to suggestions and willing to learn to get this to work properly. As I already stated in row1 in Sheet2 I have a...

Hello. I'm using the following code to parse my raw report from row1-Sheet5 and transfer data to Sheet4, creating this table: <tbody> O P Q R 1 2 id shop store factory 3 3456 23 15 25 4 3467 12 16 28 5 3468 24 19 33 6 .... .... .... .... </tbody> Data in row1-Sheet5 are...