Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-13-2020, 03:57 AM
ganesang ganesang is offline Transfer data to another book based on the active cell - Specific ranges only Windows XP Transfer data to another book based on the active cell - Specific ranges only Office 2016
Competent Performer
Transfer data to another book based on the active cell - Specific ranges only
 
Join Date: Jul 2018
Posts: 136
ganesang is on a distinguished road
Default Transfer data to another book based on the active cell - Specific ranges only

Hi Folks,



I need your help to automate this task based on the Excel VBA.

I have the master excel workbook named as "Maintracker" which needs to be move specific data ranges (ranges are dynamic so we have to select a range based on the current selection cell) in each row (F2:G2) based on the current cell selection to another respective workbook named as "SB" and "XT" vice vara if click the specific button in Maintracker we create.

I have attached the three sample files as mentioned above and highlighted in yellow.

In case I have new data in Maintracker which is also needed to move respective workbook based on the Main tracker workbook "Engine Name" column value (SB or XT) when I click the button at the end of the row in the respective workbook.

Additionally if try to copy any duplicate row Vb yes or no pop up will ask yo confirm.

Please review and let me know.

Advance thanks!!!

Ganesan. G
Attached Files
File Type: xlsx Maintracker.xlsx (10.8 KB, 6 views)
File Type: xlsx XT.xlsx (9.7 KB, 3 views)
File Type: xlsx SB.xlsx (9.7 KB, 3 views)

Last edited by ganesang; 03-13-2020 at 08:09 AM.
Reply With Quote
  #2  
Old 03-15-2020, 09:28 PM
ganesang ganesang is offline Transfer data to another book based on the active cell - Specific ranges only Windows XP Transfer data to another book based on the active cell - Specific ranges only Office 2016
Competent Performer
Transfer data to another book based on the active cell - Specific ranges only
 
Join Date: Jul 2018
Posts: 136
ganesang is on a distinguished road
Default

Hi Guys,

I have rewritten my words here more clearly to sort out a clear understanding.

I need the two-way transfer/copy some specific ranges of data as follows.

Maintracker to Sub-excel (SB or XT) ranges - (D:E:F)

Sub-level excels to Main-tracker ranges - (A:B:C) (from both SB and XT to the main tracker)

I have a master excel file (Maintracker) which has the data to be moved some specific ranges (E:F:G) to respective sub excel files (XT, SB) vice vara based on the current cursor position in master file column "E". Please refer the attached sample files for the references.

Also if any range of data duplicate if try to transfer both ways the msgbox alert (yes or no) will appear to confirm based on the column B value which has some time more than one check required.

Please help me out on this as soon as possible is great!!!
Reply With Quote
  #3  
Old 03-19-2020, 03:30 PM
BobBridges's Avatar
BobBridges BobBridges is offline Transfer data to another book based on the active cell - Specific ranges only Windows 7 64bit Transfer data to another book based on the active cell - Specific ranges only Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 674
BobBridges will become famous soon enoughBobBridges will become famous soon enough
Default

I'm afraid the second attempt isn't much clearer, but I hate seeing a question simply ignored :-). Let's see whether I can make sense of this.

You have three workbooks, named MainTracker, XT and SB.

There's a button (or maybe two buttons) in MainTracker. No, wait, I don't see any buttons there; maybe you meant you will create them. If you push one button, you want certain values to be copied from MainTracker to XT or SB; if you push the other button, you want the same ranges to be copied back into MainTracker from XT or SB.

You speak of the need to ask the user to confirm if there's a danger of copying duplicate information, but we'll have to save that for later; we'll do this a piece at a time.

The column headed "Job Name" in MainTracker evidently indicates which workbook should be the target and source of the copies; if Job Name is "XT" then Model and Location should be copied to (or from) the workbook named XT, and the same for "SB".

How am I doing so far? Is this even approximately correct?

And by the way, what language are you used to? Maybe it'll be something I'm halfway familiar with, in which case we can communicate better.
Reply With Quote
  #4  
Old 03-22-2020, 10:12 PM
ganesang ganesang is offline Transfer data to another book based on the active cell - Specific ranges only Windows XP Transfer data to another book based on the active cell - Specific ranges only Office 2016
Competent Performer
Transfer data to another book based on the active cell - Specific ranges only
 
