hand

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...

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.

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...

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...

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...

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...

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...

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...

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...

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.

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...

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...

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!

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...

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...

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...