fields

Hi, I am trying to create the option to click a button/ field/ word on a line in an excel spreadsheet table that will generate a new tab which transfers some of the data from the fields on the row in to a new pre-defined template. The template requires the following fields to be populated from...

Hello Excel and VBA Experts I have a challenging problem to automate a routing table. I am given data with missing users names and the routing table to determine the user names, and I can’t change how the information is presented. The data with missing user names has 5 fields; for this example...

Hello all, Google makes it sound like this can be done but I can't understand the guidance. Hoping you can help. We have a new word document with about 16 form fields (a mix of legacy form fields and content controls). I'd like to be able to automatically compile the data from the 16 form...

I created a Split form. Used the wizard. It put my fields in the detail section - which I can see all of them and edit them when in Design view. But when I go to Form view there I don't see my fields. I see them in the datasheet section on the bottom and I see the buttons I put in the form...

Hi, How do I get the first IF function to return FALSE instead of NA? What is wrong in the formula. =IFERROR(IF(A21=INDEX(P:P;MATCH(A21;P:P;0));TEXT(INDEX(S:S;MATCH(A21;P:P;0));0);TEXT((INDEX(R:R;MATCH(A21;T:T;0)));0));"") All fields are formatted identically.

I’m thinking of making a userform for my grass cutting business. I’m not entirely sure how to approach it yet but something like select a customers name & the relevant info fields are then shown. One thing I’m stuck with is some customers have repeat visits so maybe by clicking on a fields...

Is there a finite number of measures that can be created in Powerpivot? I have numerous measures; after refreshing all; some measures disappear from the table fields. I've tried searching by name under the ALL tab. They are simply gone. I can see the measure in the Powerpivot Manage...

Hey all. I've found where other people have had this error but those solutions haven't helped me solve this one. Long story short I built this for another employee about a year ago and my memory is fuzzy on some specifics. There's only one PivotTable on the sheet. I get the typical error...

Hello, Just hoping someone could help point me in the right direction here, as I'm sure I'm going about this problem all wrong. I have two data tables, each with transaction data and 3 key fields: Company, Cost Center, Project. To work with the data from the two tables, I concatenated each...

Good Day, Thank you in advance for answering this question. I can't combine two fields with an "x" value. For example, I'm combining lumber height & width so I write a calculated column =CONCATENATE(Data[Height],[Width]) and it shows 812 instead of 8x12. So then I read several websites &...

Hello everyone, I'm working on a code snippet in order to save my useform entry into my Access sheet. The code is <code><code> Next ctrl If IsNull(str) Or str = "" Then MsgBox("Record Saved") DoCmd.RunCommand acCmdSaveRecord -- line that is highlighted when code errors out...

Hello, Is there any way to create a calculated field when there is multiple columns in pivot table? there is two fields inserted in to column section and use the number from there to create calculated field. I am trying to create Rev Prod- cost 1 field. For example: Data would look like this...

I have a data field between C8:j350, need to sort on C, then G, then I on different selected ranges when selecting fields between C and J any help will be appreciated

Hi, File with an examlpe - https://www.dropbox.com/s/pcn5ai8zamb0hpg/Example%201.xlsm?dl=0 It's a part of the test checking the knowledge of the training participant. When someone fills the fields and comes to the conclusion that, however, he should not answer, then set to "Not...

Hello, I have a Table with 11 fields. The first field is a drop-down field with two options. Lets call them option A and option B. The remaining 10 fields relates to either option A or option B, but not both. For example, if option A is selected, then fields 2, 4, 8, and 10 would apply...

So I have 2 fields Problem Work Performed Both can contain similar information, thus both can contain specific info. So far apps provide only AND operator. If I create filter for Problem and Work Performed. I will either miss information if one of the fields doesn't contain keyword, or I don't...

Hello, I need to consolidate a lot of spreadsheets in one book. All have the same format and fields. I need something that it could be sure and not lost my information.

Hi, I'm new to forms and a beginner on VBA, so struggling with a VBA to make a user form fill in specific cells in a sheet. I have created the form and now I want to get the data from the fields into the cells on the worksheet and if the cells in the worksheet have data in them for this to be...

I am trying to change the border of a group of fields once all the fields contain the word TRUE. I was trying to set up a formula in Conditional Formatting but I do not know how.

Hello, I have this formula in access - that converts different formatted phone numbers into a numeric field - because some fields are blank it give me an #Error message. I tried to run the query and append it separately to a table (with a right join) - excluding Nulls, etc. But I cant seem to...