Join Date: Jul 2018
Posts: 136
ganesang is on a distinguished road
Default

Hi Bob,

Thanks for the reply!!!

You correctly understood my concern.

Based on your question,

How am I doing so far? Is this even approximately correct?

As I mentioned earlier, the current cursor/cell position, the respective row's data range should copy to the respective workbook (XT or SB).

And by the way, what language are you used to?
I hope Excel VBA is a better language for this.

Please let me know if anything required.

Thanks in Advance!!!!
Ganesan. G
Reply With Quote
  #5  
Old 03-23-2020, 09:52 AM
BobBridges's Avatar
BobBridges BobBridges is offline Transfer data to another book based on the active cell - Specific ranges only Windows 7 64bit Transfer data to another book based on the active cell - Specific ranges only Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 674
BobBridges will become famous soon enoughBobBridges will become famous soon enough
Default

When I asked about languages I meant (for example) Bahasa. Or maybe Tamil? Just guessing. Neither one is among my accomplishments, so maybe we'll just have to stick to English.

Anyway, let's talk about the program: How much of it have you written so far? Which parts are working and which parts puzzle you?

If you're starting from the very beginning—if you don't know even how to start a VBA program in Excel—I'll have to start explaining from the beginning too. I want to know how much you already know, and have done, so I won't waste your time.
Reply With Quote
  #6  
Old 03-25-2020, 04:21 AM
ganesang ganesang is offline Transfer data to another book based on the active cell - Specific ranges only Windows XP Transfer data to another book based on the active cell - Specific ranges only Office 2016
Competent Performer
Transfer data to another book based on the active cell - Specific ranges only
 
Join Date: Jul 2018
Posts: 136
ganesang is on a distinguished road
Default

Again thanks for the response!! Bob

I am completely blind in excel VBA instead of using some excel functions to automate my simple tasks.

Actually, I need to transfer data from multiple excels to single (consolidate) file.

So, again I have explained a very straight forward and attached sample

I need to transfer the values from two kinds of excel to one consolidated excel file at the end of the row every time.

From these three files, the QA tracker is static and the other two files have dynamic values or files but the naming of the excels is not changed. So, if try to get values from two dynamics excels to one consolidated file for respective columns

I have highlighted in yellow in each file to identify.

If there is an option to get data from two excel files to on QA tracker using Button is best for me!

Please let me know if you need anything further.

Thanks in advance!
Ganesan. G
Attached Files
File Type: xlsx Defect Checklist.xlsx (18.1 KB, 1 views)
File Type: xlsx Opportunity for Error Summary Master_v2.xlsx (19.4 KB, 1 views)
File Type: xlsx QA Tracker.xlsx (26.0 KB, 1 views)
Reply With Quote
  #7  
Old 03-27-2020, 05:28 PM
BobBridges's Avatar
BobBridges BobBridges is offline Transfer data to another book based on the active cell - Specific ranges only Windows 7 64bit Transfer data to another book based on the active cell - Specific ranges only Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 674
BobBridges will become famous soon enoughBobBridges will become famous soon enough
Default

Sorry for the delay, ganesang. I take it "completely blind" means you've never written an Excel program before, and don't know anything about it. But if you want to write this program, you'll have to learn. I don't mind coaching you, but if you'd rather not do that—if you're hoping someone will write it for you—I recommend you repost your question and hope someone else will answer. I'll leave the post alone, if you do that, so other people won't see my response and think your question is answered already.

But if you want to learn to write programs, let me know and I'll teach you, one step at a time.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I transfer specific data from email to specific excel cells? Mauro Outlook 1 11-11-2019 09:17 PM
Use of named ranges based on cell content Intruder Excel 12 02-25-2019 09:42 AM
Transfer data to another book based on the active cell - Specific ranges only VBA to Insert variable rows based on a data in active cell Marcia Excel Programming 4 07-28-2018 10:02 AM
Ranges that Grow Based on Data TheThack Excel 1 07-27-2016 11:36 AM
Transfer data to another book based on the active cell - Specific ranges only Data Validation List based on Two Named Ranges Rich18144 Excel 4 01-14-2016 04:37 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 12:11 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft