manually

Hi, I have a worksheet created whereby I want to find the best spacing and associated post type that results in minimal cost that Zex>Zex Min. I haven't had any luck and was wondering if one of you legends could help. I've tried running solver as per the picture below It claims it has run...

Hi guys and gals, It has been years since my last post! :-) I need to gather data from multiple worksheets to display on one page. For example for Every worksheet I want to grab the contents of A1, A2, I8 and G8. I can do this manually, of course. But I wanted to see if there was a way to do...

Title basically says it all, I have a user created form I'm trying to lock a formula in to automatically update something to a yes or no, but sometimes users may need to change it manually to yes or no thus why I have a drop down there. Any ideas/suggestions or is this just not possible currently?

I have a pivot table with multiple subtotals. Off to the right, we added manual adjustment columns not part of the pivot table. Is there a way to automatically insert subtotals (highlighted in yellow bellow) for the manually added columns? I have thousands of rows of data so manually creating...

hi to all Good Evening I have values 1, 2, 3 in column A and then i want to copy them in column B like 1 2 3 1 2 3 1 2 3 1 2 3 like this for number of times i want. I tried index, Mod and offset but no success, now i am doing manually but taking long time, is there any formula to do so? if any...

Hi, I am looking to have a spreadsheet that is updated from a database, and then someone manually types in what has been completed, I would like to have a macro where it would compare the values between two cells then output the what is missing. For example, in cell A2 I have "ABCD" then in B2...

I have a complex WB with a lot of Subs and Functions. It runs perfectly well time after time when run manually whether called manually or using Workbook_Open. However, when called from Windows tasks, it hangs. When it does this, Task Manager does not list Excel but trying to open the WB results...

I want to know Cell A1 how many times change in Cell B1. Note: Cell A1 contains formula. I will do not input manually in A1. Please advise me. Thanks in advance.

Hello everyone, I am very new to VBA so excuse me if my problem appears to be trivial for some of you. Let me explain the situation : I have a table consisting of 96 columns and 160 lines. I have been measuring things in triplicate, so each three columns are concerning the same sample (A B C...

I'd like to add a border to certain cells when my conditional formula is true, however the lines are quite thin & not very noticeable, any way I can thicken them up, like you can when formatting manually?

I'm having some trouble puzzling out a Conditional Formatting formula...it uses AND, NOT & OR functions. I want to highlight the cell under the following conditions..(this is not the actual formula I tried) (B3 NOT "A" OR "B" OR "C") AND (F3 - H1 >= 7) B3 is text F3 is a manually input date...

Hello, I'm trying to find a way to count triads of 1, 2, 3 in columns. For example I have: 1 2 3 2 3 1 2 1 3 In this example I have 123, 231, 312, 213. So a total sum of 4 triads. A triad must have all 3 different numbers to count(1, 2, 3). So a triad of 323 doesn't count. Is there any way...

Hi all, When I attempt to use the formula below via VBA I'm getting an error 1004. Formula works fine if I manually enter it into the cell K3. Any ideas on howto resolve it ? Range("K3").FormulaArray = "=AVERAGE(IF(L3:P3>=0,L3:P3,""))"

Hi, I and a colleague are a bit stumped, trying to create a heck a lot of graphs, by copying an pasting. These are all in the same sheet, looking at tables for data. They are being copied and pasted to the same location in relation to each table. The graphs links remain as absolute to the...

Hello from Greece. A new, small project has started. A good and loyal colleague needs help with data entry of measurements. Let's start from the begining. Introduction Since the first of the year, the colleagues from a neighboring department take measurements from a number of pieces of...

Hi, I have 2 workbooks linked on the server: workbook 2 has a vlookup formula with the table array in workbook 1. When I open workbook 2, I have a value error cell, even if workbook 1 is opened. If I manually close workbook 1 and reopen it, I have the right value. If I do it with a macro, I...

Lads, I'm working with Table that uses query from MS Access and I have added manually few columns like you would normally do on excel. I have manually filled cells with data. When data is refreshed from query and if rows are automatically added it shifts all data to different rows, but data...

Lets say whole ABCD is written in A column Row wise. I want to apply filter to show rows with only, A, C, U, K How would i go about this without manually checking these using simple filter option. Also suggest wildcard usage if for example I search for *A*

Good Afternoon, Can anyone please assist in displaying the tab name in a cell value. I need to tab name to automatically update without having to manually run any macros. I've tried using the following equation =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) which works...

When removing some field items from your pivot table based on an olap query, I noticed some filters automatically clear, where as others remain and you must find them on the field list and clear them manually. I'm not sure what the driver here is... does anyone have an idea? google has not...