cards

Hi All, and thanks in advance. I am sure this is easy, I just can't get my head around it! I have a club membership list in Excel and I want to produce membership cards. That bit is easy. However, I want to pull the name on the card from the membership list, so each name shows up as the cards...

This is one for a hobby. I have a card collecting spreadsheet that lists all available cards with columns for various stats like name, weapon, class, etc. Final column is either owned, wanted, or just blank. I set up a quicky VBA macro to sort everything by my desired "order of columns"...

I have equations including text, providing information on source directory & save directors the VBA processes. In some cells, they evaluate. For example: In cell B3, ="J:\ACCOUNTS\Credit Cards" & B15 & "" evaluated to J:\ACCOUNTS\Credit Cards\2018\ In cell B4, ="J:\accounts\Xero\Credit...

If column A are names, and Column B are expiry dates for their cards, is it possible that I open a new spreadsheet, and draw only the expired name & date on the sheet? I have multiple of cards that required to draw expiry date to another sheet, will the formula be similar? Thanks for your help.

Sheet 1 has employee info Sheet 2 are blank employee cards Example is an example of where the info from sheet 1 goes onto sheet 2 If someone could create a macro to go through each case (all rows with data) on sheet 1 and have that copy to corresponding cards on sheet 2 that would be amazing...

Hi all! This is more of a math question, but I thought I might be able to get the answer here. I would like to create a Bingo Simulator that will allow me to predict the approximate number of draws it will take to get BINGO. Bingo is typically played on a 5x5 grid, with 75 possible draws (B1...

Hi All Hopefully someone can point me in the right direction with this problem. We are trying to get away from having paper copies and go digital with batch cards at my work. At the end of each week we print out a weeks worth of batch cards, the operators use the cards for recording...

Hi all, I am trying to make Excel to recognize straight flush combinations with 3 or more cards. (This is a game known as Rhum32, a rummy version) Basically the cards of the straight flush should return ZERO value and the unrelated cards' values must be summed. See the table below, unfortunately...

Veyr very new to BI and need to learn quickly... I am using the visual: 'card' (So it is populated with a specific number D6) and I would like to click on this visual and to be sent to a different page (Also titled D6) with in the report. Is this possible? Essentially I have 4 different...

I have another task in excel that I must perform that I hope you'll will be able to help me with. Once again I am allocating limited money however, this time I need to allocated the same to everyone in increments until the pool is exhausted. So its almost like dealing cards. For each round...

Hi guys, I have a two-sheet workbook. In the first sheet I have a list of companies (A), and revenue (B). I want to add a third column and to look for the number of cards the company bought for the first time (second sheet). In the second sheet we have (A) companies, (B to AA), number of cards...

Alright guys… im struggling with this one, maybe I’ve been looking at it for too long… Background…. Panel A DOES Not have a built in Comm Card, but… Panel B has a built in Comm Card, Both panels can have multiple Comm Cards, the number of Comm Cards is dependent on the number of Com Devices...

Hi There I work at a large hospital and we have an issue with our door access system in regards to cards having duplicate doors placed on cards and this is causing some not to work. I have attached a sample which shows the cards with their contents. I need to reference each cards contents to a...

I have a column with multiple values with some separated by a comma. I am using a COUNTIF function to get the count of values - for example, I have a worksheet "Data" from where I am pulling the data as is shown in this formula: =COUNTIF(Data!D:D,"*Gift cards*") I am putting the "*" before...

I am attempting to search for a file using wild cards but am having trouble making it work. I get the Run-time error '52' Bad File name or number Here is my code Sub OpenFiles() Dim MyFolder As String Dim MyFile As String MyFolder =...

Hi All, I'm not sure how to tackle this problem and thought you might have a really simple way of doing this, I'm guessing its a common problem. There is a master excel sheet (Process card log), and 1000's of process cards each one an individual excel document. Currently the user spends a...

Hello, How do I write a code to highlight everything, including the blank lines? I need to highlight and copy everything in B1:E7, and I seem to be stuck at just highlighting B1:E2. ActiveCell.CurrentRegion.Select isn't giving me much joy. I'm stuck in a virtual loop! Thanks for your help...

Hello, How do I write a formula to: 1. Determine if a cell is labelled "Cash", "Cheque" or "EFT" 2. If it is then I need to concatenate certain cells together. Example: Thanks for your help. Best wishes, Peggy <tbody> A B C D E F 1 Cash Stationery {formula = }Cash - Stationery 2...

I have a few questions and hopefully someone can help me. I am trying to learn how to do some new things in excel and after searching on the net I was unable to find the right answer I was looking for. So with that being said here is a link to the spreadsheet I am working on the questions I...

Hello I am logging training cards on a spreadsheet daily. They are all number SCU001, SCU002 and on and on and every time someone visits I log their card number against the date of visit. Is it possible to have a pivot that shows the date then the count of new cards issued that day? I am not...