new sheet

Hello, I have a problem that I think can be solved with a macro, but im not sure where to start. I have a number of spreadsheets that are set up with varying amounts of data from several sites, with header information followed by the data. I want to take one part of the header info (station...

i'm trying to create a database wherein when you double click on the figures (total), it links you to a different sheet that shows how the computation is made in order to arrive at the total. just how do i do that? thanks! your answers are much appreciated! :)

Hi I'm creating a new sheet with my solver and I created a button to assign a name to the worksheet. If the new name already exists, I get a warning message, the macro fails and a new sheet called eg Sheet 1 is created. How can I write a "If" to warn the user he entered a name that...

I was hoping to get some help with a macro. I need to copy a master sheet and create a number of new sheets equal to the number of items in a list. Thus, if I have five buildings Building A Building B Building C Building D Building E The macro would create five sheets, named "Building A"...

I have a spreadsheet that displays the weekly sales of my employees. I have a table that displays the weekly sales and then one below it on the same sheet that displays the year to date sales which are calculated by adding the current week sales to the previous weeks (which are displayed on the...

I have a workbook where i create "daily reports". I'm trying to find a VBA solution to "copy" the most current report, and create a new tabsheet. (the same way you would right click on the tabe, and select "create a copy". I've tried recording a macro to do this, but the macro keeps trying to...

Dear all, On "Sheet2", there is data unsorted. Every row is a sales lead, entered by an employee. There are of course multiple leads per employee. This sheet is supposed to be hidden/protected. The name of the employee is in row E. On "Sheet1", I want a cell (or listbox, whatever works...

Hi, I have a data base of 8200 products, each product has a code of 6 to 7 characters, the 3 first characters tell me the brand of the product. I will like my database separated by brand of product, hopefully a sheet per brand. Each product have 4 columns : code, description, und, price. can a...

Hi, does anybody know how I could cut rows from a range of data based on a changing value in a column. I have a whole set of data within which column K represents Currency. Currently I have my data sorted by Currency then a line is inserted with every Currency change. Set up as...