card

I will try and explain as best as I can.. Basically, the company I work for needs a way to copy the data from a worksheet and paste it into a job card... At the moment, I have only managed to be able to write the VB so it creates one job card at a time (see below) Sub CreateJobCard()...

I have exported a card database(600 cards) into excel from a security system to upgrade to a newer card reader system. However, the proper and new card reader system reads the card data in reverse. So I have dumped the data in an excel spreadsheet to sort the data around and import to new...

Hello all, Have a question that I thought I could easily answer but for whatever reason it doesn't seem to be working so another pair of eyes may help. I have a For Each Cell in Range Statement that looks at a Doc Type (2 Digit Variable) and when it finds "KR" to Search a Offset Cell for...

Hi i'm using 365 I sort a remember that in older versions of excel, I was able to change the A,B,C, and the 1,2,3,to inches. Was I dreaming? I'm trying to make a business card and i don't want to keep changing the fonts and printing them till i get the size right. mike

Hi folks, I want to do a pivot table based on credit card transaction data that is categorized - obviously the raw transaction data won't make for a very good pivot table since it's not categorized... When downloading a credit card stmt in csv I get transaction data something like below (blank...

Hello! Im glad I found this forum, because Im pretty new to Excel, but I need to start learning it. Please let me know if I need to change how I attached a photo of the table. I am trying to figure out how to take a column of numbers and multiply them by 2.75%, but I only need the formula to...

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 have an Excel macro to print music bingo cards that does the following: Randomly chooses 25 songs from a list of x number of songs, fills in the cells of a 5x5 grid Refreshes the card, which again chooses 25 random song title to fill the card Repeats based on the quantity I choose...

I'm looking for someone to help me with VBA code so I click a button and my sheet 1 becomes organized like the data in Sheet 2 I would want the data in Column A,B,C to be used and added to the end of column D. Key Points, I would want Groomsman converted to the letter "g" Best Man converted...

=SUMPRODUCT(--('2019 Sales'!$CR$1:$CR$1055<>"IND")*--('2019 Sales'!$D$1:$D$1055=$A$2)*--('2019 Sales'!$B$16:$BY$16=BX$1)*--('2019 Sales'!$B$17:$BY$17=$A3),'2019 Sales'!$B$1:$BY$1055) Using the above SUMPRODUCT formula - where I have "IND" aim is to sum everything excluding any matches to IND...

Hi All, i know this is out from excel topic, but idk where to search, how much to get a system that can generate a unique password protected pdf like a credit card statement? i know there's an option using excel macro, i just wondering how much is the difference on the investment? if you know...

Hello everyone, I’d really appreciate your help with this problem please… We are managing our business spending across 4 credit cards. Each credit card has a different limit. The total limit is £54,000 Every time one of the cards hits it’s credit limit, we move spending to the next card in...

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

Hello, I thought I was done with my school application project,until I was challenged with another task. In the application there is a report card that shows the first term,second term and third term report when you click "Open Report Card" in the form "frmStudent" a dialog form pops up to...

<colgroup><col><col><col><col span="2"><col><col span="4"></colgroup><tbody> Site Name Transaction_End Sales_Mix_Ind Payment_Method Payment_method_Std Fuel or CR Fuel CR ES Card Sedgemoor South 20/05/2018 00:09 F Euroshell CRT 2 ES Sedgemoor South 20/05/2018 00:09 C British Pounds...

Hello, I'm trying to pull what a service rate would be based on a position and a specific rate card. For instance I have a list of titles and rates, and a list of titles and rates under different rate cards. I am looking to pull back the rate for a title under a specific rate card. Sheet 1...

Hello, How would I be able to clear the contents of adjacent cells based on the value in another? For instance if VDS column value is bigger than zero like 2, then cells B1 and B2 shall be cleared from their existing content that is currently "Good". If value is 4, then 1st 4 cells shall be...

<tbody> <colgroup><col><col><col><col><col></colgroup><tbody> OLD NEW Account Description Account Description 042101002 House Fund - General Cashier 1000 HOUSE FUNDS 042101003 House Fund - Human Resources 1010 BANK REVENUE ACCOUNT 042101004 House Fund - Materials Manager 1011...

Hello folks: I have recently been given a report and data layout is basically unusable. Here is the current output: <tbody> Last Name: Smith First Name: Jonathan Card Number: 1132 Employee Ref: 111222333 Last Name: Brown First Name: John Card Number: 2233 Employee...

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