Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 11-15-2022, 03:00 AM
p45cal's Avatar
p45cal p45cal is offline Copy Data by month to table using Inputbox with Add or Delete Row Windows 10 Copy Data by month to table using Inputbox with Add or Delete Row Office 2019
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Quote:
Originally Posted by CemHyur View Post
This is not showing Des. Value, It will show after double clicking on cell, Si i have to click on every cell of that row?
Either: right-click on the cell you're double-clicking on, then:


2022-11-15_094254.png


Or: merely select the cell you're currently double-clicking on, then:

2022-11-15_094752.png

Quote:
Originally Posted by CemHyur View Post
This is not updating automatic or manual, Means I have change data in Wrking Sheet it is not updating in Pivot Table. So is there any way to refresh or regenerate to do after changes made in data?
Either:

2022-11-15_095141.png

Or right-click anywhere in the pivot and choose Refresh.

Quote:
Originally Posted by CemHyur View Post
Remark and other things will type manually, so can add extra column next to table, will make any effect to table?
No except that it might stop it expanding to the right if you want to add more columns to it, but more importantly, the comments will not move with rows added/removed when the source data changes and you refresh the pivot. That's why I suggested you copy/paste|Values the pivot to another location which then can't be refreshed, then you can add your comments there.
You could, instead of adding the comments to the pivot table, add them to the source data and include the comments in the pivot table.
Reply With Quote
 

Tags
copy data by month, copy data to name ranges, copy data usinf inputbox



Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Data by month to table using Inputbox with Add or Delete Row Table Merge _ Auto Delete Blank Lines (without Data) Alex1s85 Mail Merge 7 05-04-2020 05:12 AM
Copy Data from different areas in a worksheet into a Table Josh1012 Excel Programming 2 09-20-2018 01:51 AM
copy data table from pdf to excel DIMI Excel 1 07-10-2018 11:40 PM
Copy Data by month to table using Inputbox with Add or Delete Row Delete table if cell has data So New2 This Word VBA 1 05-06-2013 09:00 PM
Copy Data by month to table using Inputbox with Add or Delete Row Copy/Paste/Delete Table & Section etc. flds Word VBA 40 07-16-2011 07:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:27 PM.


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