card

Hey Folks, I'm trying to display only the value of 'Master List'!B:B where 'Dispatch'!$A$1 appears in 'Master List'!A:A. <tbody> Data on ''Master List' Sheet is manually altered Desired Display on Contracts Sheet Desired Display on Dispatch Sheet BD Orientation Business Cards Chevron...

Assalam u Alikum, Dear Team, thanks in advance for your support as usual, I am looking forward for the solution regarding card browser custom visual the problem I am facing is that when I drop the date field from my excel data in power bi SUB TITLE field its only displayed 3 cards, where ever...

Hello, I saw this post by DK340; I need a macro that will loops through each value in column (K:K) and if the value, for example K1, is equal to "Credit Card", it needs to find the value in column B of the same row (in this example B1) and copies this value and then pastes this into cell A19...

hi I want to place this array formula as it is too slow to process. please could you help me find an alternative solution formula {=MIN(IF($P$2:$P$50000=P3,IF($U$2:$U$50000<>"Fuel Card",$AM$2:$AM$50000)))} Many thanks

hi i have this how can insert this line $ " & Format(Range("b9").Value, "$#,##0.00;($#,##0.00)") into this line of code: strsub = "TNW a/c #" & " " & ThisWorkbook.Sheets("Icube").Range("A7").Value & " " & "and" & " " & " " & ThisWorkbook.Sheets("Icube").Range("A8").Value & ", " & "Credit...

Hello, I have a pivot table that pulls data from time card records for projects. Each project has several time card entries and I want to find the duration of a project based on the first time card entry (earliest date) and the last time card entry (last date) for each project. I have a pivot...

Hello all, I am working on a rate card for a client but stuck with how to formulate the summary, auto calculator page. I have basic level knowledge of Excel formula (tried using index match but seems like I am not good at that one !!) Data I have: 1. Drop down list of suppliers (out of 10) e.g...

Hello, I'm trying to figure out how I can click a command button that will select specific fields on one form and paste the values from those fields into another form with matching fields. I have a form that has another form laying over the top of it. The "base" form has records that I can...

I have bank statements that have some withdrawals (column G) in the deposit column (F). See example below. Can you PLEASE help me get these -$ figures into column G?! THANK YOU!!! <colgroup><col><col><col><col><col><col span="3"></colgroup><tbody> Post Date Transaction Description Account...

I am creating an excel form and associated data card in EPDM. I am planning on being able to enter most if not all data into the data card and have it go into the form as well as fill in the form and have the info go into the data card. EPDM data cards contain variables that a write to custom...

I need a big help on this I have a spreadsheet called "2017 Funds Journal" and that is where I enter all order for the whole year, another department needs the invoice number and order amount from this spreadsheet so they can upload for invoice processing. Instead of having to update this file...

I am a VERY beginner on macro's and can read minimal coding of a macro. I found a macro on the internet that is supposed to clear the contents of all rows that contain specific data in a specific column. Of course, I had to modify the coding to match what my data. My data starts on row 8...

Hello. Please see my SQL below. Everything is working fine, except I have to account for duplicates. What I want to do: If there are duplicate Member Number fields, then sequentially use L25 for the first one, L26 for the second, so on and so forth. Any ideas? Thanks. SELECT...

My code worked great until I finished it for 35 students. Now I get the procedure too large error, and I'm too much a novice in VBA for Excel to correctly figure this out. I have Sheet 1 that teachers will input a last name and a first name for each student. Student 1 starts on row 9 all the...

Currently I am using this for the Military time as a format for the cell 00\;00 or 00\00 but I want to add hours in there but not mess up the capability for me to sum the hours on the time card. Is there a way to do this? Let me know - Thanks for your Heeeeellllllpppppp Take Care.

Hi All! I'm really hoping someone can help me with this! I have a bingo card spreadsheet that I use for music bingo. It works like this: I paste in a list of 75 songs into sheet 1, hit F9 to refresh, and a bingo card on sheet 2 gets randomly populated with 25 of the songs. I then hit Control-P...

Is the a way to convert a pdf file to Excel - At work we are given job cards in pdf format and I have written a shift pattern and on any given day would like to hyperlink that day to the job card. I have tried many suggestions by Google, used many of the free site 'converters' but at best, when...

I use a key machine which has a 2gb sd card inside. When i put the sd card into the pc it is shown as FAT. The order of the files are perfect of the alphabetical order. The problem i see is when i put it back into the key machine the order isnt the same as pc and out of sync. Anybody advise me...