information

Every morning I have to manually copy and paste information from cells because VLOOKUP doesn't carry over formatting. I am very beginner to VBA.... Basically I have cells that contain information laid out like such: <tbody> Product Name DOCKET ABC <del>1234</del>TEST BCD 2345 TEST...

I have a worksheet with Customer Information. In Columns D-T is the Customers information Headers address, phone, email, etc. In column D are the Customers ID #'s I would like to take the Customer ID# for the selected customer and show it in Cell B2 . Is there a way to do this? I have attached a...

Hello everyone, Today I want to make a sheet that contains all the information about coinflips. I am playing a game where coinflipping is a thing and i'm quite addicted to it. Now there is kind of a tactic to get good guesses at it and a big help would be tracking down information. However I...

Hi all, We get information sent to us in a text format and I'm looking to put this into a more manageable and easier to sort method. It is staffs shift pattern and is laid out as below. A1 = 9.30am to 5.30pm B1 = 5:00PM (B1 = commitment time) Ideally I would like A2 to pull out the start...

Hello, I am very new at writing vba. I copied a code that takes information entered from one workbook by hitting the submit button it then takes my data, opens the master log, transfers the data onto the worksheet horizontally, saves and closes both workbooks. example below of code being used...

Hi, Can someone please help me with this doubt? I have in worksheet1 these columns: Product: A, B,C Code: 11111, 22222, 33333 Jan-19: 2, , 3 Feb-19: Mar-19:1,8,9 ... Dec-19:5, , In worksheet2, I have the same product and code information. I would like to get the last moth where it was a...

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 would like to create a table of selected information from a tracking sheet i have. basically the tracker is a vehicle to store all requests that i get in for documents of information. i would like to create a priorty table on a seperate sheet so i can see which ones require working...

Hi, Firstly, apologies I am not an advanced Excel user, so please excuse any obvious gaps in knowledge. Essentially, I am using a TimeLine to select a month that adjusts Pivot table information - easy enough! However, I need to extract the month selected in order to apply to a simple...

If cell A1 contains information from and cell in column C return value in column D at the same row as information. <tbody> Woolworths W7001 Sandy Bay 2004 United 2001 Dr Jay 2002 Sandy Bay Newsagent 2003 W7001 2004 Coles 2005 </tbody> Thanks for your help!

Hello all, I have the following code that i have been piecing together in order to use excel cells to fill in a word document i have several text form fields. Now this is a sub macro within a larger program. The main information that come in is the Target.row information which gives us the...

I have an excel calendar (Sunday-B1 through Monday-H1). Each day has four horizontal cells in to allow for several entries. For example, Wednesday the 1st uses E2-E5, Thursday is F2-F5. The next Wednesday would be E6-E9 and so on. In those cells, I have names of meetings. What I would like to do...

hello all, so i have a few excel sheets that have information on them. each excel sheet is an purchase order. in them it has all item information with sku cases QTY unit QTY and pricing and more. so i have a few excel sheets each one is a diffrent order for a diffrent factory. what i want to do...

I'm building a Rent Sheet. I'm using a UserForm to gather information (i.e. Lot#, Amount Paid, Check#, etc.) I would like to use the Lot # as a reference for my table. Example: If I enter Lot# 32 and click 'Submit', then the information starts at cell N34 (The starting cell of information for...

I currently have an excel workbook and sheet that allows me to use simple functions like (If(ISNA(VLOOKUP)) where I only have to enter an employees' badge # and the rest of their information populates to the right of their badge # (to include the time of the inputted badge #, meaning the time...

Given pratings, a range, I can find the absolute range address, the number of rows and columns, and the number of the first row and column. ?pratings.address $D$5:$G$14 ?pratings.rows.count 10 ?pratings.columns.count 4 ?pratings.row 5 ?pratings.column 4 Are there expressions...

I am in the process of creating a spreadsheet that will be used to track the development of a new employee over a period of weeks, based on certain criteria that will be identical for each week of their development. From the base information, I have created other sheets in the workbook that...

the code below basically takes information from the main page creates new sheets and pastes them into separate sheets depending on the content of A. it starts pasting them on row 6. it pastes them in the following order A into A B into B O into C how can I get it to go into the following...

Long story, but will try to make the explanation brief. I work with an individual customer and provide information on a daily basis. normally we enter our info into a database and the customer imports into their own and then does what they want with the data. This particular customer (same corp...

I've set up a workflow where the users needs to log selected information from a system generated file name. Currently they single click twice on the file name (within File Explorer) and copy that file name into the clipboard. Then I have a VBA routine that when run, takes the information from...