hand

  1. H

    Aligning Cells with Matching Values

    Hi, I have a spreadsheet with thousands of product codes, and corresponding data of stock on hand and weekly orders. I would like to match the product codes with each other to automatically align, in each row, the data of stock on hand and orders. For example column C has the product codes for...
  2. C

    VBA Search

    Im looking for a code in order to search all of column A for a value and select it, could anyone give me a hand? My boss will not allow me to use the CTRL-F feature.
  3. E

    Generating information in template

    Hello, I am looking to see if there is a formula or way to helpgenerate multiple students grade sheets based off data in a excel worksheet. Currently I have a template onanother excel document that is printed out and recorded by hand but I’m lookingto automate this process as we record multiple...
  4. D

    Combining Tables into one

    Hello! I have one table with states on the left hand side going down and odd numbers on the top going across. I have another tables with states on the left hand side going down and even numbers on the top going across. It looks like: 1 3 5 7 ... AK x...
  5. T

    Remove all filters and or tables from several files at once

    Good evening chaps, I have an issue at hand, I'm trying to merge several files at once they are all located in the same folder which makes the task at hand easier, however some of the files have filters and or tables thus such files will only copy the filtered information when I actually need...
  6. E

    Formula to populate cells that only meet certain criteria from two tables on another sheet

    Hi everyone.... So I've searched Google as well as I possibly could without knowing all of the search criteria which may be helpful, but since I made a post about this on Reddit that details the goal that I'm after, I'll simply paste it over to here and go from there. It's uncommon to encounter...
  7. B

    Setting Up New Comprehensive Database

    Ok, so its been 14 long years since I last tried to touch Access. I feel as confident now as I did then, lol I'm trying to slowly build a master database. Here's where we as a company currently stand. Currently on approximately 100 excel sheets we track part numbers, current on hands...
  8. P

    Vlookup Hlook up combo?

    I am working with two different workbooks, ive done both h look up v look up and a bunch of other formulas. my goal is to get certain info from one sheet to another sheet. in order to reduce the duplicate task of hand entry. firstly...column headers G5 and H5 are the same name....but i dont...
  9. S

    PowerPivot filter problem.

    Hi I have a powerpivot formula below. It works, but only with what I've put directly in the formula. Is there a way to have it driven from a slicer or table filter? ONLY LARGE:=IF(CALCULATE([ON HAND + IN TRAN TOTAL],'tblInvSkuMaster'[id_link_2]="SIZE Alpha L/G")=[ON HAND + IN TRAN...
  10. N

    Single page sheet

    How can I create a single sheet or form that just shows the single sheet? In other words I don't want to see the normal unused columns on the right hand side. It would look like the print preview w/o the RHS cells.
  11. R

    Adjusting a form Size

    Hi Forum Hope all is well. I would like some advice on how to resize a UserForm. Is it possible to add the "drag" feature to the bottom right hand corner that makes the form larger or smaller? or is it possible to put the "full screen" square on the top right hand corner? I have searched...
  12. D

    Speech / Voice prompt solution

    Hello, We sell products, and every morning we print a "pick list" (column A has "item#" and Col B has "Qty") and then the worker goes into the warehouse and pick the items. Currently she holds the sheet in one hand and reads and uses the other hand to pick the item. We are looking for a...
  13. G

    Add %,$, ',.. to a group of cells automatically

    Hi All, I have a quick question: I have a column of cells with fixed numbers. In order to process them I need to add to some the % sign and o others the £ sign. Is possible to do it automatically instead of one by one by hand ? many thanks!
  14. B

    Count If in Access 2016?

    Good Afternoon, I know I can perform a "countif" in Excel but just wondering how I can do that in Access? I really don't want to use code just simple formula would work if that's possible. Here's what I want to do, I have a table containing location, item and on hand. I would like to count...
  15. S

    Looking to create weekly OH for 52 weeks. How do i calculate the dates

    Hi I have an OH report that calculates the current OH. I would like to figure out what the OH was each of the last 52 weeks. I need to take OH + SALES + UNITS SENT - UNITS RECEIVED to figure out the balances of each of the prior 52 weeks. Do I have to create 52 measures? Is there a better...
  16. L

    auto fill in date

    I'm using the following VBA script in my excel file at work to auto fill in today's date in the column to the right when I enter data into the column to the left. It's working but the only thing I don't like is it is also inserting today's date into the column on the right even when I delete...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top