Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-25-2013, 02:18 PM
Mrkieth Mrkieth is offline Populate Data to another cell Windows 7 32bit Populate Data to another cell Office 2007
Novice
Populate Data to another cell
 
Join Date: Jan 2012
Location: Toledo, OH
Posts: 5
Mrkieth is on a distinguished road
Default Populate Data to another cell


Forum, I need help with trying to lookup a value in one cell, but place the value in another cell. But without using the formula in the second cell. Meaning lookup A1 Then place the value in B2, but i don't want the formula in B2. Is this Possible ?
Reply With Quote
  #2  
Old 04-29-2013, 06:42 AM
OTPM OTPM is offline Populate Data to another cell Windows 7 32bit Populate Data to another cell Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
You would have to have "a" formula in the result column. There is no way, without using VBA, that you could have the result of a formula populate anopther adjacent cell.
Tony
Reply With Quote
  #3  
Old 04-29-2013, 07:30 AM
Mrkieth Mrkieth is offline Populate Data to another cell Windows 7 32bit Populate Data to another cell Office 2007
Novice
Populate Data to another cell
 
Join Date: Jan 2012
Location: Toledo, OH
Posts: 5
Mrkieth is on a distinguished road
Default

Quote:
Originally Posted by OTPM View Post
Hi
You would have to have "a" formula in the result column. There is no way, without using VBA, that you could have the result of a formula populate anopther adjacent cell.
Tony
Tony,

Thanks for you help. I believe i'll a different path. I'll try creating a form in VBA and create a command button and see what happens.

Thanks again for you help.
Reply With Quote
Reply

Tags
formula, vba excel

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto populate invoice (including description) from data sheet agenevieve Excel 2 12-06-2012 04:48 AM
Looking up data and populate a new sheet Boatwrenchv8 Excel 4 04-13-2012 05:56 PM
Populate dropdown list with data from Access table spw4000 Office 0 02-24-2012 05:22 AM
Move data from 1 cell to another cell Catalin.B Excel 1 06-25-2011 12:51 PM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:22 PM.


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