transfer data

I am looking for a way to transfer the data using a formula to accomplish this: <!--StartFragment--> <colgroup><col width="65" span="3" style="width:65pt"> </colgroup><tbody> A B C First x First Second Third Third x Fourth Fourth x Fifth...

Hi all, New here so first of all hello to everyone. I have popped in here to see common problems and answers before so thank for you help there. But, now I have a good one for you all and I hope you can help me. I have a report that I want to run every 3 months for my staff. I have a template...

I'm trying to create a worksheet where the user is able to import data from a file of their choosing into a worksheet I created by clicking a button. In the file they want to import, all the rows have different variables but the columns are specific categories. In the worksheet I want to...

<tbody> Expense Food drinks 1. Food Bread Bread Rice Rice Drink Water Water 2 drink Juice Juice Food Pasta Pasta 3 foOd Meat Meat Drinks Coffee Coffee </tbody> HI, I hope you could help. i have 1 column and it...

I don't have a very extensive background with excel, and no background with macros, but I have the feeling I will need to use a Macro to carry out the task in question.. I have two workbooks; one that serves as a database for all the materials my company ever uses, and another that servers as...

Hello all! I am new at VBA, so any help is much appreciated. Here is a summary of what I'd like the end result of this project to be: When I open Workbook A, Macro #1 automatically runs as the file is opening. This macro will analyze the contents of the "Seed Folder" (through Windows...

Hey guys, first and foremost. ALL YOU GUYS ARE AMAZING! I've learned so much from this site (more or less VBA newb) and I just have to say, I am thoroughly impressed with how helpful everybody is on here. Really really awesome! Ok, time for my issue! I am improving a quote spreadsheet I made for...

I am after two things here: 1: An assessment of what I am trying to do would be feasible in any way using excel? 2: If it can be done, then a solution to the issue or some hints on where to start. What I want to achieve: I want users to give input in five cells on an excel sheet like this...

Hey I’m about to make a macro that transfer a Range of data from Sheet1 to Sheet2 in the excel. The transfer should take place for each row if a requirement is met. More specific if the data on Sheet1 is for example: Staff hours Consulting hours Driving Test Staff hours In the macro it...

Hey I’m about to make a macro that transfer a Range of data from Sheet1 to Sheet2 in the excel. The transfer should take place for each row if a requirement is met. More specific if the data on Sheet1 is for example: Staff hours Consulting hours Driving Test Staff hours In...

Hello all, I have read through a hundred posts and thats why I'm here. Apologies to the readers of redundant posts but I can't seem to get any functions to work. So here goes ... I have sheet2 which has data I need transferred to sheet1. Both sheet1 and sheet2 have a common field, product #...

Hello, I have absolutely no training in VBA and have been able to piece together responses from this board previously to achieve my desired result. However, I've run into an issue that is beyond my piecemeal process. My current workbook has a master data sheet that is a register of the main...

I am looking for information on how I can use the Transfer Data from System i Add-In for Excel to only get data that equals the data in one of my columns (both sets of data are strings). Unfortunately, I cannot just get the entire contents of the System i table since it contains more than the...

Hello. This is my fist posting on this forum, and first posting on any forum for that matter. I have been trying for some time to export the value in my access field into an excel cell. The user will dblclick a hyperlink, which will open the corresponding file, as well open an excel template...

Hello, hoping I can get some help with this problem. I am trying to make it so I can copy some data in an excel worksheet and transfer it to an existing table in Access. I was this to overwrite all the data in the access table with the new information from excel. I would like all of this to be...

<HR style="BACKGROUND-COLOR: #ffffff; COLOR: #ffffff" SIZE=1><!-- / icon and title --><!-- message --> With some collegues we created a worksbook in order to calculate the final grades that a teacher needs for the students in his/her class. It starts with a sheet in which the teacher identifies...

Hey guys, this is my first post and I really hope someone will be able to help me. So here is a little background on my project. I am an environmental engineer doing different risk/health assessments on various sites. My excel (2007) file has 4 sheets. The first three are based on increasing...

Hi, I created a series of custom quick parts on Word 2007 and I need to distribute these quick parts to other computers. I saved the custom quick parts in Normal.dotm and have emailed that folder to other computers and saved over that computer's normal.dotm found in...

Hi, I need some help!!! I have a workbook for when my staff make errors. My admin person will complete the log by filling in data from paper logs. What I have so far is a primitive spreadsheet where you put the number of errors in a particular cell, against an operator name. I have copied a...