card

  1. A

    Copying multiple rows of data and create a different spreadsheet per row

    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()...
  2. C

    Binary Data

    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...
  3. Johnny Thunder

    VBA Help - If Cell Contains Partial String Then.......

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

    change column headings to inches

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

    Categorize credit card transaction details by predefined buckets (e.g. gas, food, entertainment, etc.)

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

    IF or something else?

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

    Transfer of data

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

    Printing Multiple PDF Files and Saving with Different Filenames

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

    VBA code - organize data

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

    Wild Card in SUMPRODUCT formula search

    =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...
  11. R

    how much to invest system on pdf unique password protected like credit card statement?

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

    credit card conundrum

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

    If/and statement assistance, looking at mulitple cells as reference...

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

    Computation of student Annual Average Sore and Grade

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

    How to achieve this in Excel

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

    Index Match Formula?

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

    Clearing cells based on a variable

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

    Convert a old chart of accounts to a new one

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

    VBA to transpose and delete data

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

    Copying Information From Multiple Workbooks Into One Master

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

Some videos you may like

This Week's Hot Topics

Top