transfer

Hi! First time poster, and absolute amateur at Excel ? I've been trying to work this out for a while but I really don't know where to begin, so apologies if this has been asked in other terms. I need help transposing the contents of one sheet into another sheet where the columns and rows are...

Hi, I have a userform which has Comboboxes for which i select an item from the drop down list. Once all the boxes are complete i then click my transfer button to entere it on my worksheet. This is the code on my transfer button. Private Sub CommandButton1_Click() Dim i As Integer Dim...

Hi, The code in use is shown below. This is how it works. I have a listbox with customers names. I select a name & when i press the DateTransferButton todays date then is entered into the cell for this customer at colomn G I believe at present if a value is in the G cell then i see a message...

Hi all, Still learning VBA and this may be a really basic question for all, but I am struggling to find the answer while surfing. Would really appreciate some simple explained help to learn. TASK I want to transfer data from one workbook to another. using a "transfer tool" which i can email...

I'm trying to count the number of times a word appears within a phrase. Each row lists an action taken by an agent (i.e. Policy: Transfer / Sellers). I'm trying to use COUNTIF to count how many of the row contain a specific word, like "Transfer" but it keeps giving the result as zero. I...

All, I'm trying transfer data from one sheet to another. Doesn't seem to be working. Worksheets("Sheet1").Cells(Rows.Count, "F2").End(xlDown).Row.Value = Worksheets("Sheet2").Range("B5").Value Any idea what im missing?:confused:

Hi, I'm having a bit of trouble with this, which I thought would be fairly simply. But apparently not simple for me if anyone can help please? I have a worksheet like below... And when I press the macro I want it to transfer the data above to populate another worksheet so it looks like the...

Good day guys! For example i have a set of data from sheet1 from column 1 to 10 A1 0 B1 0 C1 0 D1 2 E1 34 F1 65 G1 32 H1 23 I1 15 J1 90 How can I transfer it to Sheet 2 and it will: *transfered all values to rows *it will transfer all values starting with the non zero value(in my example it...

Hi, I am thinking of incorporating the ROBOCOPY with excel since I am doing a lot of file transfers. I just have no idea where to start. I would like to be able to enter a source and destination path into a cell then maybe some radio button or any kind of selection depending on what specific...

Hi, I believe the code supplied below is what you require. I have a worksheet database where i send out parcels to customers & once parcel is received i like to make a note of the date on my database. I have a drop down list on my userform which looks at the worksheet & loads any customers name...

I'm trying to set up a table that has a date, then different expenses on each date. Ultimately I would like to reference expenses on each day for specific expenses. Maybe the last 10 days of "Voids", a double vlookup that could find the date, then the void and return the column value. There...

Hi.. I have this code below that transfer my "Textbox1" to "Textbox20" to column A. I have another set of Textboxes ("DataBox1" to "Databox20") that i need to transfer to Column B. can anyone help me on this. Thanks Dim lrow As Long, i As Long lrow = Cells(Rows.Count, "A").End(xlUp).Row +...

Hi all, I am currently working on an order form for our warehouse. I have a master sheet (Template) which holds all the current items we stock. When entering the quantity to be ordered on the master sheet, it is transferred to the Order Form. Here is the code used for the transfer of data...

Hello Freinds, I'm working on a data were in B columns I'm having "Recharge" Or "Transfer". I'm using IF formula to calculate the Transfer commission. If " Recharge" Is there, then the commission should be "0". Can anyone help to get this formula.

Evening, I am using the code supplied below. On my worksheet i have a date transfer button. What shappens is the customers receives his parcel. I open my userform & in the drop down list select that customers name. I then press the date transfer button & todays date is then put in the cell in...

Good morning, I have a userform which has a drop down list complete with customers names. I use this to then add a date to that customer. This is an example of what i do, I see that the customer has received his parcel so i select his name from the drop down list & then i press my transfer...

Afternoon, The current working code is supplied below, Basically it allows me to keep certain information about my customers with regards their purchase from me. Currently it works like this. I enter the new customers name in TextBox 2 like example JOHN SMITH "this is his first purchase" I...

hi guys i have some datas and coordinates in sheet1 and i have macro buttons to transfer to sheet2 here my code doesn't well work transfer some of data but not all i would in every time to fill data in sheet1 transfer to sheet2 every thing data an coordinate like color Sub...

I have a table that I need transferred into another format. All the information stays the same but it will have a different logic: rows become columns and vice versa. This is a table with a LOT of data so I can't do it manually. What is the easiest way to do this? I'm thinking a formula that...

Hey Guys, I'm wonderng if it is possible to transfer data from exel vba to multipe HTML Input boxes? I would like to replicate the HTML Form onto an Excel UserForm which will be used to automatically generate data. I woud then like to have a button_click on the userform to transfer the UserForm...