fields

Hi, I appreciate there is probably a simple answer to this but i am stuck. We have a 4 column spreadsheet which has over 20K records in it. Column A & B are text fields and C & D are numeric fields. What we need to do is to ensure the combination in the text fields is reversed and also in the...

my form has 2 command buttons at the bottom. One is named cmdAdd for adding the data to the worksheet, and the other is named cmdClose for unloading it and closing out the form. I want to introduce a "are you sure you want close" msgbox after the cmdClose is clicked and if any of the fields on...

I am using Office 360 (Excel) and I have a csv file with the following headers (and corresponding data): First Name,Last Name,Address,City,State,ZIP,Phone,Home Owner,Source The printing company I am using requires the following headers: Record Id,Salutation,First Name,Middle Name,Last...

Our company have a large excel list (about 100 000 rows and 20 columns) we need to maintain. We receive updates from a third party every month (for some of the fields only) and need some way to check, for each entry, if there has been an update. I have made a simple macro for this in excel that...

I usually get an error message whenever I am creating a form in excel using the "form" option in the Excel ribbon because I have a lot of columns which consequently means I am gonna need a lot of fields for the form. Is there any way to remedy this? I was thinking that maybe it is possible if I...

Hello, I'm trying to copy and paste certain rows from one worksheet to another. I've got that to work - hallelujah! Now, in that same row, I'm trying to output 3 variable fields which I've saved from rows above. My variable fields come out one row below my pasted fields. What to do? I think...

This issue started when I upgraded to Excel 2016 32bit. I use multiple date fields ('decision date' or 'close date' formatted like 10/20/2018) in the column field in a tabular pivot table. Excel automatically groups these, and i need the date to be in one column,not grouped by month/etc...

This issue started when I upgraded to Excel 2016 32bit. I use multiple date fields ('decision date' or 'close date' formatted like 10/20/2018) in the column field in a tabular pivot table. Excel automatically groups these, and i need the date to be in one column,not grouped by month/etc...

Greetings, What I am trying to do is create a report of weekly, monthly, Quarterly and Annual expenses. The data I have entered is for about one and a half months. I can group the data by Month but when I try to group it by days, the fields under (Analyze/Group Field) has the Auto fields greyed...

Hello, I need to work out the total value from 2 fields Q4 = Total Sales = £25,137.90 R4 = Average Product Profit Margin % = 25% Basically 28% of £25,137.90. I have currently got the sum - =Q4*R4 However, this gives me £15,911.76. This is incorrect as 28% is £15,807.34. Please note that...

Hi I want to update table's field based on combo box selection, all table fields are on same form of combo box. for example if i select employee ID 1 in cboEmpID than all his details and text boxes or combo boxes field on form should change to this employee's information and this information...

Hello Need help on this one. I have really tried to search and figure this issue out before posting... I have a userform called DigitalSignatureSM that is used to digitally sign a form. All fields in the userform (i.e. dropdown combo boxes) are required to be filled and will highlight in...

Good afternoon. I've read through the forum rules, and I'm hoping this thread makes the cut. I'm a newbie here, so I'd appreciate your input. I lead a nonprofit, and I'm trying to research other similar nonprofits. I have a file folder with 64 docx files that summarize each nonprofit, all...

Good day! I have a button on my form, and this button will be linked to 2 fields: User ID and log time. In Design View, I have already filled in a Default Value of =Now() for the log time. I need assistance with linking the button to the user ID and LogTime fields? This way with a click of...

I have an if statement and I want to add an additional if(Vlookup) to it. The first if statement is handling a specific rule. I want the if(lookup) to handle everything else. The fields for the 1st if statement are blank in 'Company Info'. Can this be done as I am getting an error...

I'm trying to hide certain data fields (or cube fields in this situation) with VBA. Here is my current code: Dim pt As PivotTable, cf As CubeField Set pt = Sheets("RECAP").PivotTables("Major/SubCat Pivot") With pt .ManualUpdate = True ActiveSheet.PivotTables("Major/SubCat Pivot").CubeFields...

Hi, I am trying to pull a csv file into a worksheet within a workbook and despite long searching have not yet found a solution. A single line would typically be in the following format: 407,"2018-07-24 12:21:08",processing,130.00,paypal,fist name,surname,name@email.co.uk,07123123456,"Hi, this...

Hi all, Using Excel 2016. I have time bucket values in two different fields in the data source. For example 12 - , 6 | 6 -, 10 | etc... I added these fields to the Rows Filed of the Pivot Table (Tablular) The chart looks good, but I would like to remove the day part labels from the Category...

I have been searching for over a week online and haven't found anything that works. I have a userform that has 3 combo boxes ( Provider, Year, & Quarter). When the user chooses what they need it will filter the data from the pivot table so they can print a report. At this time I haven't managed...

I'm looking for a macro that I can use to create two calculated fields on a pivot table - I have to create these upwards of 10 times every day! The first one would be called "Conversion Ratio": ='Hits Unique' /Signups And the second one would be "Rev per Sale" ='Initial Revenues /...