transfer

Hi all. I have a spreadsheet that i use to keep track of my sales accounts. On that sheet I have dates that actions need to be done. I,m trying to find out if there is a way of either creating some sort of notification, that would appear when i open the sheet, or that could transfer the...

I have data of of over 2000 workers on Sheet1. I want to transfered filtered Data to Sheet2. Data of Sheet1 from A2 to D2 should transfer as it is. Remaining data in Column E2:E13 on Sheet1 should transfer to Sheet2 to G1:R1 And data in Column F2:F13 on Sheet1 should transfer to Sheet2 to...

Hi, can someone assist with the a formula for the 2nd example : <tbody> B C D E F G H I K 2 Description Property vat Dr vat Credit vat Bank Transfer 3 Transfer Eaton 100.00 -100.00 100.00 </tbody> Formula does work in cell k3...

Hi all, I'm working on transferring data from one workbook to another, easy enough - but does anyone have any idea on how to transfer data and place into a name range? (i'm looking to pull string from input box which specifies the name range) thanks Fwiz

Hi, I'm looking for a formula that will transfer those cells data into 1 cell with 1 space between the date and the first digit and separated by a (-) between the 2 other digits. Thank you.Excel WorkbookBCDEFG210/20/201753010/20/17 5-3-0Sheet

<tbody> Status Date of joining Date of transfer Date of resign formula Active 1/1/18 =IF(ISNUMBER([@[Date of Leaving]]),"Resigned","Active") Resigned 1/1/18 1/31/18 <tbody> =IF(ISNUMBER([@[Date of Leaving]]),"Resigned","Active") </tbody> Transfer 1/1/18 1/15/18 Combined formula...

Hello everyone and thanks in advance for your help. I have a query that pulls in the banking activity each month and compares it to the prior months' activity using a pivot table. This works well as long as the items are named consistently at the bank. There are a few items where each...

<tbody> 18/12/2017 $ £ EUR NOK Receipts 680 Payments 350 Interco transfer 50 B transfer Other 500 3,000 19/12/2017 $ £ EUR NOK Receipts 590 Payments 350 Interco transfer 50 B transfer Other...

Hello, I am hoping someone can assist meplease with my project. I have two sheets with info incolumns . In sheet one the info spreads fromA-N. In col S and T “yes” is placed if certain criteria is met. In sheet two info spreads from A-Q.In col R if certain criteria is met a “yes” is inserted...

Hi, i hardly use Excel so only have very basic knowledge. I have to transfer inventory numbers digitially filled in by an employee on one table, and transfer them to the correct location on a master inventory table based on Item ID numbers. The order of the items on each table do not match each...

<tbody> Week Ending : Friday 20 Oct 2017 Supplier 1515 Purchase Order 2626 Date Detail / Course TrainingParent Sub Ground Sch / Device Time Training Venue Further Info Hours rate (£) cost (£) GL Code 15 Oct 2017...

i was looking for emergency help if i click "Command Button"i like to transfer data from 1sheet to multiple sheets I have INPUT sheet:which have data in B1:B4 if the name is B6=Ballon then transfer data to "Ballon" sheet the data in B1:B4 if B6=Umbrella then transfer data to "Umbrella" sheet the...

Hellow to the forum Ok, this must be easier than my previous task. I have vba generated below data range from multiple worksheets. Every time i add results, i hit the update button placed in this Master Sheet and automatically clear contents and merge the updated ranges. The next step is to...

Here is my story: I have many tabs, mostly irrelevant, and I am trying to create a workbook that has two parts - hence the tabs- input and output. In the input pages I am actually importing data from a CSV files that vary by rows, columns, and "table titles". I have tried using formulas and VBA...

Hi I'd like to create a form that will transfer the data entered to a hidden spreadsheet so that only I can see all the entries that have been made. I've had a look at various youtube clips and kind of get the impression it's either a userform or data entry form that I need to create and...

I am using code to transfer data that don't have a blank cell in column A from "Data" to "ForIndustry". While the code works, I would like to only transfer columns A:P rather than the whole row. Any guidance would be much appreciated. Sub transfer() Set i = Sheets("Data") Set e =...

Greetings, below is a snippet of code from a userform that we have been using for a while. The form has a multitude of textboxes that the user enter data into, and then these textbox values get passed to a worksheet; pretty standard stuff and it works fine. They just asked me if I could change...

I have a general template I use to input client data that is set up so that rows with empty cells in a certain column (i.e., there is no data for particular variable for a client) are deleted. For example, if there is no data entered in say G27 for a variable listed in A27 then row 27 is...

I wanted to set the file name as variable so that I can copy value from various workbooks to one workbook. While I executed the code below, it asks for name of the file three time. But All I want is one at a time to fill three cells. what's wrong with my code? Thanks! Lan...

Hi All, I need some help from you guys to sort this issue out: I'm trying to transfer data from my excel sheet to my SQL table using VBA with the loop in it which gets triggered by hitting SAVE button, my sheet looks as follows: <tbody> Date Day Name Day Name 02/01/2017 ES TMS...