Search : in
By :

Copy required data from one excel to anther

Last answer on Jun 5, 2009 9:58:21 pm BST Aman P., on May 15, 2009 4:53:42 am BST 
 Report this message to moderators

Hello,
i want to copy only required feilds's data from one excel sheet to another.
suppoes there are 5 feilds in the excels ,now i want to use only three feilds ant then place it in new excel sheet
the important aspect is that i cannot use ADO and i need to do it with the help of VB 6.0

Configuration: Windows XP Internet Explorer 6.0

Best answers for « copy required data from one excel to anther » in :
Transferring data from one hard drive to another ShowTransferring data from one hard drive to another First of all you should use some tools.. transfering data from one hard drive to another is quite simple. Once you have connected the new hard drive to your pc, check your...
Excel – How to extract partial data? ShowExcel – How to extract partial data? Issue Solution Note Issue I have an Excel spreadsheet that contains around 1500 html links. All the addresses start out common... i.e. http://www.frogs.com/. What I want to extract into another...
Import contacts from Excel to Outlook ShowImport contacts from Excel to Outlook Issue Solution Issue How to import a contact list from Excel to Outlook and having them in a single list of contact , and not as splited items? Solution By using the software Excel 2000 and...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Ask your question Reply

1

 ray, on Jun 5, 2009 9:58:21 pm BST
  • +3

<gras>Hi,

I've numbers of excel sheets and one cell needs 2 b updated on an another excel sheet. This is not working when i've been using the excel formula cos this is not getting automatically updated on the required sheet, it gets updated only when it is open for the first time (ask UPDATE,when linked to all sheets) and it does not reflects the new data entered on the sheets when data gets update on them on an active time. Please help me with a VB formula so that when i click on the command button it import all data from those cells and update on the sheet i need. Example--

Suppose there are excel sheets like sheet1, sheet2, sheet3 etc. which are on use by people (active users) and i need data from sheet1 cell A1, sheet2 cell A1 and sheet3 cell A1 to b updated on an another excel sheetX cell A1,A2,A3..etc...when clicked on the VB command button. This is very urgent. Please help me to solve this problem.

Thanks,
Ray

   
Reply to ray
Ask your question Reply
They need your help