static

Hi All, this is my first post in this forum so i hope im doing it correctly, please let me know if not. I'm solving a static calculation that resolves into 4 simultaneous equations. The static beam is shown here: I've derived 4 equations from this beam and they are shown below: FCz + FDz =...

I'm certain this question has been answered numerous times, but I haven't found an answer that fits my particular needs. I'm trying to copy several cells from 4 different sheets of a variable workbook named by date. It would be saved as "17-Aug-18" today for example. Then, I'd like to paste the...

I have a workbook that has 3 static worksheets that are named the same in every workbook. The additional worksheets are dynamically created based on the employee name and training record selected by the supervisor. I need to copy a range of data on every worksheet but the 3 static ones (***NOTE...

Hello, I am trying to copy and paste using the code below. The VBA macro works fine if you enter two static worksheet names (A and B in this case). However I want worksheet A to have a dynamic name (whatever the user changes the sheet name to). I have a code that displays the sheet name in...

Hello, I am creating a basic order tracking spreadsheet where I would like the date in one cell to change based off of the selection made in the drop down menu of another cell. I don't want the date to update automatically though and have it remain static. The trick is that the date is not...

Hi, I have 2 sheets, one with a table full of data and another with just some static data fields. I'd like to import data from sheet "All Table" into a brand new sheet called "Txn 2" based on cell D7 in sheet "Static Data". The Identifier in cell D7 in the "Static Data" sheet will match the...

Hi, I’m trying to return a value from a large static table that includes a number of different parameters. <tbody> Feature 1 Min| Feature 1 Max| Feature 2 |Value 0.1 A 1 0.1 0.2 A 2 0.2 0.3 A 3 0.1 B 4 0.1 0.2 B 5 0.2 0.3 B 6 </tbody> Here’s an...

I understand that a static time entry can be entered into a spreadsheet by using the [CTRL]+[SHIFT]+[SEMI COLON] keys. However, is there a way of doing this on an Android phone keyboard.

Hello... Ive spent a couple of days perusing this wonderful forum and found a great solution to my problem, but there's just one thing preventing it from functioning properly... the old "blank cell that isn't truly blank" conundrum. Here's what Im trying to do. (from actual workbook) I want to...

Hello and thank you for any attention my post may receive. I would like to copy static range ws1.Range("B4,C4,B6,B8") and a dynamic range with values (exclude all empty cells) within ws1.Range("J3:J21"), and paste to the next empty cell range in ws5.Range("C3:H1000"). So for every cell in...

history - I work in procurement and have been operating a 'picklist' to help folks get the supplies they need for almost 6 years. The project started as an excel html website (static) and matured to a wordpress site. HQ nixed the wordpress site, needs to be hosted on the intra-net. back to...

Reference – Excel from MS Office 365 working in windows 10: Since I am not a real programmer I need some help. Since obtaining Windows 10 and Excel in MS Office 365, I cannot create dynamic charts the same way I did under previous versions of Excel and Windows. I can still create static charts...

Hello All, Would like to see if someone can help me with the following issue: I am comparing the information typed into cells D61, 62, 63, 64, 65 to the static information in cells C61, 62, 63, 64, 65. This is how the static information appears in the C cells: C61 has 2:00 C62 has 3:00 C63...

Hi, Is it possible to copy or get the cell value from a set range of cells which is a variable to a static range of cells that will never change but on the same row. I am using this for my range variable but Columns("AA:AA") will be the static range Set Rng =...

Hello, I am looking to automate the following process using a macro: <tbody> A B C D 1 DATE TOTAL 1-Sep-17 TOTAL (based indirectly on C1) 2 2-Sep-17 TOTAL (based indirectly on C2) 3 3-Sep-17 TOTAL (based indirectly on C3) ... </tbody> 1. Change the DATE in A1 using the...

Hello, I am trying to record a macro that can automate the following process: <tbody> A B C D 1 DATE TOTAL 1-Sep-16 TOTAL (based indirectly on C1) 2 2-Sep-16 TOTAL (based indirectly on C2) 3 3-Sep-16 TOTAL (based indirectly on C3) ... 30-Dec-17 ... </tbody> 1. Change the DATE...

I’m trying to create a report on excel that produces a red light, yellow light, or green light (all pictures) based on if an inputted number is lower, equal to, or higher than a dynamic number (which steadily increases week after week).So far, I have been able to produce this with a static...

I have a formula to put a time and time in a cell but it changes every time I do something in the spreadsheet. looking for one that does static time and date and also formula that does static date and time separately. Anybody know how to do this? appreciate any help! Thanks!

My company creates an ID for each product based on certain attributes of the product (size, colour, etc). The problem is I need to make it such that if those attributes change the ID must not update. Is there any way to say run this formula once but do not update? Currently I just cut the ID...

I have several spreadsheets that get data from one another in an ongoing manner (formulas directly in the cells). At the end of the day, however, I need a way to make the current values static. I know there is a way to do so in VBA but for the life of me I don't remember how. Help please.