individual

Hi All, So I have a column which has only numbers. For eg. 345678, 674567. I want these individual numbers to be looked from a series of data which have corresponding Alphanumeric Values eg. 345678 - Computers, 674567 - Printers ...so on. How do I place a formula which looks up the...

After I run an Excel macro that I have created, if I go to do another task, like copy data from a program like Showcase Query to a new Excel workbook, instead of pasting the data as individual columns into individual cells, the data pastes as non-delimited data. I am assuming that this has...

Please see file below. Any help would be appreciated.

So I have this (the below) excel formula that does work, =IF('Q1 - Individual Performance'!N9<=60%, "0", IF('Q1 - Individual Performance'!N9<=80.99%, "1", IF('Q1 - Individual Performance'!N9>=81%, "2"))) However the sheet it is reading from has lots of #DIV/0! on there. So I have added in an...

Hello All, I use a macro that generates a PDF summary of sales made by each seller. Then, I send each individual PDF to each seller. I do it manually. :-( I would like to modify the current macro (or create another one if easier) to automatize the sending process. Each individual PDF should...

Hi I have a workbook with 250 individual worksheets (named C1-C250) and a 'Data Summary' sheet. On each of the individual sheets (C1-C250) in need to display data from the 'Data Summary' sheet using a cell reference. So for example on sheet C1 I need to pull data from row 3 of the 'Data Summary...

This is share market related. Just trying to see how many shares, at various prices , were traded during day. This is an example of the csv file I want to work on Excel WorkbookABC1TimePrice $Volume24:10:16 PM1.055256234:10:16 PM1.0552500044:10:16 PM1.051000054:10:16 PM1.0451000064:10:16...

Hi All, When doing Mail Merge, is it possible to send individual customer with individual different excel worksheet in each email as an attachment? Cheers, Peter

Hello, Have been struggling with this for some time. Basically- we have land owners who own multiple properties across different counties. I may not uncover all of what one land owner owns - and so assigning a unique ID # to them proves difficult. I need to assign each individual NAME...

In Tab 1 i have a list of individual 5-digit codes. Each code is a specific type of hospital procedure. In tab 2 I have a list of hospital procedures names and the ranges of 5-digit codes that fall into that procedure. The ranges are NOT continuous and have gaps in them. For example, one...

Hello everyone, I'm trying to convert all worksheets of the excel file into individual PDF and automatically attach to individual email (outlook) message each one of them. So far I was able to rename each worksheet (as per a certain cell) and save as individual PDF, but I still can't figure...

Hi, I have a document of someone else's that I check daily and it was made aware to me that the individual whose document it is, knew that I was doing this. And I wasn't sure how this was possible. As far as I know, there's no way to log when an Excel or Microsoft document has been opened...

Hi. Complete newbie here - literally just joined! Also pretty new to VBA and so really finding my way around it all, but I'm very eager to learn and understand a lot more. I'm currently producing some spreadsheets for someone else that I need to automate as much as possible using VBA. I...

The title pretty much says what I'm looking for, I need to breakout a sheet of 15,000+ rows into individual sheets of 150 data rows + header row from sheet 1. I just don't know enough coding to be able to make this happen. Appreciate the help, thanks.

Hi, I have a workbook that is meant to track travel costs across various departments. it has 11 department spreadsheets and one summary sheet. My issue is finding either a macro or function that will transfer the individual travel cost entries on the various sheets, to a single cost cell on the...

Hello, I have an excel file with different worksheet of the individual officer (i.e. 40 officers which means there are 40 worksheets) on their list of projects that they are managing and their involvement (by man-days) on each project. The data in each worksheet is presented in a table form and...

Hi Everyone, Newbie here I regularly receive a spreadsheet which include merchandise orders in a column. However, if two or more items are ordered by a customer, the data is all added into a single cell in the row corresponding to their name. I then need to extract the data for individual...

Hello, I have a list of postcodes and wish to only count each individual postcode once and not take into account the amount it appears. Any help would be great.

I am having 127 columns and 405 rows. A row consist of a group and column has individual (value of the cell consist of = "Unique accession | individual name or Species") as given below. <tbody> Groups Individuals (Unique accession | individual name or Species) Group[ 0 ]...

First let me say I'm not savvy in writing Visual Basic, so I'm really looking for guidance. I'm trying to make table that we would use to schedule individual employees on individual jobs on individual days, and store that data in a simple Access 2016 database; Basically, its like I'm trying to...