This is my sheet and i want to automate 3 tasks using VBA . Can someone please help me to do...
I would like to know if this is possible. You can use Excel to scan in a Barcode from various products, it scans into a cell and either you autotab or click to the next cell to get the next barcode. When you sell a product like books you notice that certain data is consistant accross related...
Just wondering if anyone could help. I want to create a Macro that does the following:
I want to select any cell I have a figure in (say A1 has the number 3 in) and when I run the macro it does a sum related to that number, ie: number in cell (3 in this example) +10%, divided by 2, + .5 =...
I need to count how many times an item went from a certain source, and afterwards from which source it went the most.
How do I, on a new...
I've been asked if I can create a macro that loops through a number of email folders within Outlook and saves the contents to a location on a network (ideally it would then clear the contents of those folders within Outlook). I was just wondering if anyone knew, initially, if this was...
I've got a spreadsheet which has been very reliable over the past few years. However, recently is has become a little unstable and periodically crashes for an unknown reason. I think it might be related to conditional formatting that has slowly gotten out of hand as rows have been copied and...
Hello, this is going to be a slightly long question. I will try to be as detailed as possible.
I have a workbook with data, and column F contains a long string of text, which is essentially a description. Column E contains either one of two identifiers, "Main" or "Related". When a "Related"...
i did this years ago, but cant replicate what i did.
I have Table1 and Table2 and with a relationship of Column1 = Column1.
there is only one column in table1 and two columns in table 2.
All i want to do is bring in the value in Column2, called junk, into Table1.
There are 500,000 rows in...
Please help me with given sample tables below.
First table shows the original datas...
Second table is the results what I wanted to get by clicking the button all datas will randomly changed with below conditions.
1. Column A and Column B will be related datas.(If A1 goes to another row...
Maybe a hard to explain title, an example:
A list of products, with a value per year:
I'm searching for a solution to have a Data...
My Power Pivot data model consists of a number of linked Excel tables, of which tblEvents is the main one. It has the following columns:
Location, related to the column "LocationName" in tblLocations
EventType, related to the column "EventType" in tblEventTypes
Client, related to...
I have a calculated column to categorize spend types in a 8+ million row table. The existing version posted below works, but I need to add one more variable (potentially doubling the number of categories) and when I try it works in the data model window but Excel goes bye-bye when I go into...
I am looking for a dax function measure for powerpivot report which would return the value based on a lookup value from different table.
For Example,I have 2 tables as follows
i have a question related to excel. plz help. i have created a list of different products by data validation. now in the new sheet i have applied it now i want to select a product in the list.
now i want this: when i write a letter or 2 letter related to any specific product of the list, is it...
I was hoping this would be an easy one to solve, but nothing has worked. The basics of what I have setup:
1. I have a query created which displays all records of one field from my main table called 'serious incidents'
2. The query has a running total of the number of records.
3. on a report...
I have a brutally slow measure, and I need to create several more like it with contrasting logic in order to break down our spend in the categories a consultant is telling us to. Before I slow my model to a crawl I was hoping someone could help with optimization?
Controlled PO no Pharmacy :=...
I have a big range of data of spare parts where I need to find the right part and press hyperlink to view the picture of the part, is it possible to sort the pictures which linked to a certain Manufacturer or other certain cell related to the part, so if I filtered the excel sheet I can...
Kindly I need your help in this:
I work in a glass industry. I have 12 processes in the plant (Cutting, Edging, Drilling...)
These processes are put in Cells B16 --> B27
I did an excel file for my planning. Each order is a column in Excel (column C till Column ZZ)
And for each order there's an...