created

Hi... Here i given a link for an excel chart created by some genius i think.. https://www.dropbox.com/s/05ql5bf7u9g6f4a/COSTING%20SHEET.xlsx?dl=0 Some of the cells in this excel file, having formulas / text which is not allowing to edit by the user. I need to create this type of excel for...

Hi Guys, New here and done some searching but as I don't know what to call what I am looking for I struggled to find anything. What I would like to do is on my first tab (Costings) I have a list of the other tabs that are created when pricing up work. On these other tabs in exactly the same...

Does anyone know how I can open, view and save old spreadsheet files created in Supercalc? Thanks in anticipation. Andy

I'm having an issue with a report and was wondering if any assistance can be provided. I've created a micro-enabled workbook that gives me 2 sheets of data(STEWARDS and INVENTORY REPORT) and even creates folders based on the information provided from my STEWARD sheet. I now want to create...

Hi Community! I need some assistance please. I am trying to create an Excel file that will help me calculate my commissions, but there's an error in the formula I created. Here's our structure: <tbody> # of Members Commission Per Member 0-10 $3.50 11-30 $2.00 31-100 $1.00 >100 .50...

Hi guys, I have a list of files which have been created through another vba I created but now not sure how to apply said password against each of these files. I know I need to create a loop but not sure how to do that in this case. Furthermore after doing this, each of these files needs to be...

Hi everyone, I got a problem that I cannot solve by myself. I'll try to explain it the best I can. I have two word docs, said A and B: the A is created by an application and comes with 4 sections, the B is created by me without any section. Here's what I have to do: - delete all the text...

Hi: How does one create a name range that will be available to any worksheet or workbook or any newly created worksheet? I tried setting named range scope to “worksheet” but the name range is not available to another workbook or newly created worksheet. Could someone help please? Regards, Sean

Dear All, I am using Excel 2013 and I would like to have a macro which should create a new sheet when a value is typed in a cell and entered in the range eg A2:A100 If Sales is typed in Cell A2 a new sheet should be created in the workbook with the name Sales, if Expenses is typed in Cell A3...

Hi I created 3 simple tables. Then I went to Insert-->Table and renamed each table as following year16 year17 year18 I went to Formula tab-->Name Manager. I see 3 of them there. When I click on any of them, the Delete option is grayed out. Why is that? I tried everything but I can not delete...

Hello, I'm not sure how to explain my question, as I'm not familiar with the Excel Lingo, but here goes. I have created a calculator for position sizing of stocks. It's very basic. Just a few inputs and the other data are calculated - brilliant. Now, as time passes, I'd like to keep a log of...

I've just moved from a Windows PC to Apple MacBook Pro. Love the Mac once I got myself familiarised with the new operating system etc.... Problem I have is with old Excel Flies I've previously created which use Combo Box for Dropdown menus created within Developer. The Developer Ribbon...

I have created a macro that creates several different worksheets. I'm using the code below to output each of these newly-created sheets to a .PDF which is then stored in the same folder as the workbook. I'd like to move these new sheets to a new folder created by VBA. This is payroll data...

I created a Command Button on one page of a spreadsheet and managed to give it a Title so how do I link a macro that I have already created to this button ? I an using Excel 2010 Ron

Hi, I hope that i can explain my problem. I have a pivot table, for every change in item in this pivot table excel creates a new worksheet, with the function 'show report filter pages'. So i have like 40 worksheets created. Now i want a cell in every created worksheet with a date in it. But in...

I created a new Workbook with a single sheet. I then did copy/paste to copy formula and data from a source Workbook/worksheet to the new one. I created and did copy/pastes for several other sheets. I then created a final sheet, called "Control_Sheet". I cut cells from the several source sheets...

Hi in VBA, if I say worksheets(1), which sheet is that? the first one in the left hand side (physically the first one) or the first sheet that is created? lets say I have 4 sheets A,B,C and D. A was the first sheet created. Then I changed the order, copy/move etc and now I have these sheets...

Hi, I have two pivots: Pivot 1: Contains the Month, Zone name, Store type, and Store ID (All in the pivot field) Pivot 2: Contains the Month, Store type and product wise sales I have then created a slicer on "Month" field for one pivot and connected it to the other pivot. However, the slicer...

This is a tough one, rather special situation. We use serial number labels printed by Zebra Thermal Transfer Printers. The labels were created using the Zebra Pro Label software. After a label is created, the file is saved as a file extension .lbl. The labels are created linking fields to an...

I created a xlsm file that created like 10 reports automatically. I go to open the file and it says "Can't find project or library." All the code is gone. I can't save the file as a new file. Basically I can't do anything. I tried to go into the vb editor but it won't let me. I'm numb. numb...